private void btnInsert_Click(object sender, EventArgs e) { if (tbPLZ.Text == string.Empty || tbOrt.Text == string.Empty) { MessageBox.Show("Bitte Eingabefelder vollständig erfassen.", "Eingabe", MessageBoxButtons.OK, MessageBoxIcon.Warning); tbPLZ.Focus(); return; } int plz = 0; if (!int.TryParse(tbPLZ.Text, out plz)) { MessageBox.Show("Ungültige PLZ eingetragen.", "Eingabe", MessageBoxButtons.OK, MessageBoxIcon.Warning); tbPLZ.Focus(); return; } // Ort einfügen if (ArztDB.InsertOrt(plz, tbOrt.Text)) { // Liste anzeigen OrtListe(); } }
private void btnCalc_Click(object sender, EventArgs e) { lbResult.Text = "0"; int result = ArztDB.GetNumKonsultation(tbDiagnose.Text); lbResult.Text = result.ToString(); }
private void btnCalc_Click(object sender, EventArgs e) { // Methode GetNumKonsultation() aufrufen string diagnose = tbDiagnose.Text; // Resultat an lbResult.Text zuweisen int result = ArztDB.GetNumKonsultation(diagnose); lbResult.Text = result.ToString(); }
/// <summary> /// Stored procedure aufrufen /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCalc_Click(object sender, EventArgs e) { int z1 = Convert.ToInt32(tbZ1.Text); int z2 = Convert.ToInt32(tbZ2.Text); int z3 = Convert.ToInt32(tbZ3.Text); int z4 = Convert.ToInt32(tbZ4.Text); int z5 = Convert.ToInt32(tbZ5.Text); int result = ArztDB.Scores(z1, z2, z3, z4, z5); lbResult.Text = result.ToString(); }
private void btnLoad_Click(object sender, EventArgs e) { DataSet ds = ArztDB.ArztListe(); foreach (DataRow dr in ds.Tables[0].Rows) { int row = dgvList.Rows.Add(); dgvList.Rows[row].Cells[0].Value = dr["AZT_ID"]; dgvList.Rows[row].Cells[1].Value = dr["AZT_NAME"]; dgvList.Rows[row].Cells[2].Value = dr["PLZ_ID"]; dgvList.Rows[row].Cells[3].Value = dr["PLZ_ORT"]; } }
private void OrtListe() { dgvOrt.Rows.Clear(); DataSet ds = ArztDB.PlzListe(); if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) { int row = dgvOrt.Rows.Add(); dgvOrt.Rows[row].Cells[0].Value = dr["PLZ_ID"]; dgvOrt.Rows[row].Cells[1].Value = dr["PLZ_ORT"]; } } }