asp.net LINQ LinqDataSource控件显示数据和DropdownList显示数据

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

posted @ 2016-12-18 15:12  清风白水  阅读(807)  评论(0编辑  收藏  举报