Grid and alot of data

[Gabriel]

Hello,


Imagine, I'd like to show in a grid records from a table, there are a lot of
records, I use a pagin on this grid. The query/transfert result is long. Is
there a way to transfert page by page from the database ? I use SQL Server
2005 express

Thanks,

 

[Mark Fitzpatrick]

There is a new Row_Number function that will help you in SQL Server 2005. I
don't know if it's in express or not, but it's designed to return a row
number along with the record so you can get an idea of the position of the
result row. You can then limit the results return to be from row A to row B.
You'll have ot work out a little logic to pass the values for the range of
rows to return, but it saves a lot of time to be sure.