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();
}
