I would like to block a DataRows in my database for the time a user is updating the data. Not only while doing the sql-order, but let's say for a couple of minutes, while the user is changing the data of … whatever – for example on a client.

I thought about creating a table called "blockings" and each time somebody is accessing a datarow in a table, write into this "blockings" table the tablename, the id of the row and the computername that is blocking the row. Each time that somebody wants to access any row, I first check if there is any blocking entered into "blockings".

What do you thing about this? It is quite laborious, is it the right way to go?

I do not know anything about ADO.NET and as my problem is a problem that slightly any company with several computers accessing the same db has, I suppose that there are great solutions for this…
(I heard about transactions - is this something to go deeper in, or doesn't it solve long term blockings (for several minutes, max. 1 hour))

It would be a great help if anybody could give me a hint where I should continue to look at. I would like to find a general and "good practice" way to do it.

Thank you very much!

Regards,
Fabian