How to get the record locked status in .net

24 Feb 2006 9:04 PM

Joy

Hello:

After I start a transaction with "REPEATABLE READ", before I commit, if I
begin another transaction to the same records, how can I get the locked
status of these records?

Thanks.

24 Feb 2006 9:53 PM

William (Bill) Vaughn

Query with sp_lock? I would look at the source code of this system sp and
see what it's doing to inspect the current locks.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Show quote

"Joy" <xzh***@caisoftdesign.ca> wrote in message
news:%23tsPoVYOGHA.2604@TK2MSFTNGP09.phx.gbl...
> Hello:
>
> After I start a transaction with "REPEATABLE READ", before I commit, if I
> begin another transaction to the same records, how can I get the locked
> status of these records?
>
> Thanks.
>
>

27 Feb 2006 2:24 PM

Joy

Yes, you are right, ADO.NET uses optimistic concurrency by default.

Please let me clarify my question here:
I am using advantage data provider in my .NET project to access DBF database
files. I want to lock the records when I start my transaction, and I want to
get the record lock status, so that I can display the locked record only
view.

But I do not know how to realize this .

Thanks.

Show quote

"William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> wrote in message
news:eRdkKzYOGHA.3936@TK2MSFTNGP10.phx.gbl...
> Query with sp_lock? I would look at the source code of this system sp and
> see what it's doing to inspect the current locks.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "Joy" <xzh***@caisoftdesign.ca> wrote in message
> news:%23tsPoVYOGHA.2604@TK2MSFTNGP09.phx.gbl...
>> Hello:
>>
>> After I start a transaction with "REPEATABLE READ", before I commit, if
>> I begin another transaction to the same records, how can I get the locked
>> status of these records?
>>
>> Thanks.
>>
>>
>
>