C# Populating Menu Strip from MySQL database

[eihabisaac]

hi all

im using C# with mysql
i want to populate the menustrip items based on the select statement bellow
i can select the items from the table and show them but how to popule the MenuStrip

private void Form2_Load(object sender, EventArgs e)
        {
            textBox1.Text = general.profile.getX().ToString();
            txtDepartment.Text = general.profile.p_department.ToString();

            //Load Menu

            MySqlConnection conn = new MySqlConnection();
            conn.ConnectionString = connString.connString.getConn();

            MySqlDataAdapter da = new MySqlDataAdapter();

            String sqlquery = "SELECT egov_d_menu_items.title FROM egov_users Inner Join egov_employees ON egov_users.ID = egov_employees.fk_user Inner Join egov_department ON egov_employees.fk_department = egov_department.ID Inner Join egov_department_menu ON egov_department_menu.fk_department = egov_department.ID Inner Join egov_d_menu_items ON egov_department_menu.fk_menu_item = egov_d_menu_items.ID where egov_department.ID = '" + txtDepartment.Text + "'";

            MySqlCommand myCommand = new MySqlCommand();

            try
            {
                conn.Open();
            }
            catch (MySqlException myerror)
            {
                MessageBox.Show("Error Connecting to Database: " + myerror.Message);

            }

            myCommand.Connection = conn;
            myCommand.CommandText = sqlquery;
            //start query 
            da.SelectCommand = myCommand;
            MySqlDataReader myData;
            myData = myCommand.ExecuteReader();

            try
            {

                if (myData.HasRows)
                {
                    while (myData.Read())
                    {
                        //code should be some were here 

                    }

                }//if not close connection 
                else
                {
                    conn.Close();
                    MessageBox.Show("error", "Login Error", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
                }




            }
            catch
            {
                MessageBox.Show("Error Connecting to database");
            }
            //End Load Menu
               
        }

thanks in advance

[tlhintoq]

            MenuItem Fred = new MenuItem("Hey Wilma");
            Fred.Click +=new EventHandler(Fred_Click);

[eihabisaac]

Hey all
thanks tlhintoq
i solved the problem but not with your code
i will post the solution later so that any developer can make use of it