programming for synchronization of local database with remote server dabase

Feb 18 2009 12:08 PM
Hiii
everybody there!
i am developing window application in c# and .net.
i am new to it, now my problem is:
scenario:- suppose i have one table product at local database say softbuyweb and similarly i have one table product1 at remote server database say softbuyweb1 and i want that there is one button "Update" in window form and on click event of update the connetnt of datatable product1 at remote server is copied and the datatable product at local database is updated by this copied content of product1 table of remote database .
please help me on this topic, or guide me in this topic.
waiting for your quick response.
thanx in advance!