how to lock the selected records using C#?

[Guest]

Now I need to lock the selected records for some time and others can not
update these records meanwhile. How can I do?
any help will be very appreciated!!

 

[Laura T.]

It usually depends on what DB you are using.
With SQL Server you could try to use locking hints and/or System.Transaction
namespace objects to control the transactional locking.

 

[Guest]

I use sql server database and how to realize it?
can you give me a example?
Thank you very much!

 

[RobinS]

You might want to post this to microsoft.public.dotnet.framework.adonet.

Robin S.
------------------------------------------

 

[Guest]

Now I need to lock the selected records for some time and others can not
update these records meanwhile. How can I do?
any help will be very appreciated!!

Try search for "pessimistic locking".

Arne