private void BtnAra_Click(object sender, EventArgs e) { cn = new SqlConnection(@"Data Source=.;Initial Catalog=ToptanciVT;Integrated Security=true"); SqlCommand cmd = new SqlCommand("Select MusteriId,TC NO,Ad,Soyad,Telefon,Sifre,Eposta,Adres from " + "MUSTERILER where TC NO=@TCNO", cn); SqlParameter[] p = { new SqlParameter("@TCNO", txtTcNo.Text.Trim()) }; cmd.Parameters.AddRange(p); OpenConnection(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { frm.txtAd.Text = dr["Ad"].ToString(); frm.txtSoyad.Text = dr["Soyad"].ToString(); frm.txtTel.Text = dr["Telefon"].ToString(); frmMusteriEkle frm1 = (frmMusteriEkle)Application.OpenForms["Form1"]; } else { MessageBox.Show("Müşteri Bulunamadı!!"); } dr.Close(); CloseConnection(); }
private void btnMusListeleme_Click(object sender, EventArgs e) { frmMusteriEkle ekle = new frmMusteriEkle(); ekle.ShowDialog(); }