How to do Paging in a GridView with Image buttons [Resolved]

Posted by Amulya under ASP.NET on 6/30/2013 | Points: 10 | Views : 1528 | Status : [Member] | Replies : 1
How to do Paging in a GridView with Image buttons

Please tell me how to do Paging in a GridView with Image buttons. I use image buttons as first next previous and last.

Thanks in advance




Responses

Posted by: Satyapriyanayak on: 6/30/2013 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_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>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView id="g1" Runat="Server" DataKeyNames="EmpId"
AllowPaging="True"
PageSize="2"
AllowSorting="True"
AutoGenerateColumns="False"
CellPadding="2"
HeaderStyle-BackColor="#E0E0E0"
PagerSettings-Position="TopAndBottom"
PagerSettings-Mode="NextPreviousFirstLast"
PagerSettings-FirstPageImageUrl="~/First.gif"
PagerSettings-PreviousPageImageUrl="~/Previous.gif"
PagerSettings-NextPageImageUrl="~/Next.gif"
PagerSettings-LastPageImageUrl="~/Last.gif"
PagerStyle-BackColor="#E0E0E0"
PagerStyle-HorizontalAlign="Center" onpageindexchanging="g1_PageIndexChanging">
<Columns>
<asp:BoundField DataField="EmpId" HeaderText="EmpId" ItemStyle-Width="50"/>
<asp:BoundField DataField="Title" HeaderText="Title" ItemStyle-Width="50"/>
<asp:BoundField DataField="EmpName" HeaderText="EmpName" ItemStyle-Width="50"/>
<asp:BoundField DataField="Address" HeaderText="Address" ItemStyle-Width="50"/>
<asp:BoundField DataField="Phone" HeaderText="Phone" ItemStyle-Width="50"/>
<asp:BoundField DataField="Salary" HeaderText="Salary" ItemStyle-Width="50"/>
<asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="50"/>

</Columns>
</asp:GridView>

</div>
</form>
</body>
</html>



using System;
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.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommand com ;
SqlDataAdapter sqlda;
DataSet ds;
string str;

protected void Page_Load(object sender, EventArgs e)
{
bindgrid();
}

void bindgrid()
{
SqlConnection con = new SqlConnection(connStr);
con.Open();
str = "select * from employee";
com = new SqlCommand(str, con);
sqlda = new SqlDataAdapter(com);
ds = new DataSet();
sqlda.Fill(ds, "employee");
g1.DataMember = "employee";
g1.DataSource = ds;
g1.DataBind();
con.Close();
}
protected void g1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
g1.PageIndex = e.NewPageIndex;
bindgrid();
}
}



If this post helps you mark it as answer
Thanks

Amulya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response