Saving DataTable to database

[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

 

[Eliyahu Goldin]

Ben,

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

Eliyahu