 |  |  |  |  |  |  |  |
hi
Please support our C# advertiser: Intel Parallel Studio Home
 |
i want to retrieve last record in database with out doing ascending or decending order...can anyone tell me what query for this?
Why?
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Oct 2008
Posts: 1,934
Reputation: 
Solved Threads: 277
Put a timestamp field in your table and use a query to get the record with the most recent timestamp.
Today is a gift, that's why it is called "The Present".
Make love, no war. Cave ab homine unius libri.
Danny
Make love, no war. Cave ab homine unius libri.
Danny
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation:
Solved Threads: 137
either timestamp or as long as you are doing inserts with an autoincrementing id
C# Syntax (Toggle Plain Text)
Last edited by dickersonka; Nov 11th, 2008 at 11:14 pm.
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
•
•
Join Date: Jul 2008
Posts: 65
Reputation:
Solved Threads: 6
Junior Poster in Training
hi
u can use this way also
if u r insert records automatic way or(autogenerate id) means this is useful
u can use this way also
•
•
•
•
select max(id) from tablename
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation:
Solved Threads: 137
thats what i wrote, he said record, thats why i selected the whole row
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
|
Other Threads in the C# Forum
- Previous Thread: Unable to update table
- Next Thread: Making a tetris game.
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C# Posts
- Today's Posts
- Unanswered Threads
.net access algorithm array asp.net barchart bitmap box broadcast buttons c# check checkbox client combobox control conversion csharp custom database databaseconnection datagrid datagridview dataset datetime dbconnection degrees design development draganddrop drawing encryption enum event eventhandlers excel file firefox form format forms function gdi+ grantorrevokepermissionthroughc#.net httpwebrequest image index input install java label libraries list listbox loop mandelbrot math mouseclick movingimage mysql mysql.data.client operator path photoshop picturebox pixelinversion platform post programming radians regex remote remoting resourcefile richtextbox server sleep socket sql statistics stream string system.servicemodel table tcpclientchannel text textbox thread time timer update usercontrol validation visualstudio webbrowser windows winforms wpf wpfc# xml
