I want my gird to sort only the items on the current page when I click on a column header. I wrote a little test app, but when I sort it pulls in items from other pages and places them on the current page.
i.e.
If I have:
IntegerValue StringValue CurrencyValue
0 Item 0 0
1 Item 1 1.23
< >
then sort I will get:
IntegerValue StringValue CurrencyValue
8 Item 8 9.84
7 Item 7 8.61
< >
and what I want is:
IntegerValue StringValue CurrencyValue
1 Item 1 1.23
0 Item 0 0
< >
using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
namespace WebApplication2
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.P age
{
protected System.Web.UI.W ebControls.Data Grid ItemsGrid;
private void Page_Load(objec t sender, System.EventArg s e)
{
ItemsGrid.DataS ource = CreateDataSourc e();
ItemsGrid.DataB ind();
}
ICollection CreateDataSourc e()
{
// Create a Random object to mix up the order of items in the
// sample data.
Random Rand_Num = new Random();
// Create sample data for the DataGrid control.
DataTable dt = new DataTable();
DataRow dr;
// Define the columns of the table.
dt.Columns.Add( new DataColumn("Int egerValue", typeof(Int32))) ;
dt.Columns.Add( new DataColumn("Str ingValue", typeof(String)) );
dt.Columns.Add( new DataColumn("Cur rencyValue", typeof(Double)) );
// Populate the table with sample values.
for (int i=0; i<=8; i++)
{
dr = dt.NewRow();
dr[0] = i;
dr[1] = "Item " + i.ToString();
dr[2] = 1.23 * i;
dt.Rows.Add(dr) ;
}
// To persist the data source between posts to the server,
// store it in session state.
Session["Source"] = dt;
DataView dv = new DataView(dt);
return dv;
}
#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeCompo nent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.ItemsGrid. PageIndexChange d += new System.Web.UI.W ebControls.Data GridPageChanged EventHandler(th is.ItemsGrid_Pa geIndexChanged) ;
this.ItemsGrid. SortCommand += new System.Web.UI.W ebControls.Data GridSortCommand EventHandler(th is.ItemsGrid_So rtCommand);
this.Load += new System.EventHan dler(this.Page_ Load);
}
#endregion
private void ItemsGrid_SortC ommand(object source, System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
{
// Retrieve the data source from session state.
DataTable dt = (DataTable)Sess ion["Source"];
// Create a DataView from the DataTable.
DataView dv = new DataView(dt);
// The DataView provides an easy way to sort. Simply set the
// Sort property with the name of the field to sort by.
if(Session["sort"] == "ASC")
{
dv.Sort = e.SortExpressio n + " ASC";
Session["sort"] = "DESC";
}
else
{
dv.Sort = e.SortExpressio n + " DESC";
Session["sort"] = "ASC";
}
// Re-bind the data source and specify that it should be sorted
// by the field specified in the SortExpression property.
ItemsGrid.DataS ource = dv;
ItemsGrid.DataB ind();
}
private void ItemsGrid_PageI ndexChanged(obj ect source, System.Web.UI.W ebControls.Data GridPageChanged EventArgs e)
{
// For the DataGrid control to navigate to the correct page when
// paging is allowed, the CurrentPageInde x property must be updated
// programmaticall y. This process is usually accomplished in the
// event-handling method for the PageIndexChange d event.
// Set CurrentPageInde x to the page the user clicked.
ItemsGrid.Curre ntPageIndex = e.NewPageIndex;
// Rebind the data to refresh the DataGrid control.
ItemsGrid.DataS ource = CreateDataSourc e();
ItemsGrid.DataB ind();
}
}
}
<%@ Page language="c#" Codebehind="Web Form1.aspx.cs" AutoEventWireup ="false" Inherits="WebAp plication2.WebF orm1" %>
<!doctype html public "-//w3c//dtd html 4.0 transitional//en" >
<html>
<head>
<title>WebForm1 </title>
<meta name="GENERATOR " content="Micros oft Visual Studio .NET 7.1">
<meta name="CODE_LANG UAGE" content="C#">
<meta name="vs_defaul tClientScript" content="JavaSc ript">
<meta name="vs_target Schema" content="http://schemas.microso ft.com/intellisense/ie5">
</head>
<body ms_positioning= "GridLayout ">
<form id="Form1" method="post" runat="server">
<asp:datagrid id="ItemsGrid" style="Z-INDEX: 101; LEFT: 104px; POSITION: absolute; TOP: 208px"
runat="server" allowsorting="T rue" allowpaging="Tr ue" pagesize="2"></asp:datagrid>
</form>
</body>
</html>
