RAD AJAX Tutorial RadGridServerSideAPI example

[Greg]

The tutorial has the following C# code to update a row in the database for the RadGridServerSideAPI example:

                //Update Query execution
                SqlDataSource1.UpdateCommand = "UPDATE Shippers set CompanyName='" + CompanyName + "',Phone='" + Phone + "'";
                SqlDataSource1.Update();

When I execute this all the rows are updated. Clearly a "WHERE ShipperID = @ShipperID" clause is missing. Shouldn't this be included in the UpdateCommand set on SqlDataSource1 or is there a way to get the data source to append this?

The delete command is similar.

[Sebastian]

Hello Greg,

Your remark for the missing WHERE clause is right on target! We will update the relevant content from the tutorial for its next versions. I updated your Telerik points for the feedback.

Best regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.