gridview edit mode question

[cheeseistheman]

Hello there,

I am fairly new to ASP.NET and have been using the data access tutorials at
www.asp.net to get an understanding of some of the basic data access
concepts. I have created a page that uses a detailsview to insert records
into a table and a gridview to edit and delete existing records, so far so
good.

The one problem I have encountered that I have not figured out has to do
with editing records. If another user inserts a record into the table before
I click the edit button the gridview puts the wrong record in editmode ie.

My gridview currently contains the records:

200 Jones
300 Peters
400 Andrews

Another user inserts the following record before I click edit:

100 Walters

I then click the edit button for the record that corresponds to "200 Jones"
(which is the record I want to edit). Once I do this the gridview places the
"100 Walters" record in edit mode. I'm sure I'm missing a faily basic concept
here but if anyone has a suggestion for me I'd definitely appreciate it.
Thanks.

 

[cheeseistheman]

does anyone know how to resolve this?????????????

 

[pendo]

you have to limit to only updating the particular record. for instance in
your wheree clauses say

where primarykey = @primarykey