Retieve last record in the DB???

[Guest]

Simple question...

I want to retrive the last record in the database if the value of id is
nothing!

Can someone please help!

Thanks

....CODE...
Dim objImpCnt As SqlParameter
If objImpCnt Is Nothing Then
objImpCnt = cmd.Parameters.Add("@newsID", SqlDbType.Int)
objImpCnt.Direction = ParameterDirection.Input
objImpCnt.Value = id
Else
objImpCnt.Value = 'Last Record in the db
End If

 

[Guest]

Hi Tim,

Duinno about the code for the way ur doing it, but the SQL logic would be
something like "SELECT TOP 1 ... ORDER BY newsid DESC"

HTH a bit

Cheers


Dan

 

[Josh]

Assuming you have an Identity key on the table and the table is called
Town...

SELECT TOP 1 * FROM Town ORDER BY TownID DESC