Disconnected dataset conflicts

Hi

We know the dataset is used for disconnected data access. But I have cleared with the data storage in dataset.

i.e. I retrieve the data from a database through a dataset and displayed using datagrid for manipulations. If edit & modify a particular row/column of the datagrid what will happen to the datastore? (For each & every row updation) Is the data will be updated immediately to the database by making connection or will it be stroed in any client / server cache variables?

Also please explain what will happen to the dataset values of each user, if more than one user is accessing the same data from the database using the dataset and updating some infos. Is the dataset automatically updates with the modified data or otherwise?

Thak you for the reply.

by
Banupriya