HelloData: A simple ADO application
Applies to: Access 2013, Office 2013
To lay the groundwork for an exploration of the ADO library, consider a simple ADO application called "HelloData." HelloData steps through each of the four major ADO operations (getting, examining, editing, and updating data). In order to focus on the fundamentals of ADO and prevent code clutter, minimal error handling is done in the example.
The application queries the Northwind sample database that is included with Microsoft SQL Server 2000.
To run HelloData
Create a new Standard Executable Visual Basic Project that references the ADO 2.5 library.
Create four command buttons at the top of the form, setting the Name and Caption properties to the values shown in the table below.
Below the buttons, add a Microsoft DataGrid Control (Msdatgrd.ocx). The Msdatgrd.ocx file comes with Visual Basic and is located in your \windows\system32 or \winnt\system32 directory. To add the DataGrid control to your Visual Basic toolbox pane, select Components... from the Project menu. Then check the box next to "Microsoft DataGrid Control 6.0 (SP3) (OLEDB)" and click OK. To add the control to the project, drag the DataGrid control from the Toolbox to the Visual Basic form.
Create a TextBox on the form below the grid and set its properties as shown in the table. The form should look similar to the following figure when you are finished.
Finally, copy the code listed in HelloData Code and paste it into the code editor window of the form. Press F5 to run the code.
Note
In the following example, and throughout the guide, the user id "MyId" with a password of "123aBc" is used to authenticate against the server. You should substitute these values with valid logon credentials for your server. Also, substitute the "MyServer" value with the name of your server.
For a detailed description of the code, see HelloData Details.
Control Type |
Property |
Value |
|---|---|---|
Form |
Name |
Form1 |
|
Height |
6500 |
|
Width |
6500 |
MS DataGrid |
Name |
grdDisplay1 |
TextBox |
Name |
txtDisplay1 |
|
Multiline |
true |
Command Button |
Name |
cmdGetData |
|
Caption |
Get Data |
Command Button |
Name |
cmdExamineData |
|
Caption |
Examine Data |
Command Button |
Name |
cmdEditData |
|
Caption |
Edit Data |
Command Button |
Name |
cmdUpdateData |
|
Caption |
Update Data |