Last post Mar 23, 2011 04:53 AM by Microsoft All-In-One Code Framework
Feb 01, 2007 02:24 AM|thtang|LINK
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.
Feb 01, 2007 04:52 AM|Hope4sun|LINK
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.
SQL LIKE QUERY
Feb 01, 2007 08:15 AM|cloris|LINK
Mar 23, 2011 04:53 AM|Microsoft All-In-One Code Framework|LINK
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:
With these code samples, we hope to reduce developers’ efforts in
solving the frequently asked
programming tasks. If you have any feedback or suggestions for the
code samples, please email us: firstname.lastname@example.org.
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.
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
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.
Microsoft All-In-One Code Framework