看见比较好的速度导出excel的方法（sql原创）

GridView gvOrders = new GridView();
            Response.Clear();
            Response.ContentType = "application/vnd.ms-excel";
            Response.Charset = "GB2312";
            Response.AppendHeader("Content-Disposition", "attachment;filename=ZZsoftCityplanUser.xls");
            Response.ContentEncoding = Encoding.GetEncoding("GB2312");  //设置输出流为简体中文
            this.EnableViewState = false;
            Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");
            StringWriter sw =new  StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(sw);
            gvOrders.AllowPaging = false;
            gvOrders.AllowSorting = false;
            //string mysql = "select * from regusermanage a where (delFlag ='0' or delFlag is null) order by userarea";
            string mysql = "select '地区'=a.userarea,'客户名称'=a.Jobname,'联系人'=a.username,'联系电话'=replace(a.phone,' ',''),'Email'=a.email,'详细地址'=a.address,'软件名称'=c.softname+c.softver,'软件类型'=b.softtype,'套/节点'=replace(b.softcount,' ',''),'软件价格'=replace(b.softprice,' ',''),'锁号'=replace(b.locknum,' ',''),'办理人'=b.transactuser,'办理时间'=convert(varchar(10),b.transactdate,120),'备注'=a.remark from regusermanage a left join usersoftinfo b on b.userid=a.sid  left join zzsoftinfo c on c.sid=b.softid where (a.delFlag ='0' or a.delFlag is null)  order by a.userarea";
            DataTable dt = SqlHelp.GetDataTable(mysql);
            gvOrders.DataSource = dt;
            gvOrders.DataBind();
            gvOrders.RenderControl(hw);
            Response.Write(sw.ToString());
            Response.End();