Summary

In this chapter, you got a good start working with data and data binding in ASP.NET. Specifically, here's what you accomplished:

• You created a Connection object that contains information on the location and type of data.

• You created a DataAdapter object that handles retrieving the data using the Connection object.

• You generated a typed DataSet, a class that handles providing the data to data-bound controls.

• You bound a DataGrid control to the typed DataSet, displaying data on the page.

• You added a bound DropDownList control and filtered the data in the DataGrid based on the selection in the drop-down list.

• Although you didn't investigate creating OleDbConnection objects in this chapter, you'll see how you can do all the work without any of the design-time components in Chapter 13, “ADO.NET Connection and Command Objects.”