protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
...{
string strMaxID = this.GridView1.DataKeys[e.NewEditIndex].Values[0].ToString();
string strMinID = this.GridView1.DataKeys[e.NewEditIndex].Values[1].ToString();
string strCount = this.GridView1.Rows[e.NewEditIndex].Cells[2].Text;
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=ContractCode.xls");
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!!
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/ms-Excel";//设置输出文件类型为txt文件。
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
//System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
//this.GridView1.RenderControl(oHtmlTextWriter);

oStringWriter.Write("编号:"+strMinID + "至" + strMaxID+",共"+strCount+"份。");
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
}
不错的方法
本文介绍了一种使用ASP.NET中GridView控件进行数据编辑时,将特定数据格式化并导出为Excel文件的方法。该方法能够从GridView中获取数据,并通过Response对象将其输出为Excel文件,便于用户下载。
192

被折叠的 条评论
为什么被折叠?



