Search multiple column using multiple control in asp.net using linq

Question

Project_Detail pro = new Project_Detail();
string title=Ttitle.Text;
string year1=Tyear.Text;
string key = Tkeywrds.Text;
string area = Ddl_area.Text;
string categ = Ddl_catgry.Text;
string tech = Ddl_tech.Text;
string type =Ddl_type.Text;

var q = from obj in da.Project_Details
        where obj.Project_Title.Contains(title) 
              || obj.Submission_Date.Contains(year1) 
              || obj.Keywords.Contains(key) 
              || obj.Project_Area.Contains(area) 
              || obj.Project_Category.Contains(categ) 
              || obj.Project_Technology.Contains(tech) 
              || obj.Project_Type.Contains(type)
        select obj;

if (q != null)
{
    DetailsView1.DataSource = q;
    DetailsView1.DataBind();
}
else
{
    Literal1.Text = "Data not found";
}

this code give last record of table and also not give else condition result. I want result of all condition and want to use LIke satatement.

if you want to use sql like : SqlMethods.Like(obj.parameter). — Devraj Gadhavi
– Devraj Gadhavi, Commented Apr 8, 2013 at 10:24
If any of the search strings is empty, your query will return all elements, as myString.Contains("") always returns true. — alzaimar
– alzaimar, Commented Apr 9, 2013 at 5:37

alzaimar · Accepted Answer · 2013-04-08 06:49:56Z

1

q is never null. It might be empty, though. So you should change your code to

if (q.Any()) // <<-----
{
    DetailsView1.DataSource = q;
    DetailsView1.DataBind();
}
else
{
    Literal1.Text = "Data not found";
}

answered Apr 8, 2013 at 6:49

alzaimar

4,6321 gold badge22 silver badges31 bronze badges

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

4 Comments

avinash Over a year ago

its not working with multiple search option.its working with one query like obj.Project_Title.Contains(title) this it is working but when have multiple condition like obj.Project_Title.Contains(title) || obj.Submission_Date.Contains(year1) || obj.Keywords.Contains(key) || obj.Project_Area.Contains(area) || obj.Project_Category.Contains(categ) || obj.Project_Technology.Contains(tech) || obj.Project_Type.Contains(type) its not working .Its give all record which in the table Please Help ...

alzaimar Over a year ago

The problem is your where clause. If you have the profiler available, get the query and examine your data.

avinash Over a year ago

Linq query for multiple search operation with multiple control

alzaimar Over a year ago

The problem is your logic. What happens, if any of the strings to compare is empty?

शेखर · Accepted Answer · 2013-04-08 07:12:32Z

0

You can also use count method .Count()

if (q.count()>0)
{
    DetailsView1.DataSource = q;
    DetailsView1.DataBind();
}
else
{
    Literal1.Text = "Data not found";
}

answered Apr 8, 2013 at 7:12

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

1 Comment

avinash Over a year ago

its not working with multiple search option.its working with one query like obj.Project_Title.Contains(title) this it is working but when have multiple condition like obj.Project_Title.Contains(title) || obj.Submission_Date.Contains(year1) || obj.Keywords.Contains(key) || obj.Project_Area.Contains(area) || obj.Project_Category.Contains(categ) || obj.Project_Technology.Contains(tech) || obj.Project_Type.Contains(type) its not working .Its give all record which in the table Please Help ...

Collectives™ on Stack Overflow

Search multiple column using multiple control in asp.net using linq

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related