combobox iteme group by problem ???

Question

GrpCB.DisplayMember = Groupe ; GrpCB.ValueMember = num_ligne ; using (DBEntities db = new DBEntities()) { GrpCB.DataSource = db.Grilles.GroupBy(p => p.groupe).ToList(); } this my code to add items to cb but i want group by field groupe i have an errror of grouping is there some correction ?

dzconception · Answer

thank's it solve the groupby problem but i have where problem? sow i select categorie from grille where groupe like groupe : GrpCB.DataSource = db.Grilles.GroupBy(P => P.groupe).Select(g => new { Groupe = g.Key }).ToList(); CatCB.DataSource = db.Grilles.GroupBy(P => P.categorie).Select(g => new { Categorie = g.Key }).ToList(); i want add items to CatCB (categorie combobox) from grille table where groupe = GRPCB (groupe combobox) thnk you again

vipin kv · Answer

using (DBEntities db = new DBEntities()) { GrpCB.DataSource = db.Grilles.GroupBy(p => p.groupe) .Select(g => new { Groups = g.Key }).ToList(); } GrpCB.DisplayMember = Groups;

combobox iteme group by problem ,???