Hi

In our application, we have editable datagrid, user can update edit multiple rows at once. When user clicks on save button, all the records should be updated simultaneously. On save button we want to use datatable/dataset apporach that is on click of save we want all records from grid in the form Datatable/Dataset for data we written following statement on save button click event:
DataTable dt = dgViewHedge.DataSource as DataTable;
but we got null in dt variable.
Basically our approach is to save all data in once. We want to pass datatable/dataset to dataadapter so it updates at once.

Is there any way, we can get all data from grid in the form of DataTable or Dataset.

With Regards

Sunder Ramani

The datasource property of the datagrid is only useful during the binding stage of your page. When you load the datatable, assign it to grid.DataSource, then bind. After page postbacks, the DataSource property will be null. The datagrid maintains the data internally without aid of the original data source. So you'll need to do one of two things:
1) Reload the datatable, then iterate thru the datagrid items and set the corresponding datatable values from the datagrid controls then call the datatable update method.
2) make simple database update calls for each row in the datagrid without using a datatable object. (That's what the data adapter is doing internally anyway when you provide it a datatable with changed rows and an UpdateCommand object.)

Hi

Thanks. I had implemented Incorporated your suggestion.

But what should be the best way to update data in a web application?
1) Row by Row ?
2) All data at once?

In most of the web applications I've worked on, I update one row of data or one set of related data at a time so I make simple SQL update/insert calls.

If you build a grid that is completely editable then you could loop thru all its items and do a bulk update.