public static List <EntityDersler> DersListesi() { List <EntityDersler> degerler = new List <EntityDersler>(); SqlCommand komut = new SqlCommand("Select * From Tbl_Dersler", Baglanti.bgl); if (komut.Connection.State != ConnectionState.Open) { komut.Connection.Open(); } SqlDataReader dr = komut.ExecuteReader(); while (dr.Read()) { EntityDersler entityDersler = new EntityDersler { DersId = Convert.ToInt32(dr[0]), DersAd = dr[1].ToString(), DersMinKon = Convert.ToInt32(dr[2]), DersMaxKon = Convert.ToInt32(dr[3]) }; degerler.Add(entityDersler); } dr.Close(); return(degerler); }
//ders listeleme işlemi public static List <EntityDersler> DersListesi() { List <EntityDersler> degerler = new List <EntityDersler>(); SqlCommand komut1 = new SqlCommand("select * from Tbldersler", Baglanti.bgl); if (komut1.Connection.State != ConnectionState.Open) { komut1.Connection.Open();//eğer bağlantı kapalıysa bağlantıyı aç } SqlDataReader dr = komut1.ExecuteReader(); while (dr.Read()) { EntityDersler ent = new EntityDersler(); ent.Dersadi = dr["dersadi"].ToString(); ent.Dersid = Convert.ToInt32(dr["dersid"].ToString()); ent.Dersmaxkontenjan = Convert.ToInt32(dr["dersmaxkontenjan"].ToString()); ent.Dersminkontenjan = Convert.ToInt32(dr["dersminkontenjan"].ToString()); degerler.Add(ent); } dr.Close(); return(degerler); }