Saving DataTable to database

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi All,
I am looking for an elegant way to save a datatable to the database. The
datatable consists of new rows and rows existing in the database, now i
know how to differentiate between the new and old rows, but is there a
way to send a DataRow[] collection...do i use sqldatareader..if so
how...can someone please paste some sample code?
Many thanks,
Ben
 
Ben,

sqldatareader is good for data reading. If you also need to write, you
should consider sqldataadapter and dataset.

Eliyahu
 
Back
Top