q) I am using vb.net to access a sql server DB. It works but I want the data ordered by a date field.
Also is there an easier way to display data from a given range . The below code is messy but it works.
command.CommandText = " SELECT * FROM ( SELECT thread.* " & _
" , ROW_NUMBER() OVER (ORDER BY id) AS [RowNumber]" & _
" FROM thread) sq WHERE RowNumber BETWEEN " & LPage & " AND " & UPage