Hi All,
I was asked to develop a simple application to handle car inventory. Each car has a LOT of properties (about 130, like license plate number, type, was it serviced, etc.). Some of these properties are represented by bit data type in a database some are varchar.
The problem is that I need to provide search functionality for any of all these properties and any combination of them. This results in a search form with about 130 controls. I certainly do not want to put the SQL query together manually by checking each and every control. To propagate the problem further I need to be able to search for partial strings as well (i.e. if the user enters "porsc" into the car brand field then all Porsches should be found).
What is the best practice to create search functionality like this? Where can I read about it?
Thanks for all the help in advance.
Best Regards,
Daniel
I was asked to develop a simple application to handle car inventory. Each car has a LOT of properties (about 130, like license plate number, type, was it serviced, etc.). Some of these properties are represented by bit data type in a database some are varchar.
The problem is that I need to provide search functionality for any of all these properties and any combination of them. This results in a search form with about 130 controls. I certainly do not want to put the SQL query together manually by checking each and every control. To propagate the problem further I need to be able to search for partial strings as well (i.e. if the user enters "porsc" into the car brand field then all Porsches should be found).
What is the best practice to create search functionality like this? Where can I read about it?
Thanks for all the help in advance.
Best Regards,
Daniel
