SqlDataAccess.CreatePagingCommand

Sql 2005 and later specific semi-generic paging routine

public virtual DbCommand CreatePagingCommand(string sql,
	int pageSize,
	int page,
	string sortOrderFields,
	Object[] Parameters);

sql

pageSize

page

sortOrderFields

Parameters