private void btngiris_Click(object sender, EventArgs e) { SqlCommand komut = new SqlCommand("Select * from tbl_Hastalar where HastaTC=@p1 and HastaSifre=@p2", ss.baglanti()); komut.Parameters.AddWithValue("@p1", mskTC.Text); komut.Parameters.AddWithValue("@p2", TxtSifre.Text); SqlDataReader dr = komut.ExecuteReader(); if (dr.Read()) { FrmHastaDetay fr = new FrmHastaDetay(); fr.tc = mskTC.Text; fr.Show(); this.Hide(); } else { MessageBox.Show("Hatalı Şifre Tekrar Deneyiniz."); } ss.baglanti().Close(); }
private void btnHastaGiris_Click(object sender, EventArgs e) { SqlCommand komut = new SqlCommand(" select * from Table_Hasta where HastaTc=@p1 and HastaSifre=@p2", bgl.baglanti()); komut.Parameters.AddWithValue("@p1", mskdHastaTc.Text); komut.Parameters.AddWithValue("@p2", txtHastaSifre.Text); SqlDataReader dr = komut.ExecuteReader(); if (dr.Read()) { FrmHastaDetay frm = new FrmHastaDetay(); frm.tc = mskdHastaTc.Text; frm.Show(); this.Hide(); } else { MessageBox.Show("Hatali TC ya da hatalı şifre", "Bilgi", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); } bgl.baglanti().Close(); }