一次绑定数据到TreeView

 protected void TreeBind()
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;

        SqlDataReader DA =  ExecPro.ExecPro.ExecuteReader(connStr, CommandType.StoredProcedure, "GetCity");

        string  CurProid;
        int TreeNodeIndex;
        CurProid = "";
        TreeNodeIndex = -1;
        while (DA.Read())
        {
            if (CurProid != DA["proid"].ToString())
            {

                //取得根节点，并加载到树
                TreeNode treenodeParent = new TreeNode();
                treenodeParent.Text = DA["proname"].ToString();
                treenodeParent.Value = DA["proid"].ToString();
                Tree1.Nodes.Add(treenodeParent);
                TreeNodeIndex = TreeNodeIndex + 1;
            }
          
            CurProid = DA["proid"].ToString();

            //根据上层根节点，加载叶节点
            TreeNode ParentNode = Tree1.Nodes[TreeNodeIndex];
            TreeNode treenodeChild = new TreeNode();
            treenodeChild.Value = DA["cityid"].ToString();
            treenodeChild.Text = DA["cityname"].ToString();
            ParentNode.ChildNodes.Add(treenodeChild);
        }
    }

 

以上这段代码可以实现将数据源直接绑定到TreeView，使用起来比较方便