Get database last row displayed

Question

0.00/5 (No votes)

See more:

, +

Hello,

I have a database named "sample", I displayed those sample database records in gridview. Its working.

What my task is, I have to show the last database record from sample database to all the rows of gridview.

For eg., a table named database_tbl present with 2 fields i.e., name and age.

I will display those records with gridview using sqldataadapter, ds() etc, suppose a record named "abcd" is the last database record in that table, I need that "abcd" to be displayed in all the rows of that particular gridview.

Thank You

Posted 6-Jan-13 23:26pm

Bhargav.456

Add a Solution

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

__TR__ · Answer 1 · 2013-01-06T23:35:00

My understanding is you want to show the name of the last record in a new column along with other records in your table. If this is the requirement check the below sample

SQL

DECLARE @database_tbl  TABLE
(
    ID INT IDENTITY(1,1),
    Name VARCHAR(100),
    Age INT
)

INSERT INTO @database_tbl
SELECT 'abc1', 12 UNION ALL
SELECT 'abc2', 13 UNION ALL
SELECT 'abc3', 18 UNION ALL
SELECT 'abcd', 21


DECLARE @LastRecordName VARCHAR(100)
SELECT TOP 1 @LastRecordName = Name FROM @database_tbl ORDER BY ID DESC

SELECT *, @LastRecordName AS LastRecordName FROM @database_tbl

Here we store the name of the last record in a variable and use that variable in the final query.

Zafar Sultan · Answer 2 · 2013-01-07T00:45:00

SQL

select [ID], [Name], [Age] from YourTable 
except 
select Top 1 [ID], [Name], [Age] from YourTable order by ID DESC
union all
select Top 1 [ID], [Name], [Age] from YourTable order by ID DESC

This line

SQL

select [ID], [Name], [Age] from YourTable 
except 
select Top 1 [ID], [Name], [Age] from YourTable order by ID DESC

will filter the last row and again add it using this line

SQL

select Top 1 [ID], [Name], [Age] from YourTable order by ID DESC

. The reason to exclude it and then including comes into play for the last page. If it is not done in this way, It will add the last record twice on the last page.

Get database last row displayed

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0