C# GridView 排序及分页_C#应用

如果你在GridView控件上设置 AllowPaging="true" or AllowSorting="true" 而没有使用使用数据源控件 DataSource (i.e. SqlDataSource, ObjectDataSource),运行则会出现下列错误：

当你在GridView控件上单击下一页时：

The GridView 'GridViewID' fired event PageIndexChanging which wasn't handled.

当你点击排序时，则回出现：

The GridView 'GridViewID' fired event Sorting which wasn't handled.

如果你没有设置GridView的DataSourceID 的属性，你必须添加一个操作才可以排序及分页。。

点这里查看下面的例子

<%@ Page Language="C#" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">

private void PopulatePublishersGridView()

{

string connectionString = AccessConnectionString();

OleDbConnection accessConnection = new OleDbConnection(connectionString);

string sqlQuery = "SELECT [PubID], [Name], [Company Name], [Address], [City], [State], [Zip], [Telephone], [Fax], [Comments] FROM Publishers ORDER BY [Name] ASC;";

OleDbCommand accessCommand = new OleDbCommand(sqlQuery, accessConnection);

OleDbDataAdapter publishersDataAdapter = new OleDbDataAdapter(accessCommand);

DataTable publishersDataTable = new DataTable("Publishers");

publishersDataAdapter.Fill(publishersDataTable);

int dataTableRowCount = publishersDataTable.Rows.Count;

if (dataTableRowCount > 0)

{

gridViewPublishers.DataSource = publishersDataTable;

gridViewPublishers.DataBind();