Save DataTable To SQL Server

[Ruslan Shlain]

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

 

[CJ Taylor]

DataAdapters, write your Update Statement, do your Tablemappings and
bliggity blam... your done...

 

[Ruslan Shlain]

I forgot to mention that i have over 70 columns in that datatable.

 

[Herfried K. Wagner [MVP]]

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:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>