asp.net中GridView导出数据

最新推荐文章于 2019-01-18 11:42:51 发布

cuibinmo3519

最新推荐文章于 2019-01-18 11:42:51 发布

阅读量178

点赞数

文章标签： c# javascript ViewUI

///
        /// 重写VerifyRenderingInServerForm方法(不重写可能会报错)
        ///
        ///
        public override void VerifyRenderingInServerForm(Control control)
        {
        }
        ///
        /// 导出事件，调用导出方法
        ///
        ///
        ///
        protected void btnExport_Click(object sender, EventArgs e)
        {
            Export("application/excel",fileName);
        }

　　　///模式化特殊元素将服务控件改为Literal使其可以输出

public void PrepareGridViewForExport(Control gv）

      {
            LinkButton lb = new LinkButton();
            Literal l = new Literal();
            string name = String.Empty;

for (int i = 0; i < gv.Controls.Count; i++)
{

                if (gv.Controls[i].GetType() == typeof(LinkButton))
                {
                    l.Text = (gv.Controls[i] as LinkButton).Text;
                    gv.Controls.Remove(gv.Controls[i]);
                    gv.Controls.AddAt(i, l);
                }
                else if (gv.Controls[i].GetType() == typeof(DropDownList))
                {
                    l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text;
                    gv.Controls.Remove(gv.Controls[i]);
                    gv.Controls.AddAt(i, l);
                }
                else if (gv.Controls[i].GetType() == typeof(CheckBox))
                {
                    l.Text = (gv.Controls[i] as CheckBox).Checked ? "True" : "False";
                    gv.Controls.Remove(gv.Controls[i]);
                    gv.Controls.AddAt(i, l);
                }
                else if (gv.Controls[i].GetType() == typeof(ImageButton))
                {
                    l.Text = "图片";
                    gv.Controls.Remove(gv.Controls[i]);
                    gv.Controls.AddAt(i, l);
                }
                if (gv.Controls[i].HasControls())
                {
                    PrepareGridViewForExport(gv.Controls[i]);
                }
            }
        }
　　

　　　　///导出方法

　　　　///FileType导出类型 application/excel导出excel文件word导出为word文档

　　　　///FileName 文件名称

public void Export(string FileType, string FileName)
{

string style. = @"

PrepareGridViewForExport(GridView1);//将模版列显示出来

Response.Clear();

Response.Charset = "GB2312 ";

Response.ContentEncoding = Encoding.GetEncoding("GB2312");

Response.Buffer = true;

Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

Response.ContentType = FileType;

this.EnableViewState = false;

this.GridView1.AllowPaging = false;

CultureInfo myCItrad = new CultureInfo("ZH-CN", true);

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

this.GridView1.RenderControl(htw);

Response.Write(style);

Response.Write(sw.ToString());

//Response.Write(dt.ToString());

Response.End();

}