• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

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.
0
0nepiece
Asked:
0nepiece
  • 2
  • 2
1 Solution
 
Grant SpiteriSenior consultantCommented:
I think might help you with the text entry scenario
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.....
0
 
0nepieceAuthor Commented:
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?
0
 
0nepieceAuthor Commented:
Thanks!
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now