private void Save_Click(object sender, System.EventArgs e) { dob = agebox.Value.ToString("yyyy-MM-dd"); findUID(); string gender = string.Empty; if (male.Checked && female.Checked) { MessageBox.Show("Select one gender"); } if (male.Checked) { gender = "Male"; } else if (female.Checked) { gender = "Female"; } else { MessageBox.Show("Please select a gender:"); } if (!email_Text()) { return; } if (!phone_Text()) { return; } string height = ht.Value.ToString(); string weight = wt.Value.ToString(); string Query = "insert into user (userid,name,password,dob,gender,phoneNo,email,height,weight,category,GoalCalorieIntake) values (" + res + ",'" + name.Text + "','" + NewUser.password + "','" + dob + "','" + gender + "','" + phone.Text + "','" + email.Text + "'," + height + "," + weight + ",'" + category.SelectedItem.ToString() + "',0);"; MySqlCommand cmd = new MySqlCommand(Query, con1); try { con1.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Saved Successfully! Now you re ready to rock!! Please go set the goals ! You can check if our advised goals are sufficient ", "Getting Ready", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Welcome newPage = new Welcome(); newPage.Show(); this.Close(); con1.Close(); // this.Close(); } catch (MySqlException error) { MessageBox.Show(error.Message); } catch (SystemException er) { MessageBox.Show(er.Message); } con1.Close(); }