private void CmbPrd_SelectedIndexChanged(object sender, EventArgs e)
        {
            MySqlConnection mycon = new MySqlConnection("datasource=localhost;username=root;password='';database=fsd");
            MySqlCommand cmd;
            MySqlDataReader Mdr;
            String Query;

            mycon.Open();
           Query = "Select * from product where (prodcode)=('" + Convert.ToInt16(CmbPrd.Text) + "');"; //FIX THIS
            cmd = new MySqlCommand(Query, mycon);
            Mdr = cmd.ExecuteReader();

            if (Mdr.Read())
            {
                TxtProduct.Text = Mdr.GetString("ProdCode");
                TxtDesc.Text = Mdr.GetString("ProdDescription");
                CmbType.Text = Mdr.GetString("ProdType"); //DOES THIS UPDATE EVERYTHING?
            }