Save data in bulk.

Question

I have a window having multiple tabs. Each tab having different grids. I want to save all changes on any tab on any grid in bulk. I mean I have one save button which will save all changes in any grid on any tab.

I think DataTables will work fine here.

Can you suggest me that it is good to use DataTables to ADD/Edit data and save data in bulk using these DataTables OR is there any better way to achieve this.

My DAL is generated from LLBLGen Pro (ORM) but you are open to suggest me a solution.

Thanks.

Edit: I am using Telerik controls so I can get all data in DataTable like

DataTable dtProducts = this.radGridView1.DataSource as DataTable;

Answer 1

please see this :

http://stackoverflow.com/questions/2332098/how-to-add-gridview-rows-to-a-datatable

maybe it is useful for you.