private void Bind()
{
SqlConnection conn = new SqlConnection();
conn = DataAccess.DataAccessSqlconnection();
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
ds=DataAccess.ReturnDataSet(conn,CommandType.Text,"select distinct(e_dept) from ep01","ep01");
MessageBox.Show(ds.Tables[0].Rows.Count.ToString());
TreeNode catenode;
TreeNode pronode;
foreach (DataRow caterow in ds.Tables[0].Rows)
{
catenode = new TreeNode();
catenode.Text = caterow["e_dept"].ToString();
catenode.Tag = caterow["e_dept"].ToString();
treeView1.Nodes.Add(catenode);
ds1 = DataAccess.ReturnDataSet(conn, CommandType.Text, "select e_no,e_name from ep01 where e_dept='" + caterow["e_dept"].ToString() + "'", "ep01");
if (ds1.Tables[0].Rows.Count > 0)
{
foreach (DataRow prorow in ds1.Tables[0].Rows)
{
pronode = new TreeNode();
pronode.Text = prorow["e_name"].ToString();
pronode.Tag = prorow["e_no"].ToString();
catenode.Nodes.Add(pronode);
//catenode.ChildNodes.Add(pronode);
}
//ds.Tables[0].Clear();
}
}
}