StartRecord Property

In This Topic

Gets or sets record number to start.

Syntax

Visual Basic
C#

'Declaration
 
Public Property StartRecord As Integer

public int StartRecord {get; set;}

Property Value

Record number to start. Value 0 means the first row, 1 means the second, and so on.

Remarks

StartRecord and MaxRecords take effect only when DbDataTable is opened using the Active property or the Open method.

Another way to access only a subset of rows is to use FillPage method.

Assigning a value to this property invokes the fill operation.

Example

This sample shows how to access only a part of dataset returned by a query.

csharp

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();
  }
}

Visual Basic

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

Reference

DbDataTable Class
DbDataTable Members
MaxRecords Property
Active Property
FillPage Method

Send Feedback