asp.net导出成EXCEL
以下是导出的方法:
public static void ToExcel(System.Web.UI.Control ctl)
{
//HttpContext.Current.Response.Charset ="GB2312";
HttpContext.Current.Response.Charset = "GBK";
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=memory.xls");
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GBK");
HttpContext.Current.Response.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword
ctl.Page.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
ctl.RenderControl(hw);
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
}
在其它方法中调用:ToExcel(gridview1);
相关文档:
ASP.NET处理程序和模块
ASP.NET HTTP 处理程序(Handler)是响应对 ASP.NET Web 应用程序的请求而运行的程序
如处理 *.aspx文件的ASP.NET处理程序 ......
Backup.aspx
protected void Button1_Click(object sender, EventArgs e)
{
string path = Server.MapPath("") + @"\Backup";
if (!Directory.Exists(path))
......
本文为中国ASP.NET开发网原创文章,转载必须注明出处。 名称: ASP.NET
地址:http://www.asp.net
介绍:微软.NET webform的老巢,资料和实例代码都非常难得。
名称: CSDN文档中心 loveswallow998 58213998
地址:http://dev.csdn.net/
介绍:中文的,资料还算丰富,可以作为国内首选。 ......
1.只要求保留N位不四舍5入
float f = 0.55555f;int i =(int)(f * 100);f = (float)(i*1.0)/100;
2.保留N位,四舍五入 .
decimal d= decimal.Round(decimal.Parse("0.55555"),2);
3.保留N位四舍五入
Math.Round(0.55555,2)
4,保留N位四舍五入
double dbdata = 0.5 ......
The MVC bits have finally arrived and I’ve spent a while digesting them. I’ve been waiting for the bits to be released to begin working on a side-project, so the first thing I did after downloading them last night was crank it up and start working on a new ASP.NET MVC Web Application p ......