Display Selected range of records
The DataAdapter serves as a bridge between a DataSet and a data source for retrieving and saving data. When an instance of DataAdapter is created, the read or write properties are set to initial values. A DataSet is made up of a collection of tables, relationships, and constraints. In ADO.NET, DataTable objects are used to represent the tables in a DataSet. The DataSet is designed to be used in a disconnected mode.
In some situations we need to retrieve data only specific range of rows. In this situations we can fill the Dataset from DataAdapter only that specific range of rows. The following piece of code shows how to fill specific range of rows from DataAdapter to Dataset.
The above code will fill the Dataset starting from 5th row and no of rows 3.
- 5 is the starting row no.
- 3 is no of rows we want to fill.