The SqlDataAdapter Object allows us to populate DataTable in a DataSet. We can use Fill method in the SqlDataAdapter for populating data in a Dataset. The Dataset can contains more than one Table at a time.
The data inside Table is in the form of Rows and Columns . The DataRow class represents the actual data contained in a table. You use the DataRow and its properties and methods to retrieve, evaluate, and manipulate the data in a table. In some situations we have to find the column headers in a DataTable. There is a ColumnsCollection Object in the Datatable hold the column Definitions. The following ASP.NET Source Code shows how to find Column Definitions from a Datatable.
Click the following links to see full source code