How to Query Next Record in SQL server Database if we had selected the previous single record?

Question

0.00/5 (No votes)

See more:

I want to select a single record at a time from SQL Server. & want to select next/previous record on button's click event in C# OR ASP.net.

OR

I wanna use next & previous button for the photo gallery in ASP.net

Posted 15-Jun-10 0:29am

Vivek Kharb

Updated 15-Jun-10 22:44pm

v2

Add a Solution

6 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)

**PSK_** · Answer 1 · 2010-06-15T01:16:00

your query will be somewhat similar like this, just set the offset.

SQL

SELECT * FROM (
	SELECT TOP 1 * FROM (
		SELECT TOP [Y] LogID,EventID,Priority,Severity,Title
		FROM [LOG]
		WHERE Severity='Error'
		ORDER BY LogID  ASC) as InnerTable
	ORDER by LogID DESC) as OuterTable
ORDER by LogID ASC

-- Replace [Y] with the offset.

Ankur^\m/ · Answer 2 · 2010-06-15T01:09:00

I don't understand what you are trying to do.
Let me know if I am getting you right?
I guess your query returns multiple rows. Now in your UI you need to display 1 record at a time and on button click you need to show the next record (in ASP.NET). If this is you requirement, you need to use a DetailsView[^].
You can loop through the next record using DetailsView Paging[^].

If this is not what you want, give an explanation of your requirement.

prasadbuddhika · Answer 3 · 2010-06-15T22:51:00

ok , if you are talking about reading records from the application end you can just use a select query and get the data to the application layer and navigate through it , but if you are trying to do it at the sql server then it will be bit difficult (but hope it is possible by passing an argument), and back to application layer once you read the data from the DB you can use either dataset or a collection to store it.this will allow you to navigate as you want , but if you use datareader it will allow you to navigate only forward and not backward...

santhosh1987 · Answer 4 · 2011-12-05T22:39:00

Solution 4

~~<><a href=""></a><a href=""></a>[<a href="" target="_blank"></a>]~~

Posted 5-Dec-11 22:39pm

santhosh1987

Milind Karpe · Answer 5 · 2012-07-01T09:55:00

Solution 5

Select Next and Previous record in SQL

Posted 1-Jul-12 9:55am

Milind Karpe

Comments

[no name] 1-Jul-12 16:09pm

Do you really think that the OP has been waiting 2 years for this answer?

Milind Karpe 2-Jul-12 1:17am

This solution is for new readers...

Shemeer NS · Answer 6 · 2012-07-01T10:16:00

Solution 6

do custom paging, just google it for custom paging proc

Posted 1-Jul-12 10:16am

Shemeer NS

Comments

[no name] 1-Jul-12 16:44pm

Do you really think that the OP has been waiting 2 years for this answer?

Shemeer NS 1-Jul-12 16:47pm

not really... it's for others who is looking for the same solution... this asked just before 2 weeks