LINQ Query to Return multiple results

Question

I am trying to write a textbox that will search on 5 DB columns and will return every result of a given search, ex. "Red" would return: red ball, Red Williams, etc. Any examples or similar things people have tried. My example code for the search.

Thanks.

    ItemMasterDataContext db = new ItemMasterDataContext();

    string s = txtSearch.Text.Trim();
    var q = from p in db.ITMSTs
            where p.IMITD1.Contains(s) ||
             p.IMITD2.Contains(s) ||
             p.IMMFNO.Contains(s) ||
             p.IMITNO.Contains(s) ||
             p.IMVNNO.Contains(s)
            select p;

    lv.DataSource = q;
    lv.DataBind();

So what exactly is the problem? What's wrong with your code? You haven't actually said what your question is. ;) — Stack Overflow is garbage
– Stack Overflow is garbage, Commented Dec 8, 2008 at 16:58

James Curran · Accepted Answer · 2008-12-08 17:08:11Z

1

"q" in your example will be an IQueryable<ITMST>. I don't think the Datasource property of WebControl know what to do with that. try writing that line as:

 lv.DataSource = q.ToList();

answered Dec 8, 2008 at 17:08

James Curran

104k37 gold badges186 silver badges264 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marc Gravell Over a year ago

Unless I'm mistaken, web-binding is happy with IEnumerable<T>, which includes IQueryable<T> - so it should be happy. Winform binding would need the ToList(), though.

Perpetualcoder · Accepted Answer · 2008-12-10 19:44:33Z

0

You can do something like this (syntax may be off )

using(var db = new ItemMasterDataContext())
{
    var s = txtSearch.Text.Trim();
    var result = from p in db.ITMSTs select p;

    if( result.Any(p=>p.IMITD1.Contains(s))
         lv.DataSource = result.Where(p=>p.IMITD1.Contains(s))
    else if ( result.Any(p=>p.IMITD2.Contains(s))
        lv.DataSource = result.Where(p=>p.IMITD1.Contains(s))

    lv.DataBind();
}

or you might want to use this Link or this Link from MSDN.

Happy Coding!!

answered Dec 10, 2008 at 19:44

Perpetualcoder

13.6k10 gold badges67 silver badges101 bronze badges

Comments

davidfowl · Accepted Answer · 2008-12-10 19:05:23Z

0

What you have is generally what people would do using linq. If you wanted to get more complex and use database wild cards then take a look at the SqlMethods class in System.Data.Linq.

@ James Curran You can assign the DataSource property q and it will work fine. The only different is when the query gets executed.

answered Dec 10, 2008 at 19:05

davidfowl

39.2k8 gold badges101 silver badges118 bronze badges

Collectives™ on Stack Overflow

LINQ Query to Return multiple results

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related