public void kul_GuncVeriCek(int no, iTalk_TextBox_Small ad, iTalk_TextBox_Small sad, DateTimePicker dt
, iTalk_TextBox_Small tc, iTalk_ComboBox kan_g, iTalk_TextBox_Small tel, iTalk_TextBox_Small kul_ad,
iTalk_TextBox_Small kul_sifre, DataGridView dg, Ambiance_Button_1 btduzenle)
{
try
{
SqlConnection b = new SqlConnection();
b.ConnectionString = bag_cumlem;
b.Open();
string sql = "Select * from kullanicilar where kul_no='" + no + "'";
SqlCommand k = new SqlCommand(sql, b);
SqlDataReader dr = k.ExecuteReader();
while (dr.Read())
{
ad.Text = dr["adi"].ToString();
sad.Text = dr["soyadi"].ToString();
dt.Text = dr["dog_tar"].ToString();
tc.Text = dr["tc_no"].ToString();
kan_g.Text = dr["kan_grub"].ToString();
tel.Text = dr["tel_no"].ToString();
kul_ad.Text = dr["kul_adi"].ToString();
kul_sifre.Text = dr["kul_sifre"].ToString();
btduzenle.Visible = true;
}
}
catch
{
MessageBox.Show("Kullanıcı Getirilirken bir hata oluştu tekrar deneyiniz");
}
}
public void kullanici_guncelle(int id, string adi, string soyadi, string dt, string tc, string kan_grubu, string tel_no,
string kul_adi, string sifre, Ambiance_Button_1 btngunc, DataGridView dgview)
{
try
{
string sql = "Exec spKulGuncelle '" + id + "','" + adi + "' ,'" + soyadi + "' ,'" + dt.ToString() + "','" + tc + "','" + kan_grubu + "','" + tel_no + "','" + kul_adi + "','" + sifre + "'";
SqlConnection b = new SqlConnection();
b.ConnectionString = bag_cumlem;
b.Open();
SqlCommand k = new SqlCommand(sql, b);
k.ExecuteNonQuery();
MessageBox.Show("Kayıt Başarıyla Güncellendi");
btngunc.Visible = false;
}
catch
{
MessageBox.Show("Kayıt Güncellenirken Hata Oluştu");
}
}
