try this
create dynamic query like that
and pass one parameter to database
Collapse
if (InterviewCategoryId == 0)
{
if (DateTo == "" && SearchByName == "" && DateFrom != "")
{
Query += " ";
}
else if (DateTo != "" && DateFrom == "" && SearchByName == "")
{
Query += " ";
}
else if (DateTo == "" && DateFrom == "" && SearchByName != "")
{
Query += " ";
}
else if (DateTo != "" && DateFrom != "" && SearchByName != "")
{
Query += "";
}
else
{
Query += "";
}
pass it to the DataBase as one Parameter;
Obj.fn_GetSearcgCandidatesResult(Query);