Person A saves the data but when person B saves it, the application errors out saying - which totally makes sense however how can I lock a record or notify the user the row has changed before hitting save?

My idea was when a user clicks onto a row within datagridview, it will send a sql statement to a lock table which inserts the row id and user but not sure how person B would find this out?

-Frinny Notice how I have added a Template Field to the Columns section of the Grid View? Even if the end user is displayed the Message Box it's not a good idea.

Row Data Bind Event to set the background colour instead of doing this in your Fill Grid method.

When a Customer Address row is deleted, the corresponding Grid View row disappears.

Referential integrity constraints would make the code for an example that actually deletes rows from the Customer table more complex.

To cancel the delete operation, set the event to cancel the delete operation.

The page contains a Grid View control that displays a list of customer names and addresses from the Adventure Works LT database.Hello - This is my first time on this site and I have already visited the Ukraine in November of 2013.She is also started taking English lessons and I am taking Russian Lessons (Wow talk about a culture lessons) I have a similar experience as Tracker above, but the major differences are I am 45 and she is 34, she has never asked me to pay for things except for a few things that went without saying (dinners, taxi's, interpreter, etc.) normal dating things.If you don't do this then 2 columns will appear for the "name" column: one automatically generated, and the other displayed in the Template Field) For example: Now, regarding the Message Box, it will work ok in Internet Explorer but it will not work in any other browser. Active X controls are not trusted and many users have them turned off...which means that the end user is unlikely to be able to see the message box. I recommend placing a Label on the page and setting it's Text to any error messages instead of using the Windows. Hello, I am using and the SQLData Adapter to display a query results from MS SQL into a datagridview so that the user can make changes the data and update it accordingly.