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();          }