public void SubeleriGetir(ComboBox liste) { liste.Items.Clear(); SqlConnection conn = new SqlConnection(cGenel.connStr); SqlCommand comm = new SqlCommand("Select * from sube ", conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr; try { dr = comm.ExecuteReader(); while (dr.Read()) { cSube s = new cSube(); s._Ad = Convert.ToString(dr["ad"]); s._subeID = Convert.ToInt32(dr["subeID"]); liste.Items.Add(s); } dr.Close(); conn.Close(); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } }
void ComboTasarim() { cPozisyon p = new cPozisyon(); p.PoziyonlariGetir(cbPozisyon); cSube s = new cSube(); s.SubeleriGetir(cbSubeAd); adres.sehirGetir(cbSehir); }
private void cbSubeAd_SelectedIndexChanged(object sender, EventArgs e) { cSube s = (cSube)cbSubeAd.SelectedItem; txtSubeID.Text = Convert.ToString(s.SubeID); }