To set up the dataset

  1. From the ADO page, place an ADODataSet component at the top of the form.
  2. In the Object Inspector, select the Connection property drop-down list. Set it to ADOConnection1.
  3. Set the CommandText property to an SQL command, for example, Select * from orders.

You can either type the Select statement in the Object Inspector or click the ellipsis to the right of CommandText to display the CommandText Editor where you can build your own query statement.

Tip: If you need additional help while using the CommandText Editor, click the Help button.

4. Set the Active property to True to open the dataset.

You are prompted to log in. Use admin for the username and no password.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook

Post a comment