forum

home / developersection / forums / how to use pagination in gridview in asp.net

Ask Question

how to use pagination in gridview in asp.net

Anonymous User 1656 18-Nov-2015
I want to use pagination in gridview  how will do please help me.
.net c#  asp.net 
Updated on 18-Nov-2015
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Anonymous User

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;



        }



    }


}
how to use pagination in gridview in asp.net
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy