Can i make a commomn class in app_code folder for customise paging in asp.net

Question

5.00/5 (1 vote)

See more:

I mean i make a class in app_code folder and use it in whole project for pagination. AS customize paging fetch only required data while grid view paging fetch whole data. Thanks

Posted 22-Jan-12 18:51pm

mohit _srivastava

Add a Solution

2 solutions

Solution 1

Yes you can create a common class for implementing paging for all pages. I have used LINQ to SQL approach for my project and paging implementation is done using the same. The common approach for paging depends on how you design your application for interacting with the database.

Posted 22-Jan-12 18:57pm

Rajesh Kariyavula

Comments

mohit _srivastava 23-Jan-12 2:40am

can you please give a simple example as i am new in this.

I am using grid view in whole project and wants to apply customize paging.
so how can i do with.
I want to code one pagination file and use every where in project but don't know how????

Thanks in advance..

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Supriya Srivastav · Accepted Answer · 2012-01-22T19:06:00

Solution 3

Ya,
Create a function in class like,

C#

public void GV_Paging(GridViewPageEventArgs e, DataTable dt, GridView gvOrders)
   {
       gvOrders.PageIndex = e.NewPageIndex;
       gvOrders.DataSource = dt.DefaultView;
       gvOrders.DataBind();
   }

And call this function on PageIndexChanging event of Gridview in your code page like,

cmn.GV_Paging(e, dt, gvOrders);

Where cmn : object of class
dt : datasource of your gridview
gvOrders : Id of Gridview

Posted 22-Jan-12 19:06pm

Supriya Srivastav

Comments

mohit _srivastava 23-Jan-12 1:18am

thank u supriya but having a 1 more doubt that my grid view for whole project should me of equal no of columns

Supriya Srivastav 23-Jan-12 1:23am

No,when passing source of your gridview,it just binds gridview having whatever columns.

mohit _srivastava 23-Jan-12 1:32am

ok thank u now i am going to try it...
Thank u

mohit _srivastava 23-Jan-12 2:30am

supriya everything is fine but one problem comes that pagination link in grid view doesn't comes second time as second time data fetch from database is equal to the page size.

so what to do..

Supriya Srivastav 23-Jan-12 3:25am

Are paging links invisible....

Tech Code Freak 23-Jan-12 3:19am

5up!

Supriya Srivastav 23-Jan-12 3:24am

@Tech Code Freak Thanks.......

mohit _srivastava 23-Jan-12 5:26am

mam actually first i bind all data in grid view so page link of grid view are visible but when the page index event change i want database to fetch only number of records that are equal to page size so grid view found records that are equal to page size so its page link is invisible.

Supriya Srivastav 27-Jan-12 5:28am

Why do you fetch data from database on each pager link click,you fetch data only once and store that in session and on PageIndexChanging event rebind it,what's the issue in that.