Best way to save gridview columns to different database tables

2 posts, 0 answers
  1. Sree
    Sree avatar
    30 posts
    Member since:
    Dec 2012

    Posted 07 Jan 2013 Link to this post

    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
  2. Plamen
    Plamen avatar
    132 posts

    Posted 10 Jan 2013 Link to this post

    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:

    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:

    I hope this helps.

    All the best,
    the Telerik team
    Q3'12 SP1 of RadControls for WinForms is out now. See what's new.
Back to Top