471,305 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,305 software developers and data experts.

Merge dataset into identical table?

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

Dec 6 '05 #1
1 1352
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

Dec 6 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Li Weng | last post: by
reply views Thread by Reb | last post: by
3 posts views Thread by Moty Michaely | last post: by
1 post views Thread by Joey Lee | last post: by
2 posts views Thread by Mike Stephens | last post: by
2 posts views Thread by muntyanu | last post: by
2 posts views Thread by Benny Ng | last post: by
5 posts views Thread by Mark Chambers | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.