Sams Teach Yourself ADO.NET in 24 Hours

Hour 6. Retrieving Data from the Data Source

In the last hour, you saw how to use the Connection object to connect to several different types of data sources. This hour focuses on using the Command object to retrieve data from the database, which uses the Connection object to provide database connectivity.

In this hour, you will learn how to do the following tasks :

• Instantiate and use a Command object to retrieve data from a data source

• Use a DataAdapter object to place the results of a query into a DataSet