c# - 使用 Entity Framework 4 填充 DropDownList

Question

我需要一个非常简单的代码示例来使用 Entity Framework 4 填充 DropDownList。

目前我使用这段代码:

        using (TestHierarchyEntities context = new TestHierarchyEntities())
        {
            uxSelectNodeDestinationDisplayer.DataSource = context.CmsCategories.ToList();
            uxSelectNodeDestinationDisplayer.DataBind();
        }

但它不能正常工作...有什么想法吗？谢谢

Answer 1

像这样的东西应该可以工作:

using (TestHierarchyEntities context = new TestHierarchyEntities())
        {
                var category = (from c in context.context
                                select new { c.ID, c.Desc }).ToList();

                DropDownList1.DataValueField = "MID";
                DropDownList1.DataTextField = "MDesc";
                DropDownList1.DataSource = category;
                DropDownList1.DataBind();                
         }