Copy entire datatable to SQL Server table! 500 Points, need it FAST.
Posted on 2006-06-21
This question should require less than no brains, but I am a dummy I guess.
VB .NET 2003
I have a datatable in memory. I have a SQL 2005 table in the database, which is truncated empty. datatable and SQL table are laid out identically with identical field names. I need to fill the SQL table with the contents of the datatable.
Can this be done any other way than a loop and a formed SQL Insert string? The table has over 200 columns, and I am too lazy and impatient to do it that way unless I have no alternative. I know in ADODB.Recordset in the old ASP, I was able to copy between recordsets with a nested loop, but cannot see the way to this solution! Thanks for your help.