data reader

[behindthepipe]

hi,
i am using ExecuteReader()to read data from ms access database. it will read from row 1 down until the end.
my question is, how do i get it to read starting from the last row to the first row?
thanks in advance.

 

[ca8msm]

Why not just order the SQL Statement so that the results are returned in the correct order?


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[behindthepipe]

hi,
thanks for the reply.
Im quite new with sql statements. How do I order the statement?
thanks.

 

[jbenson001]

Ascending Order:
Select columns
From Table
Where ..something ..
Order By columns

Decending Order:
Select columns
From Table
Where ..something ..
Order By columns DESC