Category: LINQ

15 May 2015 19:59

Joined:	25/04/2014
Level:	Silver
Points:	101

Points:	3

How to write Linq query for below requirement

Hiiii All
i got a requirement that is ,i have two fields one is dropdown and textbox ,
it should display the records based on the entered text in the textbox and dropdown value
if the textbox value null ,dropdown value null then it should display all the records

please suggest me how to write Linq query for the above requirement

#758873

15 May 2015 22:53

Joined:	06/04/2012
Level:	Gold
Points:	4230

Points:	3

Hello Nagendra,

Refer the below example:
Query for Records based on textbox and dropdown value:
var queryCustomers = from cust in customers
where cust.City == '" + DropDownList1.SelectedValue + "' && cust.Name == '" + TextBox1.Text + "'
select cust;

Query for all records
var queryCustomers = from cust in customers
select cust;

Hope this will help you.
Mark the answer if it helped you.

Regards,
Nirav Lalan
DNS Gold Member
"If you can dream it, you can do it."

#758881

16 May 2015 18:10

Joined:	25/04/2014
Level:	Silver
Points:	101

Points:	1

Hiiii
i need single Linq Query for the above recuriment

#760683

17 Jul 2015 04:20

Joined:	21/01/2014
Level:	Silver
Points:	134

Points:	4

Hi
You can refer following code

var Query = lstCustomer.ToList();
if (!string.IsNullOrEmpty(drpCustomer.SelectedText))
{
Query = Query.Where(x => x.CustomerName ==drpCustomer.SelectedText).ToList();
}
if (!string.IsNullOrEmpty(TxtAddress))
{
Query = Query.Where(x => x.Address == TxtAddress).ToList();
}
List<Customer> lstResult = Query.ToList<Customer>()

Thanks
Umesh Bhosale

How to write Linq query for below requirement

About dotnetspider.com

Quick Links

General

Services