private void btnSubmit_Click(object sender, EventArgs e) { Form diag = new Diagnosis2(); diag.Show(); /* * using (var con = new MySqlConnection(conClass.connectionString)) * { * con.Open(); * using (var com = new MySqlCommand("UPDATE registration SET patient_Lname = @patient_Lname WHERE registration_id = @registration_id", con)) * { * //com.Parameters.AddWithValue("@registration_id", txtID.Text); * //com.Parameters.AddWithValue("@patient_Lname", txtLname.Text); * * * DialogResult r = MessageBox.Show("Mark appointment as done?", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); * * if (r == DialogResult.OK) * { * com.ExecuteNonQuery(); * } * else * { * MessageBox.Show("Cancelled"); * } * * } * con.Close(); * * * } */ }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { selectID = int.Parse(dataGridView1.Rows[e.RowIndex].Cells["registration_id"].Value.ToString()); string firstname = dataGridView1.Rows[e.RowIndex].Cells["patient_Fname"].Value.ToString(); string middlename = dataGridView1.Rows[e.RowIndex].Cells["patient_Mname"].Value.ToString(); string lastname = dataGridView1.Rows[e.RowIndex].Cells["patient_Lname"].Value.ToString(); string lab_crea = dataGridView1.Rows[e.RowIndex].Cells["lab_crea"].Value.ToString(); string lab_sgpt = dataGridView1.Rows[e.RowIndex].Cells["lab_sgpt"].Value.ToString(); string lab_FBS = dataGridView1.Rows[e.RowIndex].Cells["lab_FBS"].Value.ToString(); string lab_acid = dataGridView1.Rows[e.RowIndex].Cells["lab_acid"].Value.ToString(); string chest_XrayResult = dataGridView1.Rows[e.RowIndex].Cells["chest_XrayResult"].Value.ToString(); string sputum_month = dataGridView1.Rows[e.RowIndex].Cells["sputum_month"].Value.ToString(); string sputum_due = dataGridView1.Rows[e.RowIndex].Cells["sputum_due"].Value.ToString(); string sputum_examDate = dataGridView1.Rows[e.RowIndex].Cells["sputum_examDate"].Value.ToString(); string sputum_result = dataGridView1.Rows[e.RowIndex].Cells["sputum_result"].Value.ToString(); string sputum_appearance = dataGridView1.Rows[e.RowIndex].Cells["sputum_appearance"].Value.ToString(); string doctors_order = dataGridView1.Rows[e.RowIndex].Cells["doctors_order"].Value.ToString(); string exam_reason = dataGridView1.Rows[e.RowIndex].Cells["exam_reason"].Value.ToString(); string hist_treatment = dataGridView1.Rows[e.RowIndex].Cells["hist_treatment"].Value.ToString(); string specimen_type = dataGridView1.Rows[e.RowIndex].Cells["specimen_type"].Value.ToString(); string specimen_date1 = dataGridView1.Rows[e.RowIndex].Cells["specimen_date1"].Value.ToString(); string speciman_date2 = dataGridView1.Rows[e.RowIndex].Cells["speciman_date2"].Value.ToString(); string test_request = dataGridView1.Rows[e.RowIndex].Cells["test_request"].Value.ToString(); string prepared_by = dataGridView1.Rows[e.RowIndex].Cells["prepared_by"].Value.ToString(); string staff_position = dataGridView1.Rows[e.RowIndex].Cells["staff_position"].Value.ToString(); string visual_appearance1 = dataGridView1.Rows[e.RowIndex].Cells["visual_appearance1"].Value.ToString(); string visual_appearance2 = dataGridView1.Rows[e.RowIndex].Cells["visual_appearance2"].Value.ToString(); string visual_appearanceXpert = dataGridView1.Rows[e.RowIndex].Cells["visual_appearanceXpert"].Value.ToString(); string reading1 = dataGridView1.Rows[e.RowIndex].Cells["reading1"].Value.ToString(); string reading2 = dataGridView1.Rows[e.RowIndex].Cells["reading2"].Value.ToString(); string readingX = dataGridView1.Rows[e.RowIndex].Cells["readingX"].Value.ToString(); string LabDiag = dataGridView1.Rows[e.RowIndex].Cells["LabDiag"].Value.ToString(); string LabX = dataGridView1.Rows[e.RowIndex].Cells["LabX"].Value.ToString(); string tbdc_rec = dataGridView1.Rows[e.RowIndex].Cells["tbdc_rec"].Value.ToString(); string suggestions = dataGridView1.Rows[e.RowIndex].Cells["suggestions"].Value.ToString(); var diag = new Diagnosis2(selectID, firstname, middlename, lastname, lab_crea, lab_sgpt, lab_FBS, lab_acid, chest_XrayResult, sputum_month, sputum_due, sputum_examDate, sputum_result, sputum_appearance, doctors_order, exam_reason, hist_treatment, specimen_type, specimen_date1, speciman_date2, test_request, prepared_by, staff_position, visual_appearance1, visual_appearance2, visual_appearanceXpert, reading1, reading2, readingX, LabDiag, LabX, tbdc_rec, suggestions); diag.ref_To_Main = this; diag.ShowDialog(); }