BizBlox
FindRange Method (startIndex, endIndex, sqlObj)
Namespacespixolut.BizBloxDOCollectionFindRange(Int32, Int32, SQLBuilder)
BizBlox
Populate the DOCollection with a subset of the search results generated using the specified SQLBuilder.
Declaration Syntax
C#Visual BasicVisual C++
public void FindRange(
	int startIndex,
	int endIndex,
	SQLBuilder sqlObj
)
Public Sub FindRange ( _
	startIndex As Integer, _
	endIndex As Integer, _
	sqlObj As SQLBuilder _
)
public:
void FindRange(
	int startIndex, 
	int endIndex, 
	SQLBuilder^ sqlObj
)
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.
sqlObj (SQLBuilder)
Remarks
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.FindRange(0, 49, mySql)

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