C# 下載excel（使用GridView）

string dbname = Srvtools.CliUtils.fLoginDB.ToString();                 string strconn = Connection.Class1.getconnect(dbname);                 SqlConnection conn = new SqlConnection(strconn);                 conn.Open();                 string cmdstr = "";                 cmdstr = "PFAWRQ001_test";                 SqlCommand cmd = new SqlCommand(cmdstr, conn);                 cmd.CommandType = CommandType.StoredProcedure;                 cmd.CommandTimeout = 1800;                 cmd.Parameters.Add("@comp", SqlDbType.NVarChar, 4);                 cmd.Parameters["@comp"].Value = comp;                 cmd.Parameters.Add("@plantfrom", SqlDbType.NVarChar, 4);                 cmd.Parameters["@plantfrom"].Value = plantF;                 cmd.Parameters.Add("@plantto", SqlDbType.NVarChar, 4);                 cmd.Parameters["@plantto"].Value = plantT;                 cmd.Parameters.Add("@faF", SqlDbType.NVarChar, 11);                 cmd.Parameters["@faF"].Value = faF;                 cmd.Parameters.Add("@faT", SqlDbType.NVarChar, 11);                 cmd.Parameters["@faT"].Value = faT;                 cmd.Parameters.Add("@empF", SqlDbType.NVarChar, 12);                 cmd.Parameters["@empF"].Value = empF;                 cmd.Parameters.Add("@empT", SqlDbType.NVarChar, 12);                 cmd.Parameters["@empT"].Value = empT;                 cmd.Parameters.Add("@dptF", SqlDbType.NVarChar, 15);                 cmd.Parameters["@dptF"].Value = dptF;                 cmd.Parameters.Add("@dptT", SqlDbType.NVarChar, 15);                 cmd.Parameters["@dptT"].Value = dptT;

                cmd.Parameters.Add("@vchF", SqlDbType.NVarChar, 20);                 cmd.Parameters["@vchF"].Value = vchF;                 cmd.Parameters.Add("@vchT", SqlDbType.NVarChar, 20);                 cmd.Parameters["@vchT"].Value = vchT;

                cmd.Parameters.Add("@accF", SqlDbType.NVarChar, 8);                 cmd.Parameters["@accF"].Value = accF;                 cmd.Parameters.Add("@accT", SqlDbType.NVarChar, 8);                 cmd.Parameters["@accT"].Value = accT;

                cmd.Parameters.Add("@accepF", SqlDbType.NVarChar, 10);                 cmd.Parameters["@accepF"].Value = accepF;                 cmd.Parameters.Add("@accepT", SqlDbType.NVarChar, 10);                 cmd.Parameters["@accepT"].Value = accepT;

                cmd.Parameters.Add("@effF", SqlDbType.NVarChar, 10);                 cmd.Parameters["@effF"].Value = effF;                 cmd.Parameters.Add("@effT", SqlDbType.NVarChar, 10);                 cmd.Parameters["@effT"].Value = effT;

                cmd.Parameters.Add("@create_D_F", SqlDbType.NVarChar, 10);                 cmd.Parameters["@create_D_F"].Value = create_D_F;                 cmd.Parameters.Add("@create_D_T", SqlDbType.NVarChar, 10);                 cmd.Parameters["@create_D_T"].Value = create_D_T;

                cmd.Parameters.Add("@depr", SqlDbType.NVarChar, 1);                 cmd.Parameters["@depr"].Value = depr;                 cmd.Parameters.Add("@net", SqlDbType.NVarChar, 1);                 cmd.Parameters["@net"].Value = net;                 cmd.Parameters.Add("@work", SqlDbType.NVarChar, 1);                 cmd.Parameters["@work"].Value = work;                 SqlDataAdapter dp = new SqlDataAdapter(cmd);                 DataSet ds = new DataSet();                 dp.Fill(ds);                 //GridView1.DataSource = ds;                 //GridView1.DataBind();

                ////Response.Clear();                 //Response.Charset = "GB2312";                 ////Response.Charset = "";

                //Response.AddHeader("Content-Disposition", "attachment;filename=FASQ001.xls");                 //Response.ContentEncoding = System.Text.Encoding.UTF8;                 ////HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;                 //Response.ContentType = "application/vnd.ms-excel";                 //EnableViewState = false;                 //System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);                 //StringWriter tw = new StringWriter(myCItrad);//实现一个用于将信息写入字符串的对象tw                 //HtmlTextWriter hw = new HtmlTextWriter(tw);//将标记字符和文本写入到ASP.NET服务器控件输出流                 //GridView1.RenderControl(hw);//将服务器控件的内容输出到所提供的HtmlTextWriter对象中

                //Response.Write(tw.ToString());                 //Response.End();