How to insert multiple rows from a DataTable to multiple database tables in one go ? RRS feed

  • Question

  • Hello,
    lets say i have a DataSet that contains a DataTable with many rows and columns .
    There may be around 1000 rows .
    On the Database side i have two tables whose commulative columns taken together are same as columns present in this .NET application side DataTable .
    Now please suggest me a better way to have my Tables in the  Database with those values that are present in the DataTable in my .NET application side .

    Say DataTable has columns like Col1,Col2,Col3Col4,Col5 and this DataTAble contains many rows.
    On the DataBase server side there are two table Tab1 and Tab2.
    Tab1 contains columns like Col1,Col2.
    Tab2 contains columns like Col3,Col4,Col5

    How to insert values from DataTable to these Database tables ?

    I am unable to figure out how to fulfill this task .
    Thursday, September 27, 2012 5:16 PM


All replies