FindRange Method (startIndex, endIndex)

BizBlox

Populate the DOCollection with a subset of the search results, using the SQLBuilder that has been previously set in the SetCurrentQuery() method

Declaration Syntax

Visual Basic

Visual C++

public void FindRange(
	int startIndex,
	int endIndex
)

Public Sub FindRange ( _
	startIndex As Integer, _
	endIndex As Integer _
)

public:
void FindRange(
	int startIndex, 
	int endIndex
)

Parameters

startIndex (Int32): The index of the first row to be retrieved. Must be >=0 and <= the row count of the results.

endIndex (Int32): The index of the final row to be retrieved.

Remarks

Before calling this method, SetCurrentQuery() must first be called to set the DOCollection's SQLBuilder. It is this previously-set SQLBuilder that will be used in FindRange().

Examples

This will retrieve the first 50 rows in the result set:

CopyC#

Dim sColl as New StudentCollection
Dim mySql as SQLBuilder = sColl.GetSqlBuilder()
mySql.addWhere(Student.Columns.Name, name)
sColl.SetCurrentQuery(mySql)
sColl.FindRange(0, 49)

Assembly: pixolut.BizBlox (Module: pixolut.BizBlox) Version: 1.8.5.0