asp.netLINQLinqDataSource控件显示数据和DropdownList显示数据

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        LinqDBDataContext lqDB = new LinqDBDataContext(ConfigurationManager.ConnectionStrings["db2016ConnectionString"].ConnectionString.ToString());
        var result = from r in lqDB.news
                     where r.id > 0
                     select new
                     {
                         Content = r.content,
                     };
        DropDownList1.DataTextField = "content";
        DropDownList1.DataSource = result;
        DropDownList1.DataBind();
    }
}