Visual Basic® .NET Database Programming

Summary

Visual Basic’s database objects make working with databases relatively easy. You can load records from any number of tables into a DataSet. You can then add, modify, and delete records, and save your changes to the database.

Although this method is straightforward, it doesn’t work well for multi-user applications. If two users try to modify the same record at the same time, one of them gets an error and loses his modifications. Adding a ReservedBy field allows an application to manage record reservations itself in a simple, intuitive way. It allows the application to coordinate its efforts so users don’t waste time duplicating their efforts.

Making the application handle individual customer accounts as separately as possible also allows ...