- private void Page_Load(object sender, System.EventArgs e)
- {
- SqlConnection con=new SqlConnection("server=.;database=pubs;uid=sa;pwd=;");
- con.Open();
- SqlDataAdapter sda=new SqlDataAdapter();
- sda.SelectCommand=new SqlCommand("select * from txtInsert",con);
- DataSet ds=new DataSet();
- sda.Fill(ds,"emp");
- this.DgSource.DataSource=ds.Tables["emp"];
- this.DgSource.DataBind();
- con.Close();
- }
- public void DataGridToExcel(DataGrid grdTemp,DataSet dsTemp)
- {
- grdTemp.AllowPaging=false; //设置不能分页
- grdTemp.DataSource=dsTemp; //重新绑定数据源
- grdTemp.DataBind();
- //常规导出方法
- System.IO.StringWriter SW = new System.IO.StringWriter();
- System.web.UI.htmlTextWriter HTW=new System.Web.UI.HtmlTextWriter(SW);
- grdTemp.RenderControl(HTW);
- //Page为要导出的对象,当前是Page,如果是DataGrid,DataList等都可以
- Response.Buffer=true;
- Response.Clear();
- Response.ClearContent();
- Response.ClearHeaders();
- Response.ContentType = "application/vnd.ms-excel";
- //Response.ContentType是输出流的 HTTP MIME 类型
- //Response.ContentType --- word文件
- //application/vnd.ms-excel --- excel文件
- //
- Response.Charset="utf-8";
- Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
- Response.AddHeader("Content-Disposition", "attachment;filename=aaa.xls");
- //attachment --- 作为附件下载
- //inline --- 在线打开
- //filename如过是中文,则可以用HttpUtility.UrlEncode(fileName,System.Text.Encoding.UTF8)
- //进行进行编码,以解决文件名乱码的问题
- Response.Write(SW.ToString());
- Response.Flush();
- Response.Close();
- }
- private void Button1_Click(object sender, System.EventArgs e)
- {
- SqlConnection con=new SqlConnection("server=.;database=pubs;uid=sa;pwd=;");
- con.Open();
- SqlDataAdapter sda=new SqlDataAdapter();
- sda.SelectCommand=new SqlCommand("select * from txtInsert",con);
- DataSet ds=new DataSet();
- sda.Fill(ds,"emp");
- this.DgSource.DataSource=ds.Tables["emp"];
- this.DataGridToExcel(this.DgSource,ds);
- con.Close();
- }
- //该片段来自于http://www.codesnippet.cn/detail/070620133890.html
来源: http://www.codesnippet.cn/detail/070620133890.html