Chris,
If you don't specify an insert statement or a stored procedure, how is
it supposed to know how to insert the values in the data table into the
table in SQL Server?
You have to create a SQL Statement or a stored proc to call to do this.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"Chris Ashley" <ch***********@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Hi there,
If i have a dataset which has a datatable which has fields matching an
existing SQL Server DB Table exactly, is there an easy way to merge all
the records from the datatable into my SQL table without having to
write a stored procedure or SQL insert statement?
Cheers,
Chris