Essential ADO.NET

5.3. Populating a DataSet from a Managed Provider

You use the Fill method of IDataAdapter to fill tables in DataSet by executing a specified command on the database and using the resultset. Fill uses the SelectCommand member of IDbDataAdapter. An often-used constructor overload of a typed DataAdapter—such as SqlDataAdapter or OleDbDataAdapter—takes a command string and connection string as parameters and creates the correct type of Connection class and Command class, populating the SelectCommand. If the Connection is not open when Fill is called, Fill automatically opens it, automatically closes it when finished, and returns. If the Connection is already open when Fill is called, it remains open after Fill returns. This process is demonstrated ...