private void prescriptionDataGridView_MouseDoubleClick(object sender, MouseEventArgs e) { DataSet1TableAdapters.Prescription_DrugTableAdapter presc_drug = new DataSet1TableAdapters.Prescription_DrugTableAdapter(); DataSet1.Prescription_DrugDataTable dt = presc_drug.GetDataByPrescriptionId((int)((DataRowView)prescriptionBindingSource.Current)["ID"]); String tmp = "DATE:\t" + Convert.ToString(((DataRowView)prescriptionBindingSource.Current)["DATE"]) + "\nDoctor:\t" + Convert.ToString(((DataRowView)prescriptionBindingSource.Current)["Doctor_ID"]) + "\nPatient:\t" + Convert.ToString(((DataRowView)prescriptionBindingSource.Current)["Patient_ID"]) + "\n"; foreach (DataRow row in dt) { tmp += Convert.ToString((String)drugTableAdapter.GetDataByID(Convert.ToInt32(row["DrugID"])).Rows[0]["Name"]) + ":\t" + Convert.ToString(row["NumOfUnits"]) + "\n"; } MessageBox.Show(tmp); }
private void btnOk_Click(object sender, EventArgs e) { if (drugIDComboBox.Text.Trim() == "" || numOfUnitsMaskedTextBox.Text.Trim() == "") { MessageBox.Show("doctor & patient Error"); return; } DataSet1TableAdapters.Prescription_DrugTableAdapter pd = new DataSet1TableAdapters.Prescription_DrugTableAdapter(); DataSet1.Prescription_DrugDataTable dt = pd.GetDataByPDID(PrescriptionID, (int)drugIDComboBox.SelectedValue); if (dt.Rows.Count > 0) { MessageBox.Show("Drug Error"); return; } this.Validate(); this.prescription_DrugBindingSource.EndEdit(); ((DataRowView)prescription_DrugBindingSource.Current)["DrugID"] = (int)drugIDComboBox.SelectedValue; this.prescription_DrugTableAdapter.Update(this.dataSet1.Prescription_Drug); DialogResult = DialogResult.OK; }