求解使用VS自带控件将数据库内表显示出来然后选中多行导出为excel

[redfalson]

求解使用VS自带控件将数据库内表显示出来然后选中多行导出为excel
由于对代码不太熟悉，想最好大部分用控件，由于数据较多需要通过控件分页，现在我的方法分页就失效了

[redfalson]

跳一下

[redfalson]

在跳一下

[tanlianguang]

自己写的分页试试看！

[redfalson]

就是不太会，有人能帮下么

[redfalson]

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
public partial class App_Admin_TEST4 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
List<string> listID=new List <string>();
foreach (GridViewRow row in this.GridView1.Rows)
{
CheckBox CheckRow = (CheckBox)row.FindControl("CheckBox1");
if (CheckRow.Checked)
{

listID.Add(this.GridView1.DataKeys[row.RowIndex].Values["id"].ToString());


}





<%@ Page Language="C#" MasterPageFile="~/App_Admin/WebDateOut.master" AutoEventWireup="true" CodeFile="TEST4.aspx.cs" Inherits="App_Admin_TEST4" Title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<p>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="SqlDataSource1"
ShowFooter="True" PageSize="3">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="mingcheng" HeaderText="mingcheng"
SortExpression="mingcheng" />
<asp:BoundField DataField="address" HeaderText="address"
SortExpression="address" />
<asp:BoundField DataField="selecta" HeaderText="selecta"
SortExpression="selecta" />
<asp:TemplateField>
<FooterTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" onclick="CheckAll(this)" title="全选/全不选" />
</FooterTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MuserConnectionString2 %>"
SelectCommand="SELECT * FROM [test]"></asp:SqlDataSource>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
</p>
<p>
 </p>
<p>
</p>
<script language="javascript" type="text/javascript">
//实现GridView的CheckBox全部选择和全部取消
function CheckAll(checkbox) {
var elements = checkbox.form.elements;
for (var i = 0; i < elements.length; i++) {
if (elements[i].type == "checkbox" && elements[i].id != checkbox.id) {
elements[i].checked = checkbox.checked;
}
}
}
</script>
<p>
</p>


}
}
}