Question

treeview绑定数据库的表

如图，图中2个表，action，actioncolumn，分别代表treeview的节点和子节点，根据actioncolumnid关联父节点，求完整代码，怎么绑定到treeview中

Answer 1

string sql="select 银行名，银行CD from 银行表";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(resultDS, "银行表");
sql="select 卡种名，卡种CD，银行CD from 卡种表";
adapter = new SqlDataAdapter(sql, conn);
adapter.Fill(resultDS, "卡种表");

foreach(DataRow row in resultDS.Talbes["银行表"].Rows)
{
string filter="银行CD='"+row["银行CD"].ToString()+"'";
TreeNode tn = new TreeNode();
tn.Name = row["银行CD"].ToString();
tn.Text = row["银行名"].ToString();
treeView1.Nodes.Add(tn);
foreach(DataRow cardrow in resultDS.Talbes["卡种表"].select(filter))
{
TreeNode subtn = new TreeNode();
subtn.Name = 卡种CD;
subtn.Text = 卡种名;
tn.Nodes.Add(subtn);
}

}