why the UpdateCommand is not workable?

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?

Answer 1

User283571144 posted

Hi mengcp,

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

As far as I know, 'SqlDataSource.UpdateCommand' is a property of SqlDataSource,

According to your codes, you just set the SQL string that the 'SqlDataSource' control uses to update data in the underlying database.

So I suggest you could use 'SqlDataSource.Update' method to perform an update operation.

More details, you could refer to follow link and codes:

    Protected Sub Button1_Click(sender As Object, e As EventArgs)
        SqlDataSource1.UpdateCommand = "UPDATE [City] SET [City].[City]='%" & InputTextBox.Text & "%'"
        SqlDataSource1.Update()
    End Sub

Link:

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.update(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.updatecommand(v=vs.110).aspx

Best Regards,

Brando

 

Answer 2

User-1460471841 posted

my friend,

that is great!