Code for displaying the latest addition in database

Question

0.00/5 (No votes)

See more:

I want to show the latest information add in the database on the main page of my website, ca any one help me for the code or how can i do this in asp.net database MSSql 2005,

Can i display this using gridview

Posted 5-May-10 21:51pm

vinay_gawli

Updated 11-May-10 19:57pm

v3

Add a Solution

Comments

Michel Godfroid 6-May-10 4:01am

What database? Does it have time stamps?

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

Pete O'Hanlon · Accepted Answer · 2010-05-05T23:51:00

Solution 2

Do you have a date created/updated on the tables? If you have, you can use these to order your query. Alternatively, you could order by the identity column, but this will only show where items have been inserted - it won't display where items have been updated.

Posted 5-May-10 23:51pm

Pete O'Hanlon

#realJSOP · Accepted Answer · 2010-05-05T23:47:00

Solution 1

You haven't given us enough info to answer the question accurately, but if your table has a identity column, you can simply do this :

select top 1 * from table order by identitycolumn desc

Posted 5-May-10 23:47pm

#realJSOP

NiteshMeshram · Accepted Answer · 2010-05-06T19:21:00

Solution 3

Make a method that silently checks the changes in data base and if there is any changes reflect changes in the page..use AJAX Update Panel for this.

Thanx
Nitesh Meshram

Posted 6-May-10 19:21pm

NiteshMeshram