Display Message When No Data Found Using Linq to Sql using C#

Question

I am very new to Linq & I am not getting how to show a message if the Linq query does not find any data in the Sql Table. e.g in ADO.Net We used to do like this

ADO.NET :-

    if(ds.Tables[0].Rows.count>0)

    {

    //Do Some Task

    }

    else

    {

    MessageBox.Show("No Data Found"); 

    }

LINQ TO SQL;-

    DataClasses1DataContext db = new DataClasses1DataContext();

    IQueryable<int> catalogNo = db.Product_Details.Select(p => p.pcatalog);

    if (What To Check Here?)

    {

    MessageBox.Show("No Data Found");

}

Can any one please help me? Thanks a ton in advance

Berto · Accepted Answer · 2014-07-30 11:41:29Z

2

You can use .Any()

if(catalogNo.Any()){
  //I have Data!!!
}else{
  //No data found
}

answered Jul 30, 2014 at 11:41

Berto

6741 gold badge8 silver badges11 bronze badges

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

Comments

Kokom · Accepted Answer · 2014-07-30 11:58:26Z

0

catalogNo.Any() or catalogNo.Count() > 0

answered Jul 30, 2014 at 11:58

Kokom

11 silver badge

Collectives™ on Stack Overflow

Display Message When No Data Found Using Linq to Sql using C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related