Knight Data Access Layer
LoadPage<T>(String,Dictionary<String,Object>,String,Int32,Int32) Method




KellermanSoftware.NetDataAccessLayer Namespace > ObjectCrud Class > LoadPage Method : LoadPage<T>(String,Dictionary<String,Object>,String,Int32,Int32) Method
Generic class type
A SQL where clause
The parameters to use for the where clause
Order by SQL Clause
Page of records starting at 1
The number of records to get per page
Load a page of records that are filtered by a where clause and ordered
Syntax
Public Overloads Function LoadPage(Of T As {Class, New})( _
   ByVal whereClause As String, _
   ByVal parameters As Dictionary(Of String,Object), _
   ByVal orderBy As String, _
   ByVal page As Integer, _
   ByVal pageSize As Integer _
) As List(Of T)
Dim instance As ObjectCrud
Dim whereClause As String
Dim parameters As Dictionary(Of String,Object)
Dim orderBy As String
Dim page As Integer
Dim pageSize As Integer
Dim value As List(Of T)
 
value = instance.LoadPage(Of T)(whereClause, parameters, orderBy, page, pageSize)
public List<T> LoadPage<T>( 
   string whereClause,
   Dictionary<string,object> parameters,
   string orderBy,
   int page,
   int pageSize
)
where T: class, new()
public: List<T*>* LoadPage<T>( 
   string* whereClause,
   Dictionary<string*,Object*>* parameters,
   string* orderBy,
   int page,
   int pageSize
) 
where T: ref class, gcnew()
public:
List<T^>^ LoadPagegeneric<typename T>
( 
   String^ whereClause,
   Dictionary<String^,Object^>^ parameters,
   String^ orderBy,
   int page,
   int pageSize
) 
where T: ref class, gcnew()

Parameters

whereClause
A SQL where clause
parameters
The parameters to use for the where clause
orderBy
Order by SQL Clause
page
Page of records starting at 1
pageSize
The number of records to get per page

Type Parameters

T
Generic class type
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

ObjectCrud Class
ObjectCrud Members
Overload List