mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update?
mssql express - check for database changed before update? mssql express - check for database changed before update?
mssql express - check for database changed before update?
Go Back  Xtreme Visual Basic Talk > > > mssql express - check for database changed before update?


Reply
 
Thread Tools Display Modes
  #1  
Old 06-07-2014, 09:51 AM
PatM PatM is offline
Freshman
 
Join Date: Mar 2006
Posts: 28
Default mssql express - check for database changed before update?


I'm playing with VB2010 express and sqlserver express.

The app I'm working on will be multi-user and I'm trying to figure out how to check if data has changed on the server between the time another user pulls data and tries to send back their changes.

I've been googling (well, startpaging) and I'm really getting the idea I just don't know the right terms to use because I've gotten zero hits on anything other than just how to update a database from a dataset/datatable.

Anyway, my scheme (as I've imagined it anyway) is to pull the required data from the database into tables, copy the table data into generic lists and use the lists to populate controls for the user to manipulate. When the user submits their changes I'd use the unchanged datatable to check against the database to see if the data is still current. If it is current, update the database, if it's not, abort the update, inform the user, and let them choose whether to reload the changed data from the database or just abandon the idea of making changes.

If someone could point me to the right terms to search for I'd really appreciate it. Don't really need a code example, just a kick in the right direction (though feel free if you have something handy!).

Thanks!
Reply With Quote
  #2  
Old 06-08-2014, 10:00 AM
PlausiblyDamp's Avatar
PlausiblyDampmssql express - check for database changed before update? PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

The term you are looking for is concurrency, https://www.google.co.uk/search?q=da...urrency+issues should give you some useful hits to start you off.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #3  
Old 06-10-2014, 08:38 AM
PatM PatM is offline
Freshman
 
Join Date: Mar 2006
Posts: 28
Default

Thats the word! I actually knew that but for some reason I couldn't get it off my disk and into my ram...

Thanks!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update? mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update? mssql express - check for database changed before update?
mssql express - check for database changed before update?
mssql express - check for database changed before update?
 
mssql express - check for database changed before update?
mssql express - check for database changed before update?
 
-->