Update Multiple records in the datagrid using asp.net and VB

[jllopez]

I need update multiple records in the datagrid but this is using ASP.net and VB, somebody that I can help?

[nateraaaa]

I need update multiple records in the datagrid but this is using ASP.net and VB, somebody that I can help?

There are a few ways to approach this. You can loop through your dataset and check for any changes. If changes are found you can then perform some type of validation on those changes and then call the DataSet.AcceptChanges method. Then call datagrid.DataBind again to rebind the updated dataset to your datagrid.

Another way to do this is to save the changes to your database using an update stored procedure. Then call another proc to populate your dataset. Assign this dataset to your datagrid and call DataBind.

I usually create a public void method to handle calling the proc that will populate your dataset and calling DataGrid.DataBind().

Hopefully this gets you on the right track

Nathan