Linq Query

Ramco Ramco

I want if user has selected any value in Listbox then it should filter , else all values of ListBox

public List GetOpen(Int32 ddl0)
        {
            List Result = (from t in context.Headers
                                            where t.IsActive == true 

                                            select t).ToList();
            return Result;
        }

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
1. public List
  GetOpen(Int32 ddl0)
2. {
3. List
  Result= new List
  ();
4. if(ddl0!=0)
5. {
6. Result=(from t in context.Headers
7. where t.IsActive == true && t.SomeColumn==ddl0
9. select t).ToList();
12. } else
13. Result={from t in context.Headers
14. where t.IsActive == true
15. select t).ToList();
17. }
18. return Result;
19. }