Hi, i have a windows application form that is connected to a database. I have a datagridview that is connected to the datasource. When i'm on a particular row, i would like to check if the information in this row differs of the same row in the database. For example another user has already made a change to this row from a different application. How can i accomplish this? Here is what i have.
Thanks so much.
AronMonday, November 08, 2010 11:00 PM
Your requirement sounds like, managing concurrency exceptions. You can handle such scenarios using Concurrency Control in ADO.NET .Tuesday, November 09, 2010 11:04 AM
To compare only one row, GetData is a bit heavy. Create a new SQL query taking the key as parameter, it will return a datatable containing only one row. You can then compare each value in the row from the database (first row from the returned datatable), with the one from the dataset.Tuesday, November 09, 2010 4:45 PM