如何通过从数据库中检索数据来绑定树视图中的数据..？
问题描述：
嗨..
我正在使用windowApplication.I我对树视图控件一无所知。我必须从数据库中绑定树视图中的数据。我有一张表在数据库中作为OrderDetails。在我有两列如BillNo和OrderNo.so我必须将BillNo显示为parentnode
和orderno作为childnode.Like;
+ BillNO
-OrderNo1
-OrderNo2。
我该怎么办请总结帮助我..
谢谢。
Hi..
I am using windowApplication.I dont have any idea about treeview control.I have to bind data in treeview from database.I have a table in database as "OrderDetails".In that i have two column like BillNo and OrderNo.so I have to show BillNo as parentnode
and orderno as childnode.Like this;
+BillNO
-OrderNo1
-OrderNo2.
how would i do this please sumbody help me..
Thanks.
答
检查这个逻辑可能对你有帮助。
Check this logic it might helps u.
dsModules = bfOnlyMasterPage.GetModuleTreeViewList(cmnOnlyMasterPage);// Get dataset from database.
DataTable dt=dsModules.Tables[0];
foreach (DataRow masterRow1 in dt.Rows)
{
TreeNode masterNode1 = new TreeNode((string)masterRow1["BillNO"], Convert.ToString(masterRow1["BillNO"]));
trView.Nodes.Add(masterNode1);
foreach (TreeNode tn in trView.Nodes)
{
DataRow[] drlevels = dsModules.Tables[0].Select("BillNO=" + tn.Value);
int i = 0;
foreach (DataRow drlevel in drlevels)
{
tn.ChildNodes.Add(new TreeNode(drlevel["OrderNo1 "].ToString(), drlevel["OrderNo1 "].ToString()));
i++;
}
}
}