WhereClause Street name , House number, Postal code

Question

Hi

I have 3 Textbox and I need to search for Street name , House number, Postal code

House Number and Postal code  can be empty

I am try to search using just part of street name or full name

Street name = Data Type Text

House number = Data Type Numeric

Postal code = Data Type Numeric

I can search for street name with House number but if I have no House number I get nothing

pQueryFilter.WhereClause = "Street = '" + Street.Text + "' AND Number = '" + number.Text + "'"

SigurdurGear · Answer

Duncan Hornby and Ken Buja thanks for your Replay I managed to fix this This work for me I can Search for Street name With or without House number, and Postal code I only use House number and Postal code to narrow the search English is not my mother Language sorry if I can't Explain it better or wrong spell pQueryFilter.WhereClause = "STREETNAME LIKE '" & Street.Text & "%' and HOUSENUMBER LIKE '" & number.Text & "%' and POSTALCODE LIKE '" & Pn.Text & "%' ORDER BY STREETNAME,HOUSENUMBER,POSTALCODE Asc"‍‍

TedKowal · Answer

Just a side comment, the query (WhereClause) you are setting is an exact match.  Typically, in experience, in dealing with text types of searches, the user either cannot spell, don't know the whole name or only has partial information.  An exact matching whereclause will not handle this type of situation.  An old reference I used, much of which is still valid which explains how to use the like operator and wild cards within your WhereClause.

"STREET_NAME" LIKE '%Blue Bird%'

IQueryFilter.WhereClause Property

Just a side note!

kenbuja · Answer

You should construct the whereclause in response to whether a text box has been selected Dim clause as String = "Street = '" + Street.Text + "'" If number.Text <> "" then clause += " AND Number = '" + number.Text + "'" End If QueryFilter.WhereClause = clause ‍‍‍‍‍‍