RE: Lock MSSQL Table Row?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Xenophon,

Thank you for your posting. Regarding on the issue, I am
finding proper resource to assist you and we will update as soon as posible.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security(This posting is provided "AS IS",
with no warranties, and confers no rights.)
--------------------
| NNTP-Posting-Date: Fri, 30 Sep 2005 13:26:11 -0500
| From: xenophon <xenophon@xxxxxxxxxxxxx>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Subject: Lock MSSQL Table Row?
| Date: Fri, 30 Sep 2005 14:16:49 -0400
| Message-ID: <t70rj15upltohumg1slmkr44uktfae0ihd@xxxxxxx>
| X-Newsreader: Forte Agent 2.0/32.646
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Lines: 22
| X-Trace:
sv3-6Dfc2ay3nzyDYhSlT7hEqRn0VnAO3j9E8binO7HQANOSEZA9UktrVnZmbrCPF4iOMbUIWmmG
jGmlB0a!x8AveHqnQToYst0/eH+cO9VD0TY90EDU9VsGD2WpmwXYTRy/YOCayZlkPt86GHtsvVLr
AlY=
| X-Complaints-To: abuse@xxxxxxxxxxxx
| X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
| X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
| X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
| X-Postfilter: 1.3.32
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.framework.adonet:36640
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
|
|
|
| In my .NET Framework 1.1 DataSet/DataTable/DataRow, I have a row with
| a stringized GUID column called 'Concurrent'. There is a matching row
| in the database with the same GUID. Within a single XA (MSDTC)
| transaction (not SQL Server transaction), I need to "lock" the
| existing row if the 'Concurrent' values match, update the database
| table(s), change the 'Concurrent' value in the database and in the
| DataRow, and then unlock at the database. That way, if two people
| tried to save the same data, the second user would be blocked until
| the first save was complete, and then could take action because
| 'Concurrent' would no longer match.
|
| How can I lock a database row from an MSDTC transaction in C#? Is
| there any good sample code for other means of concurrency management?
|
| Thanks.
|
|
|
|
|

.

Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Thanks for posting it. ... Hitchhiker's Guide to Visual Studio and SQL Server ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: NetBase Shadowing Slowness
    ... shadow posting is single-threaded. ... When that database is being updated, ... It's not very noticeable on the master machine, ... One trick I have used on occasion is to defer posting on the offending ...
    (comp.sys.hp.mpe)
  • Re: Problem with email attachment, 1 becomes 10
    ... My CV should be attached as a pdf-file. ... posting guidelines for this group is, before posting, to always try to ... stuff involving reading lines from the database, ... attachment, which might be where the bug happened, although I think it's ...
    (comp.lang.perl.misc)
  • RE: 1202 Errors, Article 278316, "ESENT event IDs 1000, 1202, 412
    ... This posting is provided "AS IS" with no warranties,and confers no rights. ... 1202 Errors, Article 278316, "ESENT event IDs 1000, 1202, 412 ... services Database recovery/restore failed with unexpected error ... attempting to open the local security policy results in the error ...
    (microsoft.public.win2000.group_policy)
  • Re: MS Access - problem with Double type field
    ... This is a multipost, not a crosspost. ... > know what the form is posting, and subsequently what the database has ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)