title: How to display count(*) to label text in asp.net using c#.net
body: <p>How to display count(*) to label text in asp.net using c#.net i mean  tbl1 is Having 10 rows that 10 value set to label text </p>
  
  <p><code>con.Open();
          SqlCommand cmd = new SqlCommand("select count(newsid)from tbl_news where newsid=44,con);
          SqlDataAdapter da = new SqlDataAdapter();
          da.SelectCommand = cmd;
          DataSet ds = new DataSet();
          da.Fill(ds);<br>
          con.Close();
          lbl_so.Text = ds.Tables[0].Rows.Count.ToString();</code></p>