چه طور می شود اطلاعات را نشان داد و اعداد مرطبت با آن را جمع و نمایش داد

[m.ghorbani2000]

پس دستور این شکلی می شه

SqlConnection con = new SqlConnection();

           con.ConnectionString = strConnection;

           SqlCommand cmd = new SqlCommand();

           SqlCommand exp = new SqlCommand();

           cmd.Connection = con;

           exp.Connection = con;

           cmd.CommandType = System.Data.CommandType.Text;

           exp.CommandType = System.Data.CommandType.Text;

           cmd.CommandText = "SELECT Shomare_Hesab, Moshaver_Name,Moshaver_Family,Moshaver_ID FROM tblMoshaver WHERE Moshaver_ID = 20000";

           exp.CommandText = "SELECT COUNT (*) * 200000  FROM tblBarnameHozour WHERE Mamayi = 20000 AND Vazeyat LIKE '%حاضر%'";

           con.Open();

           SqlDataReader reader1 = cmd.ExecuteReader();

           DataTable dt = new DataTable();

           dt.Load(reader1);

	foreach(datarow tmp in dt)

	{

		Console.WriteLine("Name:{0}", tmp["Moshaver_Name"]);

		Console.WriteLine("Family:{0}", tmp["Moshaver_Family"]);

		Console.WriteLine("Nuber of Account:{0}", tmp["Shomare_Hesab"]);

		Console.WriteLine("Money:{0} {1}", exp.ExecuteScalar(), "RLS");

	}

 

           }

           con.Close();