11.29

 今天通过基本懂了!

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            bindTree();
    }
    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["treecnn"].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];
        }
    }
}