Question

怎么样在ASP。net的三层架构中从sqlserver 2088数据库中绑定数据到TreeView中。

怎么样在ASP。net的三层架构中从sqlserver 2088数据库中绑定数据到TreeView中。并且，有父类，子类区别。表中有 CategoryName,parentID,NodeID。NodeID继承于parentID。求给出具体代码！节点层数有4层，根节点1个。他的parentID是-1，NodeID是0.如果给出了加分

Answer 1

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{

CreateData();
CreateTree(TreeView1, null, "0");

}
}

private DataTable dt=new DataTable();
private void CreateData(String where)
{
String sql = String.Format("select CategoryName,parentID,NodeID from treeview {0}",where);
if (dt == null) dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sql, new SqlConnection(Function.ConnectionString));
da.Fill(dt);
}
private void CreateTree(TreeView Tree, TreeNode CurrNode, string ParentID)
{
DataRow[] rows = dt.Select("ParentID='" + ParentID + "'");
foreach (DataRow dr in rows)
{
TreeNode tempNode = new TreeNode();
tempNode.Expanded = true;
tempNode.Value = dr["NodeID"].ToString();
tempNode.Text = dr["CategoryName"].ToString();
if (Tree != null)
{
Tree.Nodes.Add(tempNode);
}
else
{
CurrNode.ChildNodes.Add(tempNode);
}
CreateTree(null, tempNode, tempNode.Value);
}
}

Answer 2

可以使用递归……