By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,012 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,012 IT Pros & Developers. It's quick & easy.

Saving DataTable to database

P: n/a
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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ben,

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

Eliyahu

"Ben" <no****@devdex.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...


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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.