TreeView
来源:互联网 发布:我要表白网整站源码 编辑:程序博客网 时间:2024/06/03 17:30
private void bindTree()
{
DataTable dt = this.GetTreeData();
this.FillNode(dt, null);
}
private void FillNode(DataTable dt, TreeNode node)
{
DataView dv = new DataView(dt);
if (node == null)
{
dv.RowFilter = "parentid='0'";
}
else
{
dv.RowFilter = "parentid='" + node.Value + "'";
}
foreach (DataRowView drv in dv)
{
TreeNode no = new TreeNode(drv["menuname"].ToString(), drv["menuid"].ToString());
FillNode(dt, no);
if (node == null)
{
this.TreeView1.Nodes.Add(no);
}
else
{
node.ChildNodes.Add(no);
}
}
}
private DataTable GetTreeData()
{
string strcnn = ConfigurationManager.ConnectionStrings["stringsqlcnn"].ConnectionString;
using (SqlConnection sqlcnn = new SqlConnection(strcnn))
{
SqlCommand sqlcmm = sqlcnn.CreateCommand();
sqlcmm.CommandText = "select * from MenuTree order by parentid,menuorder";
SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
}
动态添加TreeView的数据源。
- treeView
- treeview
- treeview
- treeview
- TreeView
- TreeView
- treeview
- TreeView
- TreeView
- TreeView
- TreeView
- TreeView
- TreeView
- treeview
- TreeView
- TreeView
- treeview
- treeView,
- TCP/IP协议
- pymssql的安装
- Linux 2.6下SPI设备模型(转)
- vc 实现打印功能
- 开源数据库 Sharding 技术 (Share Nothing)
- TreeView
- python之sqlite3使用详解
- 如何成为一个C++高级程序员
- asp.net实现TreeView控件动态增加结点代码
- js window.onload 加载多个函数和追加函数
- 。
- Linux网络编程经典书籍推荐
- EF 4.1 MSDN公约的翻译和整理
- proxychains