• λ我爱Aspx >> Asp.Net >> ASP.NET2.0中Gridview中数据操作技巧

    • ASP.NET2.0中Gridview中数据操作技巧

  • :未知  Դ:非寒日志  :2007-4-21 0:48:34  ؼ:.net,asp.net,asp.net2.0,asp,数据

  • Asp.net 2.0中新增的gridview控件，是十分强大的数据展示控件，在前面的系列文章里，分别展示了其中很多的基本用法和技巧（详见天极＜＜ASP.NET 2.0中Gridview控件高级技巧＞＞、＜＜ASP.NET2.0利用Gridview实现主从关系＞＞)。在本文中，将继续探讨有关的技巧。

    一、Gridview中的内容导出到Excel

    在日常工作中，经常要将gridview中的内容导出到excel报表中去，在asp.net 2.0中，同样可以很方便地实现将整个gridview中的内容导出到excel报表中去，下面介绍其具体做法：

    首先，建立基本的页面default.aspx

    ＜form id="form1" runat="server"＞＜div＞＜asp:GridView ID="GridView1" runat="server"＞＜/asp:GridView＞＜/div＞＜br/＞＜asp:Button ID="BtnExport" runat="server" OnClick="BtnExport_Click"Text="Export to Excel" /＞＜/form＞

    在default.aspx.cs中，写入如下代码：

    protected void Page_Load(object sender, EventArgs e){ if (!Page.IsPostBack) { BindData(); }}private void BindData(){ string query = "Select * FROM customers"; SqlConnection myConnection = new SqlConnection(ConnectionString); SqlDataAdapter ad = new SqlDataAdapter(query, myConnection); DataSet ds = new DataSet(); ad.Fill(ds, "customers"); GridView1.DataSource = ds; GridView1.DataBind();}public override void VerifyRenderingInServerForm(Control control){ // Confirms that an HtmlForm control is rendered for}protected void Button1_Click(object sender, EventArgs e){ Response.Clear(); Response.AddHeader("content-disposition","attachment;filename=FileName.xls"); Response.Charset = "gb2312"; Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite =new HtmlTextWriter(stringWrite); GridView1.AllowPaging = false; BindData(); GridView1.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); GridView1.AllowPaging = true; BindData();}protected void paging(object sender,GridViewPageEventArgs e){ GridView1.PageIndex = e.NewPageIndex; BindData();}
    Ҷƪл˵?
    第一页上一页123456下一页尾页
  • һƪ疯狂的CN域名开始免费送拉!
    һƪASP.NET 2.0中使用multiview控件