how to use pagination in gridview in asp.net

Anonymous User 1863 18 Nov 2015

I want to use pagination in gridview how will do please help me.

Ask by Anonymous User

Updated 18 Nov 2015

1 Answers

Anonymous User 18 Nov 2015

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="Solid" BorderWidth="1px" CellPadding="4" AllowPaging="True"
 OnPageIndexChanging="GridView1_PageIndexChanging"  PageSize="8">

        <Columns>

            <asp:TemplateField HeaderText="Emp_ID">

                <ItemTemplate>

                    <%#Eval("Emp_ID") %>

                </ItemTemplate>

                <ControlStyle Width="100px"></ControlStyle>

                <HeaderStyle Width="100px" />

                <ItemStyle HorizontalAlign="Center" />

            </asp:TemplateField>


            <asp:TemplateField HeaderText="Emp_Name" >

                <ItemTemplate>

                    <%#Eval("Emp_Name") %>

                </ItemTemplate>


                <ControlStyle Width="300px"></ControlStyle>

                <HeaderStyle Width="200px" />

            </asp:TemplateField>

            <asp:TemplateField HeaderText="Emp_Sal">

                <ItemTemplate>

                    <%#Eval("Emp_Sal") %>

                </ItemTemplate>


                <ControlStyle Width="200px"></ControlStyle>

                <HeaderStyle Width="200px" />

            </asp:TemplateField>

        </Columns>

        <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />

        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />

        <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />

        <RowStyle BackColor="White" ForeColor="#330099" />

        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />

        <SortedAscendingCellStyle BackColor="#FEFCEB" />

        <SortedAscendingHeaderStyle BackColor="#AF0101" />

        <SortedDescendingCellStyle BackColor="#F6F0C0" />

        <SortedDescendingHeaderStyle BackColor="#7E0000" />

    </asp:GridView>

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace Forumasp

{
    public partial class GridviewSorting : System.Web.UI.Page

    {
        protected void Page_Load(object sender, EventArgs e)

        {

            GridView1.DataSource = GetRecord(); //set DataSource GridView

            GridView1.DataBind(); //binding GridView


        }

        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

        {
            GridView1.PageIndex = e.NewPageIndex;
            GridView1.DataSource = GetRecord();
            GridView1.DataBind();
        }
  
        public DataTable GetRecord()
 
        {
            DataTable dt = new DataTable();

            string constr = 
                           ConfigurationManager.ConnectionStrings["forumConnectionString"].ToString(); // connection string

            SqlConnection con = new SqlConnection(constr);

            con.Open();
            SqlCommand com = new SqlCommand("select *from Employee", con); // table name 

            SqlDataAdapter da = new SqlDataAdapter(com);

            DataSet ds = new DataSet();

            da.Fill(ds);
            dt = ds.Tables[0];
            return dt;


        }

    }
}

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

how to use pagination in gridview in asp.net

Can you answer this question?

1 Answers