0nepiece
asked on
Smart search function to compare search value to all columns in table
Hi, I'm creating a search function in C# .NET Windows Forms 2005. First how do I make it Google like, wherein when I key in the search value it recalls the previous entry and at the same time searches the database at once. Second, how do I compare the search value to all the columns values of the table? Btw I'm using MS Access 2003. Thanks in advance.
ASKER
Thanks for the stored procedure idea I'll do just that. On the other hand, I'm using C# Windows forms of VS .NET 2005. Does AJAX work there?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
http://www.asp.net/AJAX/AjaxControlToolkit/Samples/AutoComplete/AutoComplete.aspx
with regards to the search in the db simply write a stored procedure to search all columns
ie where col1 like 'value' or col2 like 'value' etc.....