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
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 |