如何将GridView 数据中指定的行输出到excel中

根据checkbox选中的记录,重新查询数据,然后绑定到gridview并下载.

遍历gridview中选中的行.然后组成datatable.输出到客户端流,保存类型为excel

我页想到上面的做法但是研究了好久都没实现，我把我的代码贴上去，请大家帮帮！
<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true"  CodeFile="Default3.aspx.cs" Inherits="Default3" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
     <title>无标题页</title>
     <script language="javascript" type="text/javascript">
    function selectAll(obj)
   {
      var theTable  = obj.parentElement.parentElement.parentElement;
       var i;
       var j = obj.parentElement.cellIndex;

        for(i=0;i<theTable.rows.length;i++)
        {
            var objCheckBox = theTable.rows[i].cells[j].firstChild;
           if(objCheckBox.checked!=null)objCheckBox.checked = obj.checked;
       }
   }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div> <asp:Button ID="Button2" runat="server" Text="EXCEL" OnClick="Button2_Click"/>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
          AllowSorting="True" OnDataBinding="GridView1_DataBinding" OnRowDataBound="GridView1_RowDataBound">
            <Columns>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:CheckBox ID="CheckBox1" runat="server" Checked="True" Text='<%#DataBinder.Eval(Container.DataItem,"Bid") %>' />
                   </ItemTemplate>
                    <HeaderTemplate>
                         <input id="CheckAll" type="checkbox" onclick="selectAll(this);" />本页全选
                   </HeaderTemplate>
               </asp:TemplateField>
                <asp:BoundField DataField="Bid" HeaderText="id" InsertVisible="False" ReadOnly="True"
                   SortExpression="id" />
                <asp:BoundField DataField="bname" HeaderText="bname" SortExpression="bname" />

           </Columns>
       </asp:GridView>
         

   <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False"
          AllowSorting="True"  Visible="False">
            <Columns>

                <asp:BoundField DataField="Bid" HeaderText="id" InsertVisible="False" ReadOnly="True"
                   SortExpression="id" />
                <asp:BoundField DataField="bname" HeaderText="bname" SortExpression="bname" />

           </Columns>
       </asp:GridView>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="ShowAllSelectedItem" />
        <asp:TextBox ID="TextBox1" runat="server" Width="200px"></asp:TextBox></div>
   </form>
</body>
</html>－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

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.Xml;
public partial class Default3 : System.Web.UI.Page
{
   /**//// <summary>
    /// 获取或设置选中项的集合
    /// </summary>
    protected ArrayList SelectedItems
    {
       get
        {
            return (ViewState["mySelectedItems"] != null) ? (ArrayList)ViewState["mySelectedItems"] : null;
        }
        set
        {
            ViewState["mySelectedItems"] = value;
       }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {            this.bind();
        }    }
    public void bind()
    {
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["conStr"]);
        strcon.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select * from btype order by bid ", strcon);
        DataSet ds = new DataSet();
        sda.Fill(ds, "products");
        GridView1.DataSource = ds.Tables["products"];
        GridView1.DataKeyNames = new string[] { "bid" };
        GridView1.DataBind();    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
        //gaoyang [10/21/2006] 经测试如果设置为 GetEncoding("GB2312"),导出的文件将会出现乱码。
        Response.ContentEncoding = System.Text.Encoding.UTF7;        //设置输出文件类型为excel文件。
        Response.ContentType = "application/ms-excel";
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        this.GridView1.RenderControl(oHtmlTextWriter);
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();    }
    public override void VerifyRenderingInServerForm(Control control)
    {
        // Confirms that an HtmlForm control is rendered for
    }
    protected void GridView1_DataBinding(object sender, EventArgs e)
    {
        //在每一次重新绑定之前，需要调用CollectSelected方法从当前页收集选中项的情况
       CollectSelected();
   }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
   {
        //这里的处理是为了回显之前选中的情况
        if (e.Row.RowIndex > -1 && this.SelectedItems!=null)
       {
           DataRowView row = e.Row.DataItem as DataRowView;
            CheckBox cb = e.Row.FindControl("CheckBox1") as CheckBox;
            if(this.SelectedItems.Contains(row["bid"].ToString()))
                cb.Checked = true;
            else
                cb.Checked = false;
       }
    }
    /**//// <summary>
    /// 从当前页收集选中项的情况
    /// </summary>
    protected void CollectSelected()
    {
       ArrayList selectedItems = null;
        if (this.SelectedItems == null)
            selectedItems = new ArrayList();
        else
            selectedItems = this.SelectedItems;        for (int i = 0; i < this.GridView1.Rows.Count; i++)
        {
            int id = Convert.ToInt32( this.GridView1.Rows[i].Cells[1].Text);
            CheckBox cb = this.GridView1.Rows[i].FindControl("CheckBox1") as CheckBox;
           if (selectedItems.Contains(id) && !cb.Checked)
                selectedItems.Remove(id);
            if (!selectedItems.Contains(id) && cb.Checked)
                selectedItems.Add(id);
       }
       this.SelectedItems = selectedItems;
       SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["conStr"]);
       strcon.Open();
       SqlDataAdapter sda = new SqlDataAdapter("select * from btype  ", strcon);
       DataSet ds = new DataSet();
       sda.Fill(ds, "btype");
       GridView2.DataSource = ds.Tables["btype"];
       GridView2.DataKeyNames = new string[] { "bid" };
       GridView2.DataBind();
    }   protected void Button1_Click(object sender, EventArgs e)
    {
        //最后，需要对选中项进行操作之前，不能忘了还要最后一次收集当前页的选中情况
       CollectSelected();        this.TextBox1.Text = string.Empty;

        foreach (object tmp in this.SelectedItems)
            this.TextBox1.Text += tmp.ToString() + ",";
    }

}

请问如何重新填充dataset 呢！！

或者:
//如果某行没有选中
this.g1.Rows[i].Visible = false; 就可以了

怎么才能实现指定行输出到EXECL中呢/
大家帮帮改改代码

设定某行visible以后,其他的不变.

只是在点了下载以后再设visible

请说的详细一些我在Button2_Click中设置了但是实现不了啊

实现不了啊我在Button2_Click中设置之后实现不了
请说的详细些

在Button2_Click中遍历gridview的items根据checkbox的情况设定visible,然后就是你那些代码

调试易

如何将GridView 数据中指定的行输出到excel中

解决方案 »