How to Count in Differnet type of tables in database?

Question

6 different type of tables in database .

How to write a query and How to Diplay in .Cs?

Table Is :

Table 1: Price 1$,

Table 2: Price 1$,

Table 3: Price 1$,

Table 4: Price 1$,

Table 5: Price 1$,

Table 6: Price 1$,

How to Write A Query , In SqlServer , Or Label code also

How to Write Code Or Query ...

Sai Prasad Anumolu · Answer

I need Counting Brother ..... It is not working ....Brother

Sai Prasad Anumolu · Answer

I need Counting Brother ..... It is not working ....Brother

Sanjay Kumar · Answer

Show Data label.text

Sai Prasad Anumolu · Answer

u used Label.text(rdr[0].ToString()); What is meaning of .text what is this ?

Sai Prasad Anumolu · Answer

Thank you Sanjay kumar

Sanjay Kumar · Answer

Hi try this // Query1 string sql1 = @select IDName 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.StackTraceException Details); } finally { conn.Close(); }

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