Insert Dataset into SQL Server Table

[Guest]

All

I have a dataset that I have returned from a SQL Server instance and I want
to insert the records from the datatable in the dataset to a table in another
SQL Server instance.

Is there a way to insert the datatable without interating through each row.
What I am looking for is insert into sqlservertable datatable?

Thanks

 

[Ken Tucker [MVP]]

Hi,

http://www.windowsformsdatagridhelp.com/default.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a

Ken

 

[Cor Ligthert [MVP]]

David,

First of all iterating takes almost no time, so I don't see what is the
problem with that, be sure that it is done often behind the scene when here
is a method.

However, maybe can you rephrase the answer, because I think that the answer
from Ken is not the answer on your question.

But what is the question, because I can give as well probably 2 different
answers which probably are not the answers on your question.

By instance do you just want to copy a table from SQLServer 1 to SQLServer2?

Do you want to add a table to your existing dataset based on an old one?

Or do you what Ken's shows want to merge a datatable from server 1 in a
datatable you got frorm server 2?

So please rephrase

Cpr