SqlConnection sq = newSqlConnection("Data Source=NAFICE-95610AFE\\SQLEXPRESS;Initial Catalog=Automasion;Integrated Security=True");
sq.Open();
SqlCommand cmd = newSqlCommand("Select bakhshcode,namebakhsh From tblbakhsh ",sq );
SqlDataReader reader = cmd.ExecuteReader();
TreeNode tr = null;
while (reader.Read())
{
tr = newTreeNode(reader["namebakhsh"].ToString());
tr.Name = reader["bakhshcode"].ToString();
treeView1.Nodes.Add(tr);
}
reader.Close();
foreach (TreeNode t in treeView1.Nodes)
{
cmd.CommandText = "Select sematcode,namesemat From tblsemat Where bakhshcode='" + t.Name + "'";
reader = cmd.ExecuteReader();
while (reader.Read())
{
tr = newTreeNode(reader["namesemat"].ToString());
tr.Name = reader["sematcode"].ToString();
t.Nodes.Add(tr);
}
reader.Close();
foreach (TreeNode t1 in t.Nodes)
{
cmd.CommandText = "Select karmandnum,name,familly From tblkarmand Where sematcode ='" + t1.Name + "' And bakhshcode='" + t.Name + "'";
reader = cmd.ExecuteReader();
while (reader.Read())
{
tr = newTreeNode(reader["name"].ToString() + ' ' + reader["familly"].ToString());
tr.Name = reader["karmandnum"].ToString();
t1.Nodes.Add(tr);
}
reader.Close();
}
}
sq .Close ();
کدش رو پیدا کردم ممنون
قوانین ایجاد تاپیک در تالار
پاسخ با نقل قول