DataTables

[Brian Shannon]

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
efficient way.

If you need more info or more clarification please ask!

Thanks