2023年6月22日发(作者：)

Winform中常常会涉及这方面的应用，用treeview来绑定四级部门，下面是我在实际经验中总结出来的一段代码，以供参考，并有注释

private void binds()

{

DataSet ds = new DataSet();

SqlConnection con = new

SqlConnection(tionString);

string sql = "select CompanyName from CRM_CompanyInformationFirst";

SqlDataAdapter adapter = new SqlDataAdapter(sql, con);

(ds, "companyname");

foreach (DataRow row in ["companyname"].Rows)//一级菜单 绑定总公司

{

TreeNode tn = new TreeNode();

= row["companyname"].ToString();

= row["companyname"].ToString();

(tn);

DataSet d = new DataSet();

string ss = "select CompanyName from CRM_CompanyInformationSec where

job_no='" + + "'";

SqlDataAdapter da = new SqlDataAdapter(ss, con);

(d, "CompanyName");

foreach (DataRow rows in ["CompanyName"].Rows)//二级菜单 绑定分公司

{

TreeNode tnn = new TreeNode();

= rows["CompanyName"].ToString();

= rows["CompanyName"].ToString();

[].(tnn);

DataSet dd = new DataSet();

string sss = "select CompanyName from CRM_CompanyInformationThird

where job_no1='" + + "' and job_no2='" + + "'";

SqlDataAdapter daa = new SqlDataAdapter(sss, con);

(dd, "CompanyName");

foreach (DataRow rowss in ["CompanyName"].Rows)//三级菜单 绑定部门

{

TreeNode tnnn = new TreeNode(); = rowss["CompanyName"].ToString();

= rowss["CompanyName"].ToString();

[].Nodes[].(tnnn);

DataSet set = new DataSet();

string str = "select * from CRM_CompanyInformationForth where

job_no1='" + + "' and job_no2='" + + "' and job_no3='" + + "'";

SqlDataAdapter adapters = new SqlDataAdapter(str, con);

(set, "CompanyName");

foreach (DataRow r in ["CompanyName"].Rows)//四级菜单 绑定分部门

{

TreeNode tree = new TreeNode();

= r["CompanyName"].ToString();

= r["CompanyName"].ToString();

[].Nodes[].Nodes[].(tree);

}

}

}

}

}