<div>
Birky:<br />
<br />
In your suggestion of locking using a field in the DB what happens if the app crashes on a user that is in edit mode in a page. this means the record will stay locked for other users.<br />
how could this be avoided?
</div>


Birky:

In your suggestion of locking using a field in the DB what happens if the app crashes on a user that is in edit mode in a page. this means the record will stay locked for other users.
how could this be avoided?

<div>
these are good comments but i want to research these options first.<br />
Experts, is it ok if i leave it open a little longer? thanks
</div>


these are good comments but i want to research these options first.
Experts, is it ok if i leave it open a little longer? thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm designing a web application where different users could be updating the same records.<br />
I would like to make sure that only the changed fields by one user are updated one by one so there is no concurrency violation.<br />
<br />
What is the best method to design this?<br />
<br />
Its my first time working with SQL 2005 so i'm not sure about the tableAdapters &quot;optimistic concurrency&quot; option. Will this take care of it by itself?<br />
<br />
thank you
</div>
</div>


Hi,

I'm designing a web application where different users could be updating the same records.
I would like to make sure that only the changed fields by one user are updated one by one so there is no concurrency violation.

What is the best method to design this?

Its my first time working with SQL 2005 so i'm not sure about the tableAdapters "optimistic concurrency" option. Will this take care of it by itself?

thank you

tableAdapter Update only SQL table fields that where modified in web page

Programming theory deals with the design, implementation, analysis, characterization, and classification of programming languages and their individual features, along with introductory programming concepts like program structure, variable declaration and conditional and looping constructs. Sub-disciplines include the formal semantics of programming languages, type theory, program analysis and transformation, comparative programming language analysis, metaprogramming, domain-specific languages, compiler construction and run-time systems.

Programming Theory

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.

Web Development Software

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.