Best way to save gridview columns to different database tables

[Sree]

Hello Team,
i have a grid with 6 different columns each should be saved in different database tables. my grid is having more than 30,000 records
is there any way to take gridview column data into temperory table and from there to insert into database tables
and  row level data saving is fine since it is single line update into database, where as  updating entire grid with 30,000 records, taking time to save

please suggest me

[Plamen]

Hello Lakshmi,

Thank you for writing.

RadGridView does not support join between two tables. RadGridView binds to collections of bindable types from many sources including:

• Array and ArrayList of simple types or custom objects.
• Generic Lists of simple types or custom objects.
• BindingList or other IBindingList implementations.
• Database data using DataTable, DataSet or DataReader components from a wide range of providers (MS SQL, Oracle, Access, anything accessible through OleDb).

RadGridView follows the standard Windows Forms data-binding model. It can data bind to any data-source implementing one of the following interfaces:

• IList interface for one-dimensional arrays.
• IListSource interface (like DataTable and DataSet classes).
• IBindingList interface. For example the generic BindingList<> class.
• IBindingListView interface. For example BindingSource class.

You could take a look at the following article about binding data from two tables in a single DataGridView, where you can find a sample implementation of a such functionality: http://www.codeproject.com/Articles/304297/Data-from-Two-Tables-in-a-Single-DataGridView

I hope this helps.

All the best,
Plamen
the Telerik team