Find
Performs a search on all the fields of this object or any joined object that are marked with UseInSearch as true and AllowSearch is also set to true.
The returned result set will only contain the fields and business objects whose Visible property is set to true.
If the OnlyDistinct property is set then the result set will only contain distinct rows.
Any Fields that have their Sort property set will be included in the sorting of the result set as per their SortPosition property.
AddResultsToDataSet will determine if the data returned from the execution of this command will be added into the DataSet held at ResultSet property.
If the ObjectState property is set to Disconnected then this method will not connect to the database and will not return any data.
Passed in values of startRow and rowCount parameters will be used to set the StartRowIndex and PageSize properties in order to return a paged result set.
NOTE: Paged result set is not supported on SQL Server 2000.
Parameters:
| Description | |
|---|---|
| startRow | |
| rowCount |
Returns:
| Type | |
|---|---|
| DataSet |
Parameters
- startRow
- rowCount
Target Platforms: .NET Framework 1.1 or .NET Framework 2.0