locked
How to implement search function RRS feed

  • Question

  • User-1140746197 posted

    I have a table search the record. The user can search by name, id, status, address and other information.

    I want to make the search function more robust. For example, when the database has a record with name = "Michael Jackson", either typing any subset of the name will show this record.

    I would like to know if there is any easy way to implement this with VS2005 and SQL2005 Express.

    Thank you 

    Thursday, February 1, 2007 2:24 AM

Answers

All replies

  • User2076344368 posted

    Take a look at the LIKE command in SQL, some examples : http://www.techonthenet.com/sql/like.php ,Hope this helps or gives you some steer.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, February 1, 2007 4:52 AM
  • User2091908354 posted
    This thread contains some good tips on the SQL searching subject: http://forums.asp.net/thread/1529167.aspx
    Thursday, February 1, 2007 8:15 AM
  • User1227478465 posted



    Hello,<o:o:p></o:o:p>



    Considering that many developers in this forum ask how to implement
    Search Engine in ASP.NET Web Site, my team has created a code sample for this
    frequently asked programming task in
    Microsoft All-In-One Code Framework. You
    can download the code samples at:<o:o:p></o:o:p>



    <o:o:p> </o:o:p>



    VBASPNETSearchEngine<o:o:p></o:o:p>



    http://bit.ly/VBASPNETSearchEngine<o:o:p></o:o:p>



    With these code samples, we hope to reduce developers’ efforts in
    solving the frequently asked <o:o:p></o:o:p>



    programming tasks. If you have any feedback or suggestions for the
    code samples, please email us:
    onecode@microsoft.com. <o:o:p></o:o:p>



    ------------<o:o:p></o:o:p>



    The Microsoft All-In-One Code Framework (http://1code.codeplex.com) is a free,
    centralized code sample library driven by developers' needs. Our goal is to provide
    typical code samples for all Microsoft development technologies, and reduce
    developers' efforts in solving typical programming tasks.
    <o:o:p></o:o:p>



    Our team listens to developers’ pains in MSDN forums, social media
    and various developer communities. We write code samples based on developers’
    frequently asked programming tasks, and allow developers to
    download them
    with a short code sample publishing cycle. Additionally, our team offers
    a free code sample request service. This
    service is a proactive way for our developer community to obtain code samples
    for certain programming tasks directly from Microsoft.
    <o:o:p></o:o:p>



    Thanks<o:o:p></o:o:p>



    Microsoft All-In-One Code Framework<o:o:p></o:o:p>



    Wednesday, March 23, 2011 4:53 AM