في الكود المرفق اريد اظهار على سبيل المثال زاوية وتحتها زاوية داخلية ولكن الشمكلة لا يظهر لي سوا نتيجة واحدة من عدد نتائج كثيرة اي يظهر فقط اخر سطر في الداتا بيس؟؟
if (!IsPostBack)
{
//String strConnection = ConfigurationManager.ConnectionStrings["ZoalConnectionString"].ToString();
//SqlConnection conn = new SqlConnection(strConnection);
//SqlCommand com = new SqlCommand();
////com.Connection = strConnection;
//com.CommandText = "SELECT C.Cid, S.Cid, S.SubCid, S.CName, C.CommName, C.CommTime, C.CommSubject, C.CommBody FROM SubComm AS S LEFT JOIN Comments AS C ON (C.Cid=S.Cid)";
String strConnection = ConfigurationManager.ConnectionStrings["ZoalConnectionString"].ToString();
SqlConnection conn = new SqlConnection(strConnection);
SqlCommand comm = new SqlCommand("SELECT C.Cid, S.Cid, S.SubCid, S.CName, C.CommName, C.CommTime, C.CommSubject, C.CommBody FROM SubComm AS S LEFT JOIN Comments AS C ON (C.Cid=S.Cid)", conn);
try
{
conn.Open();
using (SqlDataReader reader = comm.ExecuteReader())
{
string Name;
Name = "";
int Counter = 0;
while (reader.Read())
{
if (Name == reader["CommName"].ToString())
{
for (int i = 0; i < Counter.ToString().Length; i++)
{
Comment.Text = reader["CommName"].ToString();
}
}
for (int i = 0; i < Counter.ToString().Length; i++)
{
SubComm.Text = reader["CName"].ToString();
Name = reader["CommName"].ToString();
}
}
}
}
catch (Exception)
{
conn.Close();
}
}
}