c treeview 连接mysql_winfrom 的Treeview绑定数据库 求教

private void Form1_Load(object sender, EventArgs e)

{

TreeNode menNode = new TreeNode();

menNode.Text = "男";

TreeNode femaleNode = new TreeNode();

femaleNode.Text = "女";

treeView1.Nodes.Add(menNode);

treeView1.Nodes.Add(femaleNode);

DataTable dt = GetUser();

for (int i = 0; i < dt.Rows.Count; i++)

{

DataRow dr = dt.Rows[i];

TreeNode childNode = new TreeNode();

if (dr[1].ToString()=="男")

{

childNode.Text = dr[0].ToString();

menNode.Nodes.Add(childNode);

}

else if(dr[1].ToString()=="女")

{

childNode.Text = dr[0].ToString();

femaleNode.Nodes.Add(childNode);

}

}

//展开

menNode.ExpandAll();

femaleNode.ExpandAll();

}

///

/// 模拟从数据库 读取的数据 返回DataTable

///

///

private DataTable GetUser()

{

DataTable dt = new DataTable();

DataColumn columnName = new DataColumn("Name", typeof(string));

DataColumn columnSex = new DataColumn("Sex", typeof(string));

dt.Columns.Add(columnName);

dt.Columns.Add(columnSex);

DataRow row = dt.NewRow();

row[0] = "张三";

row[1] = "男";

dt.Rows.Add(row);

DataRow row2 = dt.NewRow();

row2[0] = "李四";

row2[1] = "男";

dt.Rows.Add(row2);

DataRow row3 = dt.NewRow();

row3[0] = "丽力";

row3[1] = "女";

dt.Rows.Add(row3);

return dt;

}

测试结果