 |  |  |  |  |  |  |  |
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.
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,162
Reputation: 
Solved Threads: 138
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: 66
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,162
Reputation:
Solved Threads: 138
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.
Views: 400 | Replies: 5
| Thread Tools | Search this Thread |
Latest C# Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for C#
.net access algorithm array barchart bitmap box button buttons c# chat check checkbox class client code color combobox control conversion csharp custom database datagridview dataset datetime degrees draganddrop drawing encryption enum excel file files form format forms ftp function gdi+ httpwebrequest image index input install java label list listbox listener login mandelbrot math mouseclick mysql networking object operator oracle path photoshop picturebox pixelinversion post prime programming radians regex remote remoting resource richtextbox save saving serialization server sleep socket sql statistics stream string table tcp text textbox thread time timer treeview update usercontrol validation view visualstudio webbrowser windows winforms wpf xml
