Show count items from sql on a label

Question

Hello
I tried to show on a label how many items I have on SQL table

I did this code

public DataTable CountItemsonGrid()
{

return dal.GetTable(string.Format("SELECT COUNT(Finish) AS Expr1 FROM Problems WHERE (Finish = 'false')"));

}

and then

lbcount.Text = pplLogic.CountItemsonGrid().ToString();

whats wrong ?

Banketeshvar Narayan · Answer

When you are getting Data in DataTable then Use this: Datatable dt=---------//your to get datatable if(dt.Rows.Count>0) { lblcount.Text=dt.Rows.Count.Tostring(); } When you are try to print total items of GridView Then use: Gridview1.Rows.Count; ------------------ ------------------ B Narayan Sharma

gavriel ankri · Answer

you solved my problem! thank you !!

Senthilkumar · Answer

I would suggest you to return only the integer value which gives you total count rather than sending datatable. public int CountItemsonGrid() { DataTable dt = dal.GetTable(string.Format(SELECT COUNT(Finish) AS Expr1 FROM Problems WHERE (Finish = 'false'))); return Convert.toInt32(dt.rows[0][0].ToString()); } and then lbcount.Text = pplLogic.CountItemsonGrid().ToString();

Gohil Jayendrasinh · Answer

Your return type is DataTable. Please use like DataTable dt = new DataTable(); dt = pplLogic.CountItemsonGrid(); if (dt != null) { if (dt.Rows.Count > 0) { lbcount.Text = dt.Rows[0][Expr1 ].ToString(); } }