Smart search function to compare search value to all columns in table

Posted on 2009-12-28
Last Modified: 2013-12-17
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.
Question by:0nepiece
    LVL 9

    Expert Comment

    by:Grant Spiteri
    I think might help you with the text entry scenario
    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.....

    Author Comment

    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?
    LVL 9

    Accepted Solution


    Author Closing Comment


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
    Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now