problem is related to menu plz read whole.....

See more:

ASP.NET

i have a problem i.e. related to menus actually i want that at run time menu and submenu should be generated.what shoul i do for that.i have used one code in that i have 2 menus taht are in table and there are 4 menus regarding to one but its not showing.its showing only one at a time.. and another one is showing for another menu.i m using this code:>

void menu_MenuItemClick(object sender, MenuEventArgs e)
    {
        string selected = e.Item.Text;
        //SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        SqlDataAdapter adCat = new SqlDataAdapter("SELECT menu_id FROM menu where menu_name='" + selected + "'", con);
        DataTable dt = new DataTable();
        adCat.Fill(dt);
        int id = Convert.ToInt32(dt.Rows[0]["menu_id"].ToString());
        //Response.Redirect("Default2.aspx?id=" + id);

    }
    private void PopulateMenu()
    {
        DataSet ds = GetDataSetForMenu();

        Menu menu = new Menu();
        
        menu.MenuItemClick += new MenuEventHandler(menu_MenuItemClick);
        foreach (DataRow parentItem in ds.Tables["menu"].Rows)
        {
            MenuItem categoryItem = new MenuItem((string)parentItem["menu_name"]);

            menu.Items.Add(categoryItem);

            foreach (DataRow childItem in parentItem.GetChildRows("Children"))
            {

                MenuItem childrenItem = new MenuItem((string)childItem["submenu_name"]);
                categoryItem.ChildItems.Add(childrenItem);
                
            }
            
        }

        Panel1.Controls.Add(menu);
        Panel1.DataBind();

    }
    private DataSet GetDataSetForMenu()
    {
        
        SqlDataAdapter adCat = new SqlDataAdapter("SELECT * FROM menu", con);
        SqlDataAdapter adProd = new SqlDataAdapter("SELECT * FROM submenu", con);

        DataSet ds = new DataSet();
        adCat.Fill(ds,"menu");
        adProd.Fill(ds,"submenu");

        ds.Relations.Add("Children", ds.Tables["menu"].Columns["menu_id"], ds.Tables["submenu"].Columns["submenu_id"],false);
        return ds;

    }

and at page load this method i.e. PopulateMenu(); is called.