how to fetching data from database in split records

Question

0.00/5 (No votes)

See more:

Dear Friends,

I have some problem when impliments projects.I have lots of records suppose 1 lack and i want to get all full data from database but in split data means first time i get records near about 20 thousand then second time 20 thousand such type and they show data on grid view.how to get such type of implimentation in asp.net

thanks in advanced !!

Posted 5-Jan-15 22:03pm

Member 8089110

Add a Solution

Comments

CHill60 6-Jan-15 4:17am

Not clear. Try including the code you are having a problem with

ArunRajendra 6-Jan-15 4:32am

Can you give the table design?

2 solutions

Solution 1

Keep the number of records configurable (20000 or 10000). Then fire your query as, "select top (no. of records) from........"

Posted 5-Jan-15 23:24pm

nagendrathecoder

Updated 5-Jan-15 23:25pm

v2

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)

Chris Quinn · Accepted Answer · 2015-01-06T00:19:00

In later versions of MSSQL you can use the OFFSET and FETCH NEXT options

e.g. For the first trance

SELECT * from [TableName]
ORDER BY [Column]
OFFSET 0
FETCH NEXT 10000 ROWS ONLY

and for the next tranche

SELECT * from [TableName]
ORDER BY [Column]
OFFSET 10000
FETCH NEXT 10000 ROWS ONLY