Bean Software Search Control Documentation   
 
 

     




WhereToSearch Property


Description:

Used in searching with LIKE keyword SQLSyntax . There are four values for this property:

  • BeginningOfRecord - search records that begins with search terms
  • EndOfRecord - search records that ends with search terms
  • MiddleOfRecord - search terms anywhere in the record
  • ExactRecord - returns only rows where search term is the same as a record.

This is default behavior only, you can enable MultipleWildCard and SingleWildCard to give your users more options.

Definition:

[Visual Basic .NET]

Public Property WhereToSearch() As enuWhereToSearch

[C#]

public enuWhereToSearch WhereToSearch() {get; set;}

Data type: enuWhereToSearch

Default value: enuWhereToSearch.MiddleOfRecord

Example: If Text property is set to "apple" and WhereToSearch is set to enuWhereToSearch.BeginningOfRecord, SQL query will return rows that begins with a word apple. If Text property changes to "apple*" and MultipleWildCard is set to Asterisk, control will search word apple anywhere in the record.