asp.net GRIDVIEW lock row

Hi,

I am trying to solve a following problem:
I've got a GridView in which I store data like Names , Zip codes... and the
problem si following:
Admin A selects one person (one row) from GridView and he changes the
record, but the change (he selects EDIT button on GRIDVIEW and at the end
he confirms the change with UPDATE button) takes 5 minutes because someone
disrupts him.
Meanwhile another admin B wants to do the same thing but admin A already
began to edit the same row. Admin A and admin B confirms the change with
UPDATE button (first one is admin A) and the change of admin A is displayed
at the end of both UPDATES. Is there a method (example,source code...) by
which admin B is informed (for example with pop-up window) that the same row
he wants to EDIT is already in use by Admin A ?
I am using STORED PROCEDURES to retrieve data (SELECT * FROM....) from SQL
database and display them in GRIDVIEW and also I am using STORED PROCEDURES
to update data.

Re: asp.net GRIDVIEW lock row

marian wrote:
> Hi,
>
> I am trying to solve a following problem:
> I've got a GridView

There was no way for you to know it (except maybe by browsing through
some of the previous questions before posting yours - always a
recommended practice), but this is a classic asp newsgroup. ASP.Net is
a different technology from classic ASP. While you may be lucky enough
to find a dotnet-savvy person here who can answer your question, you
can eliminate the luck factor by posting your question to a newsgroup
where the dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.
There are also forums at www.asp.net where you can find a lot of people
to help you.


> in which I store data like Names , Zip codes...
> and the problem si following:
> Admin A selects one person (one row) from GridView and he changes the
> record, but the change (he selects EDIT button on GRIDVIEW and at
> the end he confirms the change with UPDATE button) takes 5 minutes
> because someone disrupts him.
> Meanwhile another admin B wants to do the same thing but admin A
> already began to edit the same row. Admin A and admin B confirms the
> change with UPDATE button (first one is admin A) and the change of
> admin A is displayed at the end of both UPDATES. Is there a method
> (example,source code...) by which admin B is informed (for example
> with pop-up window) that the same row he wants to EDIT is already in
> use by Admin A ?

I suppose you could have the EDIT button run a procedure that would
cause a flag to be set in the database to lock the row. But even this is
not perfect.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.