Gets or sets max number of records to fetch starting from
StartRecord.
public int MaxRecords {get; set;}
'Declaration
Public Property MaxRecords As Integer
Property Value
Max number of records to fetch starting from
StartRecord.
This sample shows how to access only a part of dataset returned by a query.
static void FillDataTable(DbDataTable myDataTable, IDbConnection myConnection)
{
myDataTable.Connection = myConnection;
myDataTable.SelectCommand = myConnection.CreateCommand();
myDataTable.SelectCommand.CommandText = "SELECT EmpNo, EName FROM Test.Emp";
myDataTable.StartRecord = 0;
myDataTable.MaxRecords = 10;
try
{
myDataTable.Active = true;
foreach(DataRow myRow in myDataTable.Rows)
{
foreach(DataColumn myCol in myDataTable.Columns)
{
Console.Write(myRow[myCol]+"\t");
}
Console.WriteLine();
}
}
finally
{
myDataTable.Clear();
}
}
Public Sub FillDataTable(ByVal myDataTable As DbDataTable, ByVal myConnection As IDbConnection)
Try
myDataTable.Connection = myConnection
myDataTable.SelectCommand = myConnection.CreateCommand()
myDataTable.SelectCommand.CommandText = "SELECT EmpNo, EName FROM Test.Emp"
myDataTable.StartRecord = 0
myDataTable.MaxRecords = 10
myDataTable.Active = True
Dim myRow As DataRow
Dim myCol As DataColumn
For Each myRow In myDataTable.Rows
For Each myCol In myDataTable.Columns
Console.Write(myRow(myCol) & Chr(9))
Next myCol
Console.WriteLine()
Next myRow
Finally
myDataTable.Clear()
End Try
End Sub