connectivity with remote server

[Digubha]

hello every body, is there any mechanism in visual studio 2005 and c# to copy the remote server table and update the local database table with that copied table, please guide me in this topic, step by step to accomplish it i have sql server 2005 database at local and remote server.

[poonam jagdale]

use bulk copy facility provided by c#.net.

[Mubeen asim]

you could use a datastructure in the client and the server that maps the data and convert to bytes and then decode that data again on the another side . the datastructure may contain the database table coloum names if the both tables on the two sides are same...