c# - SQL 2005 optimal "Paging" -

When creating a record "grid" with custom paging, the best / optimal way to query along with the total number of records What is the use of records starting with C #?

To return the paged record set back to the SQL:

  Select something, from the column (select ROW_NUMBER) (column ASC by column) AS Roid, * WHERE from Records (...) ASTBL virus (ROID & gt; @ offset) and (roid & lt; = (@ offset + @ Pagesyz)))  

Total of SQL record To calculate the number:

  select COUNT (*) from the record where (...)  

Right now, I have two server visits : To get the record Second to calculate the total number of another record.

What is the best way to combine these questions to avoid multiple DB trips?

You have to pass the output parameter with the output parameter (or return value) To begin the total number of rows, select @TotalRows int @TotalRows = count (*) ... select (@TotalRows & gt)

  process dbo. Create Stuff_GetAll (@StartRowIndex int, - Zero based @MaximumRows int); 0 and @ max. ROS>), select (*, row_number () with T) () ... select t from * t to where @startroindex + 1 and (@startroindex + max minimum row) You can add a check to a counting query (only) when a first page is requested (can be quite expensive).