Populating repeater using the same technology as autocomplete for textboxes

Question

0.00/5 (No votes)

See more:

Hi
I have a text box on a form and a database that stores first and last names, address, etc I wanna display on a repeater or datagrid all the details of the people who match any characters typed on the textbox whether its their stored email, Firstname lastname or telephone number...

Please I know it might be complex but any help will be really useful, just like how google searches
but i want it to search a single table.

Thank you in advance.

Posted 4-Sep-12 22:22pm

mlingo209

Add a Solution

Comments

__TR__ 5-Sep-12 4:32am

Look like you asked the same question twice. Please delete one of them.

mlingo209 5-Sep-12 4:43am

Done! Thanks did not notice.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Expert Coming · Accepted Answer · 2012-09-06T08:52:00

It is actually not that difficult. What you are going to need to do is return all rows that CONTAIN the search string in any of the columns.

It is pretty simple to do with LINQ.

Unfortunately if you are writing the SQL statement yourself, it will be a pretty ugly mess of 'if firstname contains searchstring OR if lastname contains searchstring' ect.

Actually, the LINQ is pretty close to as ugly, but IMO is a bit easier to read.