如何绑定LINQ数据DROPDOWNLIST [英] How to bind LINQ data to dropdownlist

问题描述

最后两行的这个code无法正常工作 - 结果是从LINQ查询回来。我只是不知道如何成功绑定指定列的结果将DropDownList的文本字段和valuefield：

 保护无效BindMarket codeS（）
    {
        名单＆LT; lkpMarket code取代; M codesList =新的名单，其中，lkpMarket code取代;（）;

        LINQOmniDataContext DB =新LINQOmniDataContext（）;

        变种M codeS从P =在db.lkpMarket codeS
                        排序依据0
                        选择磷;

        M codesList = M codes.ToList＆LT; lkpMarket code取代;（）;

        //结合国家code droplist
        dd2.DataSource = M codesList;
        dd2.DataTextField = M codesList [0] .marketName;
        dd2.DataValueField = M codesList [0]。市场codeID.ToString（）;

    }
 

解决方案

请参阅下面

修订code

 保护无效BindMarket codeS（）
{
    使用（VAR的DataContext =新LINQOmniDataContext（））{
        //结合国家code droplist
        dd2.DataSource =从p在dataContext.lkpMarket codeS
            排序依据p.marketName
            选择新{p.market codeID，p.marketName};
        dd2.DataTextField =marketName;
        dd2.DataValueField =市场codeID;
        dd2.DataBind（）;
    }
}
 

The last two lines of this code do not work correctly -- the results are coming back from the LINQ query. I'm just not sure how to successfully bind the indicated columns in the results to the textfield and valuefield of the dropdownlist:

    protected void BindMarketCodes()
    {
        List<lkpMarketCode> mcodesList = new List<lkpMarketCode>();

        LINQOmniDataContext db = new LINQOmniDataContext();

        var mcodes = from p in db.lkpMarketCodes 
                        orderby 0
                        select p;

        mcodesList = mcodes.ToList<lkpMarketCode>();

        //bind to Country COde droplist
        dd2.DataSource = mcodesList;
        dd2.DataTextField = mcodesList[0].marketName;
        dd2.DataValueField = mcodesList[0].marketCodeID.ToString();

    }

解决方案

See revised code below

protected void BindMarketCodes()
{    
    using (var dataContext = new LINQOmniDataContext()) {
        //bind to Country COde droplist
        dd2.DataSource = from p in dataContext.lkpMarketCodes 
            orderby p.marketName
            select new {p.marketCodeID, p.marketName};
        dd2.DataTextField = "marketName";
        dd2.DataValueField = "marketCodeID";
        dd2.DataBind();
    }
}

这篇关于如何绑定LINQ数据DROPDOWNLIST的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！