copying data from one table to another

  • Thread starter Thread starter Deepak
  • Start date Start date
D

Deepak

Hi all,
I am trying to copy data from one table to another. These tables are on
different servers. I am successfully able to read data from the destination
table. When I do DataAdapter.Update it does not give me an error and the
data does not go in either. I think its got to do with the insert command of
the data adapter, for this I am using the sqlcommandbuilder. Any help will
be appreciated.


Thanks

Deepak
 
Im not entirely sure that I understand your question. Are you saying that
you are connecting to two different SQL servers and reteiving data into to
seperate tables ?

If so . . .

Are you then merging the data from one table to another ?

and if so . .

Are the row states on the merged to table showing added ?

and if so . .

Whe you issue the update on the data adapter are u using the right table ?

and if so . .

Are you getting an exception ?

and if so . .

What is is ?





--
Regards - One Handed Man

Author : Fish .NET & Keep .NET
=========================================
This posting is provided "AS IS" with no warranties,
and confers no rights.
 
Back
Top