Make your own free website on Tripod.com

Microsoft Visual Basic.NET automatically generates code similar to that shown on the left.  This particular code is the default style (optimistic locking) generated for a web form.

This demonstrates that ADO.NET provides disconnected access to data.  Optimistic locking is an accepted standard for database updates from web pages. Often times, records may include a "last updated by" and "last updated date/time". If that is the case, you should consider excluding those two fields from the where clause. At least, you should consider those fields separately.