SqlDataAccess.CreatePagingCommand

Sql 2005 specific semi-generic paging routine

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

sql

pageSize

page

sortOrderFields

Parameters