asp.net 从datagrid导出到world_datagrideview 导出world-CSDN博客

本文链接：https://blog.csdn.net/educast/article/details/2894987

private void dgdiaryListBind()
{
   string strDate1=Date1.SelectDate.ToString();
    string strDate2=Date2.SelectDate.ToString();
    DataTable diCart=(new DiaryBF()).GetDiaryInf(strDate1,strDate2);
    this.dgdiaryList.CurrentPageIndex=0;
    this.dgdiaryList.DataSource=diCart;//指定数据源
    this.dgdiaryList.DataBind();//绑定数据源
   }

   private void Button1_Click(object sender, System.EventArgs e)
   {
    DataTable dt=(DataTable)this.dgdiaryList.DataSource;
    string strExcelName="";
    dgdiaryList.AllowPaging=false;
    dgdiaryList.AllowSorting=false;
    dgdiaryListBind();
    dgExcel2.AllowPaging=false;
    dgExcel2.AllowSorting=false;
    dgExcel2.DataSource=dgdiaryList.DataSource;
    dgExcel2.DataBind();
    dgExcel2.Visible=true;
    //ExportExcel(dgAssetList,strExcelName);//直接导出到Excel表格
    ExportExcel(dgExcel2,strExcelName);//直接导出到Excel表格
    dgExcel2.Visible=false;
   }

   private void ExportExcel(DataGrid dg,string strExcelName)
   {
    dg.AllowPaging=false;
    DataGridToExcelDefault(dg,strExcelName);
    HttpContext.Current.Response.End();
   }
   public static void DataGridToExcelDefault(DataGrid dg,string strExcelName)
   {
    if(strExcelName=="")//如果Excel表格未名称，则默认Excel
    {
     strExcelName="World";
    }
    HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename="+strExcelName+".doc");
    HttpContext.Current.Response.ContentType = "application/vnd.ms-wold";
    HttpContext.Current.Response.Charset = "";
    HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.UTF7;//OZR .Default;
    System.IO.StringWriter tw = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
    dg.RenderControl(hw);
    HttpContext.Current.Response.Write(tw.ToString());
    //HttpContext.Current.Response.End();
   }