why the UpdateCommand is not workable? RRS feed

  • Question

  • User-1460471841 posted

    I make one button (named: InputButton) and want to have such function. when I click the button, the data will be updated on my database

    the table name is ProductList, and I want the column 'remark' will be updated by the new data for all rows. also the new data is in InputTextBox

    Protected Sub InputButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BulkInputButton.Click

        ProductListSqlDataSource.UpdateCommand = "UPDATE [ProductList] SET [remark] ='%" & InputTextBox.Text & "%'"

    End Sub

    however there is no error for the language, but it is not workable. what is the reason?

    Saturday, August 13, 2016 10:01 AM


All replies