How to handle concurrency problem!

HI ALL,

I have taken the employee table to dataset and updated the designation for the employee 111 and the same time another user deleted the 111 record from the database.while update my dataset what woudl happen whether my changes are stored or exception thrown.?

This is very basic question.Any one please let me know how can i check the database with values of the dataset or is there way to handle?

its wise to give me url of concepts to solve the concurrency problem.

.

Please visit following link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskcatchingconcurrencyerror.asp

http://msdn.microsoft.com/msdnmag/issues/03/04/DataConcurrency/

Regards

Kuldeep Deokule