数据库权限控制的TreeView绑定示例

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

            int i = 5;
            string sql = "select * from activity as tree   inner join activity as tree_1 on (tree.ac_id = tree_1.ac_id) AND (tree.ac_id ='" + i + "') OR (tree.ac_id <> tree_1.ac_id) AND (tree.ac_parentid = tree_1.ac_id) AND  (tree.ac_parentid = '" + i + "') OR (tree.ac_id <> tree_1.ac_id) AND (tree.ac_parentid = tree_1.ac_id) AND (tree_1.ac_parentid = '" + i + "')";

            DataSet dataSet = SqlHelper.ExecuteDataset(conn, CommandType.Text, sql);
            DataTable dt = dataSet.Tables[0];
            SetTreeViewNode(dt, "0", null);
        }

    }
    private void SetTreeViewNode(DataTable dt, string parentID, TreeNode treeNode)
    {
        DataView dv = dt.DefaultView;
        dv.Sort = "ac_parentid";
        DataRowView[] drvs = dv.FindRows(parentID);
        if (drvs.Length > 0)
        {

            foreach (DataRowView drv in drvs)
            {
                String bookCatIDParent = drv["ac_id"].ToString();
                String bookCatDesc = drv["ac_content"].ToString();
             
                int parentid = Convert.ToInt32(drv["ac_parentid"].ToString());
                TreeNode newTreeNode = new TreeNode(bookCatDesc);
                String url = "t_dafen.aspx";