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

Save DataTable To SQL Server

P: n/a
I have a data table with 3000 + rows in it. Is there a way to insert it in
to the SQL server database with out going through datatable row by row? Any
code samples or links would be great. Thank you all very much
Nov 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
DataAdapters, write your Update Statement, do your Tablemappings and
bliggity blam... your done...

"Ruslan Shlain" <rs*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
I have a data table with 3000 + rows in it. Is there a way to insert it in
to the SQL server database with out going through datatable row by row? Any code samples or links would be great. Thank you all very much

Nov 20 '05 #2

P: n/a
I forgot to mention that i have over 70 columns in that datatable.
"Ruslan Shlain" <rs*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
I have a data table with 3000 + rows in it. Is there a way to insert it in
to the SQL server database with out going through datatable row by row? Any code samples or links would be great. Thank you all very much

Nov 20 '05 #3

P: n/a
* "Ruslan Shlain" <rs*****@hotmail.com> scripsit:
I have a data table with 3000 + rows in it. Is there a way to insert it in
to the SQL server database with out going through datatable row by row? Any
code samples or links would be great.


ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.