I'm new in LINQ so I hope this isn't a stupid question:
I have a table with a lot of content presented in a datagrid, and I want the user to be able to filter the grid by using some combo boxes above the grid [like a search bar]
I created a method that takes the text in the combo boxes, and placing it the "Where" clause:
public void find()
{
string disName;
string statusName;
disName = RMcmbDis.Text; //This Get the first string to filter
statusName = RMcmbStatus.Text; // this get the second string to filter
//Here I gather all the data I need
var allCNT = from x in cntDB.releases
join dis in cntDB.disciplines on x.discipline equals dis.discipline_id
join btch in cntDB.batches on x.batch_num equals btch.batch_id
join z in cntDB.status on x.status equals z.status_id
select new { dis.discipline_name, x.grade, x.batch_num, btch.batch_name, z.status_description, x.segment_leader, x.ped_leader, x.release_location, x.comments, x.QA_Verdict };
//Here I make the filtering
var find = allCNT.Where(a => a.discipline_name == disName && a.status_description == statusName);
dataGridView1.DataSource = find;
}
Now I have a problem: I want the user to be able to leave one of the combo boxes empty and if he does so, this means he doesn't want to filter that criteria. [E.G - The combo "RMcmbDis" has "Math" and the Status combo ["RMcmbStatus"] is empty, so the grid will show only "Math" in all status'.
How Do I do that? Thanks guys... N.
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)
