通过SQl语句，把查询之后返回的结果打印成EXCEL表(一)

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.IO;

public partial class ExcelImport : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string columnsField,SqlCondition,FileName;

columnsField = Request.QueryString["Columns"].ToString();

SqlCondition = Request.QueryString["Conditional"].ToString();

FileName = Request.QueryString["FileName"].ToString();

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "server=.;database=two_company;uid=sa;pwd=sa";



//string SqlStr = "select " + selval.ToString() + " from tbl_Company where 1=1 " + ReturnTotalCondition().ToString() + " order by company";



string StrConn;

StrConn = "select " + columnsField.ToString() + " from tbl_company where 1=1 " + SqlCondition.ToString()+"order by company";

SqlDataAdapter da = new SqlDataAdapter(StrConn, conn);



DataSet ds = new DataSet();



da.Fill(ds, "table1");



DataTable dt = ds.Tables["table1"];

GridView1.DataSource = dt;

GridView1.DataBind();



Response.Clear();

Response.Buffer = true;

Response.Charset = "GB2312"; //设置了类型为中文防止乱码的出现

Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName.Trim().ToString()+ ".xls"); //定义输出文件和文件名

Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文

Response.ContentType = "application/ms-excel";//设置输出文件类型为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.GridView1.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

}

public override void VerifyRenderingInServerForm(Control control)

{

// Confirms that an HtmlForm control is rendered for

}

}