ExecutePageReader Method (DbCommandBase)
Returns a specific subset of rows when paging through the results of a query.
The example below shows how to retrieve a part of a table. If this function is called with parameters
startRecord=2 and
maxRecords=3, it returns 3 rows: second, third, and fourth.
|
|---|
public void ExecutePaged(SQLiteConnection sqLiteConnection, int StartRow, int PageLength)
{
SQLiteCommand sqLiteCommand = new SQLiteCommand("SELECT DeptNo, DName, Loc FROM Dept", sqLiteConnection);
sqLiteConnection.Open();
SQLiteDataReader sqLiteReader = sqLiteCommand.ExecutePageReader(System.Data.CommandBehavior.Default,StartRow,PageLength);
try
{
while (sqLiteReader.Read())
{
Console.WriteLine(sqLiteReader.GetInt32(0).ToString() + ", " + sqLiteReader.GetString(1) + ", " + sqLiteReader.GetString(2));
}
}
finally
{
sqLiteReader.Close();
sqLiteConnection.Close();
}
} |
|
|---|
Public Sub ExecutePaged(ByVal sqLiteConnection As SQLiteConnection, ByVal StartRow As Integer, ByVal PageLength As Integer)
Dim sqLiteCommand As New SQLiteCommand("SELECT DeptNo, DName, Loc FROM Dept", sqLiteConnection)
sqLiteConnection.Open()
Dim sqLiteReader As SQLiteDataReader = sqLiteCommand.ExecutePageReader(System.Data.CommandBehavior.Default, StartRow, PageLength)
Try
While sqLiteReader.Read()
Console.WriteLine(sqLiteReader.GetInt32(0).ToString() + ", " _
+ sqLiteReader.GetString(1) + ", " _
+ sqLiteReader.GetString(2))
End While
Finally
sqLiteReader.Close()
sqLiteConnection.Close()
End Try
End Sub |