Doubt on paging in asp.net

Question

0.00/5 (No votes)

See more:

Hi,

I just retrieved the data from database and displayed it in a div.Now i want to apply paging for this.Kindly tell me how to do that.I used the following coding.

protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select Departure from Flight_Info";
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{


Response.Write(@"<div align='center'><font color='red'>" + dr.GetValue(0) + "</font></div>");
}
con.Close();
}

Posted 3-Jan-12 20:53pm

sreenathpktr

Add a Solution

5 solutions

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)

RaviRanjanKr · Answer 1 · 2012-01-03T21:18:00

Solution 2

Check
Paging through lots of data efficiently (and in an Ajax way) with ASP.NET 2.0[^]
Paging In ASP.NET[^]
Custom Paging with the ASP.NET Repeater Control[^]

Posted 3-Jan-12 21:18pm

RaviRanjanKr

Updated 3-Jan-12 21:19pm

v2

OriginalGriff · Answer 2 · 2012-01-03T21:12:00

Assuming you have a lot of info to display (and there is no reason for paging otherwise) can I suggest that you use a GridView instead of just loading it into a bunch of divisions?

If you do, you can use the built in paging of a GridView: Showing a page of information at a time in a GridView[^]

If you don't then you have to maintain a Session variable which tells you which record to start with, and kip as appropraite, display next and prev buttons yourself, etc.

Displaying in a GridView is neater - and a lot easier when you want to display more than one item of information for each record later, too.

sawant parag · Answer 3 · 2012-01-03T21:35:00

Solution 3

Use Session to manitanin the page size limit dynamically .

Posted 3-Jan-12 21:35pm

sawant parag

Tanveer A · Answer 4 · 2012-01-03T21:41:00

Solution 4

use datagrid for paging it is easy rather than div

Posted 3-Jan-12 21:41pm

Tanveer A

srinivas vadepally · Answer 5 · 2012-01-04T02:00:00

Solution 5

Gridview Paging[^]

Posted 4-Jan-12 2:00am

srinivas vadepally