动态生成menu

string strSQL = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            strSQL = "Select * from tBigClass";
            DataView dvMain = dv(strSQL);
            foreach (DataRowView dvRV in dvMain)
            {
                MenuItem mi = new MenuItem();
                mi.Text = dvRV["MBTitle"].ToString();
                mi.Value = dvRV["id"].ToString();
                Menu1.Items.Add(mi);
                AddchildItem(mi);
            }
        }
    }

    private void AddchildItem(MenuItem mi)
    {
        int id = Convert.ToInt32(mi.Value);
        DataView dvChild = dv("select * from tSmallClass where MSPid=" + id);
        foreach (DataRowView dvRV in dvChild)
        {
            MenuItem min = new MenuItem();
            min.Text = dvRV["MSTitle"].ToString();

            mi.ChildItems.Add(min);

 

        }

    }

    private DataView dv(string query)
    {
        string strConn;
        SqlConnection sqlConn;
        strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectString"];
        sqlConn = new SqlConnection(strConn);
        sqlConn.Open();
        SqlDataAdapter sda = new SqlDataAdapter(query, sqlConn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "tClass");
        return ds.Tables["tClass"].DefaultView;
    }