connectivity with remote server database

Question

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, if no than please suggest me what i have to do for this in c# window application. i have sql server 2005 database at local and remote server. thanx in advance!