Turns out to be way more difficult/inefficient that I thought.All the examples I found to do this type of thing, make the user click all the rows and them loop through every row to do an update. I want to execute a single SP and have all matching rows updated and then refresh the list.
In order to allow update, you have to capture the Row Updating event.
If you are in Edit Mode, Edit Templete will appear.
Find Control("cb1_PH"), Check Box) Dim Col1_APH = CType(Gridview1.
Find Control("cb1_APH"), Check Box) Dim Col1_TOIL = CType(Gridview1.
When the costing people are looking at the invoice it's usually obvious what the job no is (e.g. There can be many rows with the same Ref1 that needs editing (e.g 20 cartons with same Ref1).
I have an SP with 3 params (Old Ref, New Ref, inv No) that updates the Ref no for all records on that invoices: I figured a Grid View (with an sqldatasource) would be a nice way to present the data.
Storing datatable in View State is not a good practice as it increases the size of your page and reduces the performance, also View State can be deciphered on the client side, so the Data Table is not secure.
I removed everything I did with View State and edited the original post again with what I currently got. I cannot sort the Grid View because I'm trying to sort with Your code doesn't have Data Source ID.
I got this error message: You load your datatable from a table in sql server but you don't specify the primarykey of the datatable.
Add(dr) End Sub Private Sub btn Delete_Click(sender As Object, e As Event Args) Handles btn Delete. The add function seems doing well but the delete function makes me headache...
You probably just need to look at the link posted above and find your row another way.