private void button1_Click(object sender, EventArgs e) { AddEdit addNew = new AddEdit(); addNew.Show(); constraintsList.Visible = false; }
private void btnsave_Click(object sender, EventArgs e) { // --- confirmation with message box --- string message = "Do you want to Save the changes?"; string title = "Please Confirm!"; MessageBoxButtons buttons = MessageBoxButtons.YesNo; DialogResult result = MessageBox.Show(message, title, buttons, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { db.openConnection(); // open connection MySqlCommand cmd = new MySqlCommand("UPDATE `student` SET indexno=@index,firstname=@firstname,lastname=@lastname,address=@address,gender=@gender,dob=@dob,email=@email,faculty=@faculty,mobile=@mobile,image=@image WHERE indexno ='" + selected + "'", db.getConnection()); // --- image --- MemoryStream ms = new MemoryStream(); picImg.Image.Save(ms, picImg.Image.RawFormat); byte[] img = ms.ToArray(); // ---- AddEdit addEdit = new AddEdit(); cmd.Parameters.Add("@index", MySqlDbType.VarChar).Value = txtindex.Text; cmd.Parameters.Add("@firstname", MySqlDbType.VarChar).Value = txtfname.Text; cmd.Parameters.Add("@lastname", MySqlDbType.VarChar).Value = txtlname.Text; cmd.Parameters.Add("@address", MySqlDbType.VarChar).Value = txtaddress.Text; cmd.Parameters.Add("@gender", MySqlDbType.VarChar).Value = addEdit.getGender(); cmd.Parameters.Add("@dob", MySqlDbType.Date).Value = dateDob.Value.Date; cmd.Parameters.Add("@email", MySqlDbType.VarChar).Value = txtemail.Text; cmd.Parameters.Add("@faculty", MySqlDbType.VarChar).Value = cmbfaculty.GetItemText(cmbfaculty.SelectedItem); cmd.Parameters.Add("@mobile", MySqlDbType.VarChar).Value = txtmobile.Text; cmd.Parameters.Add("@image", MySqlDbType.Blob).Value = img; // query executed? if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Record added!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); openRecs.searchData(""); // refreshing by reloading data from db this.Close(); } else { MessageBox.Show("Failed!, please retry", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } db.openConnection(); // close connection } }