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 ...

Get C# Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.