使用Linq导出数据到execl

    /// <summary>
    /// 绑定数据
    /// </summary>
    private void BindData()
    {

         IQueryable<TableName> query = SelectData();
        this.anpList.RecordCount = query.Count();
        int curr_page_index = this.anpList.CurrentPageIndex;
        if (Request.QueryString["page"] != null && StringHandler.IsNumeric(Request.QueryString["page"].ToString()))
        {
            curr_page_index = Convert.ToInt32(Request.QueryString["page"]);
        }
        this.rptList.DataSource = query.Skip((curr_page_index - 1) * this.anpList.PageSize).Take(this.anpList.PageSize);
        this.rptList.DataBind();

     }

 

    /// <summary>
    /// 查询数据
    /// </summary>
    private IQueryable<TableName> SelectData()
    {
        IQueryable<TableName> query = from t in db.TableName
                                                              select t;
        return query;
    }

 

 /// <summary>    

/// 导出到execl   

/// </summary>    

protected void btnExport_Click(object sender, EventArgs e)    

{       

                 IQueryable<TableName> query = SelectData();//查询数据源

string file_name = string.Format("{0:yyyyMMddHHmmss}", DateTime.Now) + "";     // 导出的文件名日期   

HttpResponse resp;        

resp = Page.Response;        

resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); //设置编码

      resp.ContentType = "application/application/vnd.ms-excel";//内容类型

      resp.AppendHeader("Content-Disposition", "attachment;filename=" + file_name + ".xls");//文件名称和格式

      string colHeaders = "", itemes= "";

      colHeaders += "ColumnA\t";  

colHeaders += "ColumnB\t";        

colHeaders += "ColumnC\n";        

                                     resp.Write(colHeaders);        

                                    foreach (var item in query)        

{     

 itemes += item.ColumnA_Values + "\t"  

+ item.ColumnB_Values + "\t"                    

+ item.ColumnC_Values + "\n";     

}        

resp.Write(itemes);        

resp.End();    

}

转载于:https://www.cnblogs.com/professional-NET/p/4678360.html