Search inside LINQ Query

Question

0.00/5 (No votes)

See more:

Hi everyone,
Could any body Give an example "How I can Search data inside LINQ query" I want to use it as dataView RowFilter to "Filter" data in datagrid. I'm using this Query

dynamic query;

C#

private void doIt()
{
        query = (from a in myDB.tHE_Move
                 where
                 a.adDateEnd < DateTime.Now
                 select new
                 {
                     Field1= a.Name,
                     Field1 = a.Date,

                 }).ToList();

        dgwGrid.DataSource = query;

}

So if I want to search for specific data, how to use "query" variable, not to select again from DB.
THANKS!

Posted 4-Dec-11 22:49pm

Valdet Zabeli

Updated 4-Dec-11 22:50pm

Eduard Lu

v2

Add a Solution

Comments

[no name] 5-Dec-11 4:51am

EDIT: added "pre" tag

4 solutions

Solution 3

You can probably cache the data from the database inside a collection and then use Where clause of LINQ to filter the data.

Posted 7-Dec-11 23:29pm

Pratik.Patel

Solution 4

You can do this to get what you need:

query.where(s=> s.Field1 == "searchstring").ToList();

Posted 8-Dec-11 0:11am

Hugo1991

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)

**AmitGajjar** · Accepted Answer · 2011-12-05T00:04:00

Solution 1

hi,

you can use,

C#

query.where(s=> s.Field1 == "searchstring").ToList();

here in where clause you can add more complex query to filter your data.
you need to add System.Linq namespace in your class.

thanks
-Amit.

Posted 5-Dec-11 0:04am

AmitGajjar

Updated 5-Dec-11 0:06am

v2

chanti143143 · Accepted Answer · 2011-12-05T00:12:00

Solution 2

You can further filter
1) by writing one more LINQ on query variable or use Where method to filter
like below.
var result = query.Where(row => row.Field1 == "Ramu");

Posted 5-Dec-11 0:12am

chanti143143