How to show error message

Question

How to show error message in label when the searching data is not found in the database. Can anyone help me in my problems ?? Thanks a lot :-)

Manoj Bhoir · Answer

Hi Suppose this is sample code : DataClasses1DataContext db = new DataClasses1DataContext(); IQueryable catalogNo = db.Product_Details.Select(p => p.pcatalog); Then You can use .Any() if(catalogNo.Any()) { //I have Data!!! } else { //No data found }

Upendra Pratap Shahi · Answer

public DataView GetProductByID ( string name ) { using ( SqlConnection conn = new SqlConnection ( connstring )) { //string products = @ select*from TblName where name =' + name + ' ; //SqlDataAdapter da = new SqlDataAdapter ( products  conn ); // DataSet ds = new DataSet (); conn . Open (); // da . Fill ( ds ); return ds . Tables [ 0 ]. DefaultView ; //------------ if LINQ otherwise comment this and use above----------------------// var products= from TblName in customers where cust.City == ' + name + ' ; select cust; foreach (string s in products){ if (s!=){//show what do you want} else { Label1.ForeGround = System.Colors.Color.Red; Label1.Text = No Record found! ; } } //------------------- end LINQ------------// } } DataView dvproduct = new DataView (); dvproduct = objManageStore . GetProductByID ( Name ); if ( dvproduct . Table . Rows . Count == 0 ) { //Your Error Message Label1.ForeGround = System.Colors.Color.Red; Label1.Text = No Record found! ; } else { //your execution showing code } if helpful mark as This is correct answer

Najjaf Shuja · Answer

List tblList = (from tb1 in dbEntities.Table1 where tb1.id == 1 // Based on your search criteria select tb1).ToList(); if(tblList == null || tblList.Count() == 0) { label1.foreGround = System.Colors.Color.Red; label1.text = No Record found! ; }

Rajeesh Menoth · Answer

Hi Ref this : http://forums.asp.net/t/1765031.aspx?how+to+show+error+if+search+data+in+not+in+database

Asp.Net Hein · Answer

My code is LINQ code... if possible  please give me correct answer with LINQ