SqlDataAccess.CreatePagingCommand

Sql 2005 and later specific semi-generic paging routine

public DbCommand CreatePagingCommand(string sql, int pageSize, 
			int page, string sortOrderFields, 
			object[] Parameters)

sql

pageSize

page

sortOrderFields

Parameters