private void BayiGuncelle_Load(object sender, EventArgs e) { bayi = dealerOperations.BayiGetir(bayiID.ToString()); txtBayiIDGuncelle.Text = bayi.BayiId; txtBayiAdGuncelle.Text = bayi.BayiAd; txtBayiAdresGuncelle.Text = bayi.BayiAdres; txtBayiEpostaGuncelle.Text = bayi.BayiEposta; txtBayiTelGuncelle.Text = bayi.BayiTel; }
public void cmbBxSiparisiVerenBayiItemsAdd(ComboBox cmbBxSiparisiVerenBayi, List <Bayi> bayiList) { sqlConnection.Connection().Open(); SqlCommand urungetir = new SqlCommand("select * from tblBayiler", sqlConnection.Connection()); SqlDataReader data = urungetir.ExecuteReader(); while (data.Read()) { Bayi bayi = new Bayi(); bayi.BayiId = data[0].ToString(); bayi.BayiAd = data[1].ToString(); bayi.BayiEposta = data[2].ToString(); bayi.BayiAdres = data[3].ToString(); bayi.BayiTel = data[4].ToString(); bayiList.Add(bayi); cmbBxSiparisiVerenBayi.Items.Add(bayi.BayiAd); } sqlConnection.Connection().Close(); }
public void bayileriGetir(DataGridView datagrid) { List <Bayi> bayilerList = new List <Bayi>(); sqlConnection.Connection().Open(); SqlCommand urungetir = new SqlCommand("select * from tblBayiler", sqlConnection.Connection()); SqlDataReader data = urungetir.ExecuteReader(); while (data.Read()) { Bayi bayi = new Bayi(); bayi.BayiId = data[0].ToString(); bayi.BayiAd = data[1].ToString(); bayi.BayiEposta = data[2].ToString(); bayi.BayiAdres = data[3].ToString(); bayi.BayiTel = data[4].ToString(); bayilerList.Add(bayi); } sqlConnection.Connection().Close(); datagrid.DataSource = bayilerList; }
public Bayi BayiGetir(String Id) { Bayi seciliBayi = new Bayi(); sqlConnection.Connection().Open(); SqlCommand seciliBayigetir = new SqlCommand("select * from tblBayiler where BayiID = @p1", sqlConnection.Connection()); seciliBayigetir.Parameters.AddWithValue("@p1", Id); SqlDataReader data = seciliBayigetir.ExecuteReader(); while (data.Read()) { seciliBayi.BayiId = data[0].ToString(); seciliBayi.BayiAd = data[1].ToString(); seciliBayi.BayiEposta = data[2].ToString(); seciliBayi.BayiAdres = data[3].ToString(); seciliBayi.BayiTel = data[4].ToString(); } sqlConnection.Connection().Close(); return(seciliBayi); }