请参阅下面的修订代码

上述就是C#学习教程：如何将LINQ数据绑定到下拉列表分享的全部内容，如果对大家有所用处且需要了解更多关于C#学习教程，希望大家多多关注—计算机技术网(www.ctvol.com)!

 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(); } } 

 protected void BindMarketCodes() { using(var dc = new LINQOmniDataContext()) { dd2.DataSource = from p in db.lkpMarketCodes orderby 0 select new {p.marketName, p.marketCodeID }; dd2.DataTextField = "marketName"; dd2.DataValueField = "marketCodeID"; dd2.DataBind(); } } // no need to use ToList() // no need to use a temp list; // using an anonymous type will limit the columns in your resulting SQL select // make sure to wrap in a using block; 

 DropDownList ddl_RouteLocation = (DropDownList)e.Row.FindControl("ddl_RouteLocation"); ddl_RouteLocation.DataSource = dtLocation;--(dtlocation i have return method of linq in dtlocation) ddl_RouteLocation.DataTextField =dtLocation.Rows[0]"LocationName"].ToString(); ddl_RouteLocation.DataValueField =dtLocation.Rows[0]["LocationId"].ToString(); ddl_RouteLocation.DataBind(); ddl_RouteLocation.Items.Insert(0, new ListItem("--Select--", "0"));