Connection string: Data Source=banka-pc;Integrated Security=true;Initial Catalog=test2
ASPX file:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="gridviewSortPaging.aspx.cs"
Inherits="GridviewPagingSorting._Default" %>
<!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 runat="server">
<title>Gridview Paging and Sorting </title>
</head>
<body>
<form id="form1" runat="server">
<div>
<div style="font-size: 20px; font-family: Verdana">
<u> Gridview Paging and Sorting</u>
<br />
<br />
</div>
<div>
<asp:GridView ID="GridVwPagingSorting" runat="server" AutoGenerateColumns="False"
Font-Names="Verdana" AllowPaging="True" AllowSorting="True" PageSize="1" Width="75%"
OnPageIndexChanging="PageIndexChanging" BorderColor="#CCCCCC" BorderStyle="Solid"
BorderWidth="1px" OnSorting="Sorting">
<AlternatingRowStyle BackColor="#BFE4FF" />
<PagerStyle BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px" />
<PagerSettings Mode="NumericFirstLast" FirstPageText="First" LastPageText="Last" PageButtonCount="2" NextPageText="next" PreviousPageText="prev" />
<HeaderStyle Height="30px" BackColor="#6DC2FF" Font-Size="15px" BorderColor="#CCCCCC"
BorderStyle="Solid" BorderWidth="1px" />
<RowStyle Height="20px" Font-Size="13px" BorderColor="#CCCCCC" BorderStyle="Solid"
BorderWidth="1px" />
<Columns>
<asp:BoundField DataField="name" HeaderText="Student Name" SortExpression="name" />
<asp:BoundField DataField="dob" HeaderText="DOB" SortExpression="dob" />
<asp:BoundField DataField="sal" HeaderText="Salary" SortExpression="sal" />
</Columns>
</asp:GridView>
</div>
<div style="color: Green; font-weight: bold">
<br />
<i>You are viewing page
<%=GridVwPagingSorting.PageIndex + 1%>
of
<%=GridVwPagingSorting.PageCount%>
</i>
</div>
</div>
</form>
</body>
</html>
ASPX.cs
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;
namespace GridviewPagingSorting
{
public partial class _Default : System.Web.UI.Page
{
string Sort_Direction = "name ASC";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["SortExpr"] = Sort_Direction;
DataView dvEmployee = Getdata();
GridVwPagingSorting.DataSource = dvEmployee;
GridVwPagingSorting.DataBind();
}
}
private DataView Getdata()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
{
DataSet dsEmployee = new DataSet();
string strSelectCmd = "SELECT [name],[dob],[sal] FROM [student]";
SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn);
da.Fill(dsEmployee, "Student");
DataView dvEmp = dsEmployee.Tables["student"].DefaultView;
dvEmp.Sort = ViewState["SortExpr"].ToString();
return dvEmp;
}
}
protected void PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridVwPagingSorting.PageIndex = e.NewPageIndex;
DataView dvEmployee = Getdata();
GridVwPagingSorting.DataSource = dvEmployee;
GridVwPagingSorting.DataBind();
}
protected void Sorting(object sender, GridViewSortEventArgs e)
{
string[] SortOrder = ViewState["SortExpr"].ToString().Split(' ');
if (SortOrder[0] == e.SortExpression)
{
if (SortOrder[1] == "ASC")
{
ViewState["SortExpr"] = e.SortExpression + " " + "DESC";
}
else
{
ViewState["SortExpr"] = e.SortExpression + " " + "ASC";
}
}
else
{
ViewState["SortExpr"] = e.SortExpression + " " + "ASC";
}
GridVwPagingSorting.DataSource = Getdata();
GridVwPagingSorting.DataBind();
}
}
}
Web.Config
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=banka-pc;Integrated Security=true;Initial Catalog=test2" providerName="System.Data.SqlClient"/>
</connectionStrings>
