In This Article We'll See How To Perform Paging And
Sorting Operations On Grid View Data Through Coding.
STEPS:
Initially
take a gridview control in which you are going to display your data.
As per my requirement i have taken two buttons with
the names "show data in grid view" and "show data in
repeater" which are displayed as the page loads as shown below.
As it is mentioned on the buttons by clicking them
data will be displayed in the respective control.! As Shown Below :
As We Can See In The Above Picture The Data In The
Grid View Is Displayed In An Unsorted Order.
NOTE:- THE PAGING IS ALREADY APPLIED ON
THE GRID VIEW DISPLAYED ABOVE.
à Lets See How The
Paging Can Be Done On The Grid view Programmatically:
Before we perform paging on the grid view control we
have to the set few properties as shown below:
·
AllowPaging="true"
·
PageSize="5"[Display
no.of records/items per page. i have
assigned the value as per my requirement .u can assign any value as per your
criteria].
·
OnPageIndexChanging="Gridview_pageindexchanging"[it
is an event which allows you to write your custom code(main event for
performing paging) . you can assign any event/method to it].
The Above Mentioned Properties Are
Mandatory To Be Assigned To Perform Paging On Grid View.
Here is the code for your designer
file (.ascx):
<asp:GridView
ID="GridView2" runat="server" AllowSorting="true"
>
</asp:GridView>
<asp:TextBox
ID="txtusername" runat="server"></asp:TextBox>
<asp:Button
ID="btninsert" runat="server"
OnClick="btninsert_Click" Text="Insert"/>
<asp:GridView
ID="GridView1" runat="server" AllowPaging="true"
PageSize="5" OnPageIndexChanging="GridView1_PageIndexChanging"
AllowSorting="true" OnSorting="GridView1_Sorting"
AutoGenerateColumns="False"
Width="93px" OnRowCommand="GridView1_RowCommand">
<Columns>
<asp:BoundField
DataField="EmpName" HeaderText="EmpName"
SortExpression="EmpName" />
<asp:TemplateField>
<ItemTemplate>
<asp:Button
runat="server" ID="btnget" CommandArgument='<%#
Eval("EmpName")%>'
CommandName="get" Text="Get Details" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
</Columns>
</asp:GridView>
using System;
using
System.ComponentModel;
using System.Web;
using System.Web.UI;
using
System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using
Microsoft.SharePoint;
using System.Data;
namespace
demowebpart.webpartdemo
{
[ToolboxItemAttribute(false)]
public partial class webpartdemo : WebPart
{
[System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Assert,
UnmanagedCode = true)]
public const string asc =
"ASC";
public const string dsc =
"DESC";
static string str = null;
public webpartdemo()
{
}
protected override void
OnInit(EventArgs e)
{
base.OnInit(e);
InitializeControl();
}
protected void Page_Load(object sender,
EventArgs e)
{
}
protected void
btnshowdataingridview_Click(object sender, EventArgs e)
{
using (SPSite site = new
SPSite("http://vm:22222/sites/saikumar/"))
{
using (SPWeb web =
site.OpenWeb())
{
txtusername.BorderColor =
System.Drawing.Color.Gray;
SPList list =
web.Lists.TryGetList("deptlist");
SPListItemCollection
item = list.GetItems();
DataTable dt = item.GetDataTable();
GridView1.DataSource =
dt;
GridView1.DataBind();
txtusername.Text =
"";
}
}
}
protected void
GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName ==
"get")
{
Button btn =
(Button)e.CommandSource;
using (SPSite site = new
SPSite("http://vm:22222/sites/saikumar/"))
{
using (SPWeb web =
site.OpenWeb())
{
SPList list =
web.Lists.TryGetList("deptlist");
SPQuery query = new
SPQuery();
query.Query =
"<Where><Eq><FieldRef Name='EmpName' /><Value
Type='Text'>" + e.CommandArgument.ToString() +
"</Value></Eq></Where>";
query.ViewFields =
"<FieldRef Name='Title' /><FieldRef Name='EmpName'
/><FieldRef Name='dept' />";
query.ViewFieldsOnly = true;
SPListItemCollection
itemcoll = list.GetItems(query);
DataTable dt =
itemcoll.GetDataTable();
GridView2.DataSource =
dt;
GridView2.DataBind();
}
}
}
}
protected void
GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex =
e.NewPageIndex;
using (SPSite site = new
SPSite("http://vm:22222/sites/saikumar/"))
{
using (SPWeb web =
site.OpenWeb())
{
SPList list =
web.Lists.TryGetList("deptlist");
SPListItemCollection item =
list.GetItems();
DataTable dt =
item.GetDataTable();
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
}
Lets See How Sorting Can Be Done On The Grid view Programmatically:
Before we perform Sorting on the grid view control we have to the set
few properties as shown below:
·
AllowSorting="true"
·
OnSorting="GridView_sorting"
Below
Is The Code For Sorting:
(.cs)
file:
protected void GridView1_Sorting(object sender,
GridViewSortEventArgs e)
{
using (SPSite
site = new SPSite("http://vm:22222/sites/saikumar/"))
{
using
(SPWeb web = site.OpenWeb())
{
SPList
list = web.Lists.TryGetList("deptlist");
//
SPListItem items = list.Items.Add();
//items["EmpName"] = txtusername.Text;
//
items.Update();
SPListItemCollection item = list.GetItems();
DataTable dt = item.GetDataTable();
DataView dv = new DataView(dt);
//dv.Sort = e.SortExpression+" "+dsc;
if (str
== null)
{
dv.Sort = e.SortExpression + " " + asc;
}
else
if (str == e.SortExpression + " " + dsc)
{
dv.Sort = e.SortExpression + " " + asc;
}
else
{
dv.Sort = e.SortExpression + " " + dsc;
}
GridView1.DataSource = dv;
GridView1.DataBind();
str =
dv.Sort;
}
}
}
}
}
After sorting the
gridview looks :
Here We Can See The Gridview Is
Sorted In Descending Order.
In The Same Way We Can Sort It In
Ascending Order As Well.
Thank you