Management with ADO.NET disconnected data

Management and data access with Visual Basic. NET are used to these typical steps:

• creating a connection with the source data
• execution of a query on the database
• returning data properly organized with any access control to data

With ADO, VB6 and even more so with ADO.NET has managed to perfect the creation of a disconnected recordset, ie the creation of a data table without opening any connection with a specific data source.

To explain this concept simply:

• we create a Windows Application project
• add a class that manages the creation of this recordeset disconnected
• coupled to the control of access to the data type DataGridView
• suppose to add data in the disconnected recordset using the class created in Step 2
• you should update automatically control access to the data (see point 3)

with the first graphic illustration represent the first step to create a Windows Application project:

dialog box is shown on (not in sight) an Ok button. We press this button and we will have:

double-click the form you need to plan this window: this form is:

• from a DataGridView
• three labels and three text boxes
• two command buttons to update the dataset, respectively, and clean out the form

• <<
• 1
• 2
• >>