ًُ
SqlCommand Cmd = new SqlCommand("Select Count(*) From TableName", Conn);
Conn.Open();
label1.Text = Cmd.ExecuteScalar().ToString();
Conn.Close();