Problems with updating 1 row in gridview

[foocc]

Hi. I have a problem with gridview whereby when i want to update 1 row, other row changes as well.

For example, i change the quantity in row 1 from 1 to 2, but when i click on update, other row's 'quantity' change to 2 as well. In the source code for this page, i add UpdateCommand="UPDATE [Order_Details] SET [Quantity] = @Quantity" under <asp: SqlDataSource>

Without UpdateCommand="UPDATE [Order_Details] SET [Quantity] = @Quantity", this error will be shown when i click on 'update' button >>>
Updating is not supported by data source 'SqlDataSourceShoppingCart' unless UpdateCommand is specified.

Please help...When i edit a row, i only want to update tht particular row and not every row in the gridview.

Many thanks.

[jeffstl]

Hi. I have a problem with gridview whereby when i want to update 1 row, other row changes as well.

For example, i change the quantity in row 1 from 1 to 2, but when i click on update, other row's 'quantity' change to 2 as well. In the source code for this page, i add UpdateCommand="UPDATE [Order_Details] SET [Quantity] = @Quantity" under <asp: SqlDataSource>

Without UpdateCommand="UPDATE [Order_Details] SET [Quantity] = @Quantity", this error will be shown when i click on 'update' button >>>
Updating is not supported by data source 'SqlDataSourceShoppingCart' unless UpdateCommand is specified.

Please help...When i edit a row, i only want to update tht particular row and not every row in the gridview.

Many thanks.

You should research SQL a little more and table structure.

In order to update a single record your SQL has to specify that record using conditional WHERE clause.

UpdateCommand="UPDATE [Order_Details] SET [Quantity] = @Quantity WHERE QuantityID = " & RowQtyID & ""
 

This is just an example of what you should have to update a single row.

For more on using SQL go here
http://www.w3schools.com/sql/default.asp

[jhardman]

Hey, is this an ASP question or an ASP.NET question? Just asking because usually ASP developers don't use the phrase "gridview"

Jared