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