private void button3_Click(object sender, EventArgs e) { DBActions.AddAccident(frmdescription.Text, repairCheck.Checked, Convert.ToDateTime(repairTime.Text)); SqlConnection baglanti = new SqlConnection(connectionString); baglanti.Open(); string arama = "SELECT ID FROM tblIncident WHERE Description = @description"; SqlCommand komut = new SqlCommand(arama, baglanti); komut.Parameters.AddWithValue("@description", frmdescription.Text); // komut.ExecuteNonQuery(); SqlDataReader dr = komut.ExecuteReader(); if (dr.Read()) { textBox3.Text = dr["ID"].ToString(); } else { MessageBox.Show("Arama TAMAMLANAMADI..."); } // ResetScreen(); baglanti.Close(); }
private void btnSave_Click(object sender, EventArgs e) { try { DBActions.AddAccident(frmdescription.Text, repairCheck.Checked, Convert.ToDateTime(repairTime.Text)); resetScreen(); MessageBox.Show("GEÇMİŞ OLSUN"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }