C# Unleashed

Retrieving DataSets

All examples in this chapter so far have made a connection to a database, performed whatever operations were pertinent, and disconnected. This is similar to what many people are comfortable and familiar with. Now the rules change. The new game in town is DataSets. A DataSet is a disconnected database. In the context of the DataSet, the term disconnected means that a connection is made to establish a session with the database, the required data is read into a DataSet, and then the session is closed by disconnecting from the database. At the point the session is closed by disconnecting from the database, the DataSet becomes a disconnected database. One of the major benefits of this is that a program doesn't hold on to connection ...