synchronization of dataset with sql server database

[praveenkumar palla]

Hi, I want to decrease the no of roundtrips to the database for that i have implemented that on form_load i am retrieving the datarows required from the database and storing those in the dataset. And i am doing all the modification(updates,delete and inserts) in dataset and finally using dataadapter and commandbuilder objects i am updating all the modifications to the database at a one shot. This is working fine. But I need help to synchronize the dataset to the database i.e. On form_load i filled the dataset and after that another user updated the database but my dataset doesn't have these updates, so when i update database using mydataset and dataadapter and command builder the updates done by another user earlier have been overwritten. I heared that Merge method of dataset is helpfull in this scenarios, but for me it is not working so plz help me on this by giving small example. Thanks in advance

[Dave Kreskowiak]

praveenkumar palla wrote:

and after that another user updated the database but my dataset doesn't have these updates

This requirement just dictated to you that you can't just load the data in FormLoad and hold onto it. Now you have no choice but to keep the round trips and hold onto data only as long as you need to update it. Search Googling around for "ADO.NET Concurrency" and you'll find that this is not an easy problem to solve. Oh...and "Merge" isn't going to help you here.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008