Visual Basic® .NET Database Programming

Database Redesign

Program OrderEntryMultiUser keeps data for each of its customers as independent as possible. Each customer detail form has its own DataSet, DataTable, DataView, and CurrencyManager objects to control its own data. That allows each instance of the program to easily separate itself from other instances of the program. It also keeps the customer detail forms separate from each other within a single instance of the program and that simplifies the program’s data processing code. When the user clicks the Edit button on a customer detail form, the form’s code tries to reserve the customer’s data. It does not need to worry about what the program’s other forms are doing.

This independence makes the code simpler overall but it does necessitate ...