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

 

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 PageSize and StartRowIndex properties are set then a paged record set will be created.

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.

This method will set the AffectedRecords property with the number of records returned by this method.

NOTE: If the ObjectState property is set to Disconnected this method will not do anything.

Returns:

Type
DataSet