新人提問 c# 如何生成excel.最好有離子.謝謝 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 string strSQL="select top 10 * from Customers"; SqlDataAdapter da=new SqlDataAdapter(strSQL,cn); DataSet ds=new DataSet(); da.Fill(ds,"db1"); DataGrid1.DataSource=ds.Tables["db1"]; DataGrid1.DataBind(); Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-disposition","attachment:filename=FileName.xls"); Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType="application/ms-excel"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad=new System.Globalization.CultureInfo("ZH-CN",true); System.IO.StringWriter oStringWriter=new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter=new System.Web.UI.HtmlTextWriter(oStringWriter); this.DataGrid1.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End();就这么简单,数据库你自己随便搞一个试一下。 Runtime Error 我的应用发布到服务器后,几分钟后就登陆不了 实现ping以及远程连接问题(ly302请进来) 如何从一个图标的句柄获得这个图标的具体路径 用c#写XML文件问题 C#里调用JS 有个对话框没有了 关于服务端可以接受多个客户端的连接,进行互相通信的问题. c#连接部署在linux下的oracle问题 请大家帮我看一下 谢谢 c#自定义事件一直报错,求指教 单引号问题 C#的深拷贝和浅拷贝
SqlDataAdapter da=new SqlDataAdapter(strSQL,cn);
DataSet ds=new DataSet();
da.Fill(ds,"db1");
DataGrid1.DataSource=ds.Tables["db1"];
DataGrid1.DataBind();
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-disposition","attachment:filename=FileName.xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType="application/ms-excel";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad=new System.Globalization.CultureInfo("ZH-CN",true);
System.IO.StringWriter oStringWriter=new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter=new System.Web.UI.HtmlTextWriter(oStringWriter);
this.DataGrid1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();就这么简单,数据库你自己随便搞一个试一下。