How to Dataset rows count - OLEDB

The DataSet Object contains copy of the data we requested through the SQL statement. The DataSet consists of DataTableCollection and their DataRelationCollection . The DataTableCollection contains zero or more DataTable objects. A DataSet represents a complete set of data including the tables that contain, order, and constrain the data, as well as the relationships between the tables.

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. The following C# source code shows how to find the number of rows in a table that resides in the Dataset from an OLEDB Data Source.