C#
VB
C++
Leadtools.Medical.Storage.DataAccessLayer Namespace > Classes > StorageSqlDbDataAccessAgent > Methods > PrepareInstancePageQueryCommand Method
←Select platform
PrepareInstancePageQueryCommand Method (StorageSqlDbDataAccessAgent)
Summary
Initializes a System.Data.IDbCommand object to query for Composite Instance information using matching parameters for pagination.
Syntax
protected override void PrepareInstancePageQueryCommand(System.Data.IDbCommand command,System.Collections.ObjectModel.Collection<Leadtools.Medical.DataAccessLayer.Catalog.CatalogElement[]> matchingParamsCollection,QueryPageInfo queryPageInfo)
Protected Overrides Sub PrepareInstancePageQueryCommand(ByVal command As System.Data.IDbCommand,ByVal matchingParamsCollection As System.Collections.ObjectModel.Collection(Of Leadtools.Medical.DataAccessLayer.Catalog.CatalogElement()),ByVal queryPageInfo As QueryPageInfo)
protected:virtual void PrepareInstancePageQueryCommand(System::Data::IDbCommand^ command,System::Collections::ObjectModel::Collection<array<Leadtools::Medical::DataAccessLayer::Catalog::CatalogElement^>^>^ matchingParamsCollection,QueryPageInfo^ queryPageInfo) override
Parameters
command
Type: System.Data.IDbCommand
The database command that will be initialized to execute the query.
matchingParamsCollection
Type: Collection of CatalogElement Array
The matching parameters for the query.
queryPageInfo
Type: QueryPageInfo
Specifies the page number and page size that will result from the executing the query.
Remarks
This is similar to the PrepareInstancePageQueryCommand method, except that the query will generate paginated results. The queryPageInfo is used to specify a page number and page size for the results. For example, suppose that the executing the query returns 100 rows. If queryPageInfo specifies a page size of 10, and a page number of 3. Executing the query will then return 10 total rows (the page size) starting with row 30 (PageNumber * PageSize). Therefore, the result would be rows 30 through 40.
Requirements
Products | Support | Contact Us | Copyright Notices
© 1991-2017 LEAD Technologies, Inc. All Rights Reserved.
© 1991-2017 LEAD Technologies, Inc. All Rights Reserved.
Leadtools.Medical.Storage.DataAccessLayer Assembly
