I create a datatable tostore information in as my program is running. When
the program is finished I have about 20 records in the datatable.
I know need to insert these records into an sql2000 DB. I loop through the
table to insert 1 record at a time using the sqlcommand ExecuteNonQuery().
Is there a way to insert all the records from the datatable in 1 statement
to the DB? Here I am making 20 calls the my DB. Hopefully there is a more
If you need more info or more clarification please ask!
|All times are GMT. The time now is 12:00 PM.|
Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.