//Programme-----------------------------------------------------------------------------------------------------

        //add button
        private void metroButton4_Click(object sender, EventArgs e)
        {
            //Get value from input fiellds


            p.sProgramme = sProgramme.Text;


            //inserting data into the database
            bool success = p.Insert(p);

            if (success == true)
            {
                MessageBox.Show("Successfully Insert");
                //Call the clear method here
            }
            else
            {
                MessageBox.Show("Error");
            }

            // LOAD DATA
            DataTable dtp = p.Select();

            metroGrid2.DataSource = dtp;



            Clear2();
        }