how to create dynamic menu using asp.net menu from sql database

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

    }
    private void getMenu()
    {
        SqlConnection con = new SqlConnection(connStr);
        con.Open();
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        string sql = "Select * from menu";
        SqlDataAdapter da = new SqlDataAdapter(sql, con);
        da.Fill(ds);
        dt = ds.Tables[0];
        DataRow[] drowpar = dt.Select("parentid=" + 0);

        foreach (DataRow dr in drowpar)
        {
            menubar.Items.Add(new MenuItem(dr["menuname"].ToString(),
                    dr["menuid"].ToString(), "",
                    dr["menulocation"].ToString()));
        }

        foreach (DataRow dr in dt.Select("parentid >" + 0))
        {
            MenuItem mnu = new MenuItem(dr["menuname"].ToString(),
                           dr["menuid"].ToString(),
                           "", dr["menulocation"].ToString());
            menubar.FindItem(dr["parentid"].ToString()).ChildItems.Add(mnu);
        }
        con.Close();
    }



database query
create table menu(menuid int,menuname varchar(150),menulocation varchar(150),parentid int)