private void frmAracListe_Load(object sender, EventArgs e) { cArac a = new cArac(); a.AraclariGetir(lvAraclar); a.ModelleriGetir(cbAracModeli); }
public void ModelleriGetir(ComboBox liste) { SqlConnection conn = new SqlConnection(cGenel.connStr); SqlCommand comm = new SqlCommand("Select ad from otobusModel where durum=1", conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr; try { dr = comm.ExecuteReader(); while (dr.Read()) { cArac a = new cArac(); a._modelAd = Convert.ToString(dr["ad"]); liste.Items.Add(a); } dr.Close(); } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } }
private void btnAracAra_Click(object sender, EventArgs e) { cArac a = new cArac(); a.AraclarıGetirByTarih(txtTarih.Text, lvAraclar); }
private void cbAracModeli_SelectedIndexChanged(object sender, EventArgs e) { cArac a = new cArac(); a.AraclarıGetirByModel(cbAracModeli, lvAraclar); }