How to Count in Differnet type of tables in database,?

Show Data label.text

Hi

try this

// Query1
string sql1 = @"select ID,Name from Person  ";
//Query2
string sql2 = @"select FirstName, LastName from Person";
string sql = sql1 + sql2;
// Create connection
SqlConnection conn = new SqlConnection(connString);
try
{
// Open connection
conn.Open();
// Create command
SqlCommand cmd = new SqlCommand(sql, conn);
// Create data reader
SqlDataReader rdr = cmd.ExecuteReader();
// Loop through result sets
do
{
Label.Text(rdr.GetName(0));
while (rdr.Read())
{
// Print one row at a time
Label .text(rdr[0].ToString());
}
}
while (rdr.NextResult());
rdr.Close();
}
catch (SqlException ex)
{
lblMessage.tex(ex.Message + ex.StackTrace,"Exception Details");
}
finally
{ conn.Close();
}