search data bind to gridview using linq on textchange

Question

0.00/5 (No votes)

See more:

hello all

In my project I have an textbox.This textbox is using for searching name.If I will type the letter according to that it will search the name from my contact table and bind the name,address,age in a gridview.

Please anybody know the solution to solve my problem.

thanks in advance!!

Posted 13-Jan-11 2:53am

Starlene

Updated 13-Jan-11 2:56am

RaviRanjanKr

v2

Add a Solution

Comments

RaviRanjanKr 13-Jan-11 8:57am

Please don't use short form of words like plz for please.

Espen Harlinn 13-Jan-11 9:13am

Please show us some code, we might know the answer to your problem, but I for one need more information. Show us how you set up your bindings, are you using a LinqDataSource?

2 solutions

Solution 1

If you are using a LinqDataSource you will probably find the LinqDataSource.Where and LinqDataSource.WhereParameters of interest.

Regards
Espen Harlinn

Posted 13-Jan-11 3:17am

Espen Harlinn

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)

Anupama Roy · Accepted Answer · 2011-01-13T03:35:00

Solution 2

Try something like this.

C#

var query = from r in this.dtContacts.AsEnumerable()
                        where r.Field<string>("Name") == searchname
                        select new{ Age=r["Age"],Address=r["Address"]};

Also,if you want to search based on letter typed in textbox,try StartsWith property of string in where condition of LINQ.It should work,havent tried that.

Posted 13-Jan-11 3:35am

Anupama Roy

Updated 13-Jan-11 4:29am

v3

Comments

RaviRanjanKr 13-Jan-11 9:40am

is He mention anything about XML?

Anupama Roy 13-Jan-11 9:41am

I am not sure,if there is an XML,he has just mentioned contact table,hence I have used dtContacts which is a Datatable.

RaviRanjanKr 13-Jan-11 9:44am

that's silly words if you are not sure I suggest you to ask questioner to be more clear. otherwise your answer will be down-voted by others.
be careful..

Anupama Roy 13-Jan-11 9:47am

Thanks for the suggestion.He has not mentioned anything about XML then why should I ask about that?My example is just a suggestion to get it from a datatable & if people down-vote it,cant help.They must understand that we are here to help due to our willingness to share & help,a free service and not gaining anything out of it :)

Anupama Roy 13-Jan-11 9:49am

Just curious,what makes you think that he is talking about xml?

RaviRanjanKr 13-Jan-11 9:56am

I am not sure probably XML.

Sandeep Mewara 13-Jan-11 11:02am

Chill. You are doing good work. I don't find anything wrong with the answer! Keep going.
5!

:)

Anupama Roy 13-Jan-11 12:39pm

Thanks Sandeep!

Starlene 14-Jan-11 5:12am

thanks Anupama Roy. i got the idea.

Anupama Roy 14-Jan-11 6:38am

You are welcome Starlene!Could you please accept the answer so that it will be marked as solved.Thank You.