Merge dataset into identical table?

[Chris Ashley]

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

[Nicholas Paldino [.NET/C# MVP]]

Re: Merge dataset into identical table?

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]
- mvp@spam.guard. caspershouse.co m

"Chris Ashley" <chris.ashley2@ gmail.com> wrote in message
news:1133871857 .274623.302070@ g47g2000cwa.goo glegroups.com.. .[color=blue]
> 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
>[/color]