O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required