public static List <Bolum> BolumDoldur(int yeni) { SqlConnection conn = DbConncection.GetSqlConnection(); var cmd = new SqlCommand(); cmd.CommandText = "SELECT BolumId,Bolum FROM Ahmet_Bolum WHERE Ahmet_Bolum.FakulteId=@FakulteId"; cmd.Parameters.AddWithValue("@FakulteId", yeni); cmd.Connection = conn; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <Bolum> bolumler = new List <Bolum>(); while (reader.Read()) { Bolum bolum = new Bolum(); { bolum.BolumId = reader.GetInt32(0); bolum.Bolumm = reader.GetString(1); bolumler.Add(bolum); } } conn.Close(); return(bolumler); }
private void BolumDoldur()//2 tane { SqlConnection conn = DbConncection.GetSqlConnection(); Fakulte secilen = (Fakulte)cmbFakulte.SelectedItem; var cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM Ahmet_Bolum WHERE FakulteId=@fakulteId "; cmd.Parameters.AddWithValue("@fakulteId", secilen.FakulteId); cmd.Connection = conn; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Bolum bolum = new Bolum(); { bolum.BolumId = reader.GetInt32(0); bolum.Bolumm = reader.GetString(1); } cmbBolum.Items.Add(bolum); } conn.Close(); }
private void cmbFakulte_SelectedIndexChanged(object sender, EventArgs e) { //BolumDoldur(); secilen = (Fakulte)cmbFakulte.SelectedItem; List <Bolum> bolumler = Bolum.BolumDoldur(secilen.FakulteId); cmbBolum.DisplayMember = "Bolum"; cmbBolum.ValueMember = "BolumId"; cmbBolum.DataSource = bolumler; }
private void DersleriGetir() { int bolumid = Bolum.BolumIdBul(); int sinif = Bolum.SinifiBul(); SqlConnection conn = DbConncection.GetSqlConnection(); var cmd = new SqlCommand(); cmd.CommandText = "SELECT DerslerId,DersAdi FROM Ahmet_Dersler WHERE Ahmet_Dersler.BolumId=@BolumId and Ahmet_Dersler.Sinif=@Sinif "; cmd.Parameters.AddWithValue("@BolumId", bolumid); cmd.Parameters.AddWithValue("@Sinif", sinif); cmd.Connection = conn; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Dersler dersler = new Dersler(); { dersler.DerslerId = reader.GetInt32(0); dersler.DersAdi = reader.GetString(1); } int a = 0; foreach (Dersler item in lsbSecilenDersler.Items) { if (dersler.DerslerId == item.DerslerId) { a = 1; } } if (a != 1) { lsbTumDersler.Items.Add(dersler); } } conn.Close(); }