Summary

Congratulations! You've now completed one more step toward understanding ADO.NET and its components. After completing this chapter, you should have a good idea of how to write database applications using the VS .NET IDE.

In this chapter, you learned about visual data components in VS .NET. The Server Explorer is a handy utility added to VS .NET IDE to help you manage your database connections.

DataAdapters let you connect to a data source at design-time and populate DataSet objects. In addition, DataAdapters also allow you to add, update, and delete data through data command objects. The VS .NET IDE also lets you generate typed DataSets, which are DataSets with properties of tables and columns specific to a data source.

A DataView is a bindable view of a DataSet. You can sort and filter a DataSet with a DataView and use it to bind to a graphical component in many of the Windows form controls.

Finally, the Data Form Wizard is a useful tool for generating full-fledged database applications with features such as inserting, deleting, and updating in no time.

In the next chapter, we discuss ADO.NET disconnected classes and components.