Kentico 9.0 API Reference
Namespaces
CMS.DataEngine
BaseInfo Class
BaseInfo Methods
AddColumnPrefixesWhereCondition Method
AddDependencyDefaultDataWhereCondition Method
BuildObjectPath Method
Clear Method
ClearCache Method
ClearCachedValues Method
ClearData Method
CloneObject Method
CompareTo Method
ContainsColumn Method
CopyExternalColumns Method
CopyMemoryProperties Method
DataChanged Method
Delete Method
DeleteExternalColumns Method
DeleteObject Method
Destroy Method
Disconnect Method
EnsureBinaryData Method
EnsureCodeName Method
EnsureGUID Method
EnsureHierarchyColumns Method
EnsureLastModified Method
EnsureUniqueCodeName Method
ExecuteRemoveDependencyQuery Method
ExecuteWithOriginalData Method
ExportDefaultData Method
Finalize Method
GetAutomaticCodeName Method
GetBinaryData Method
GetBooleanValue Method
GetClearCacheMethods Method
GetColumnNames Method
GetCount Method
GetCurrentObjectPathPart Method
GetCustomProperties Method
GetData Method
GetDataQueryInternal Method
GetDateTimeValue Method
GetDefaultData Method
GetDefaultDataExportColumns Method
GetDefaultDataWhereCondition Method
GetDefaultObject Method
GetDependenciesNames Method
GetDependenciesNamesAuto Method
GetDependencyCacheKeys Method
GetDependencyObjectType Method
GetDependentObjectsWhereConditions Method
GetDoubleValue Method
GetEditingPageURL Method
GetExisting Method
GetExistingBase Method
GetExistingWhereCondition Method
GetExternalColumns Method
GetExternalFiles Method
GetFullObjectName Method
GetGeneralizedInfo Method
GetGlobalPermissionName Method
GetGroupWhereCondition Method
GetGuidValue Method
GetChildDependencies Method
GetChildWhereCondition Method
GetIconUrl Method
GetIDPathPartLength Method
GetIntegerValue Method
GetLastObjectOrder Method
GetLockObject Method
GetModifiedFrom Method
GetNameCollisions Method
GetNamePathPartColumn Method
GetObject Method
GetObjectData Method
GetObjectChildren Method
GetObjectIdentifier Method
GetObjectKey Method
GetObjectName Method
GetObjectOrderID Method
GetObjectTypeForColumn Method
GetOrderIdentityWhereCondition Method
GetOrderQueryParameters Method
GetOriginalValue Method
GetOtherBindings Method
GetParent Method
GetPermissionName Method
GetPermissionObjectType Method
GetPermissionToCheck Method
GetPhysicalFiles Method
GetProperty Method
GetPropertyType Method
GetReferringObjects Method
GetRegisteredProperties Method
GetSearchID Method
GetSiblingsQueryInternal Method
GetSiblingsWhereCondition Method
GetSiteWhereCondition Method
GetStringValue Method
GetSynchronizedColumns Method
GetThumbnailUrl Method
GetUniqueCodeName Method
GetUniqueDisplayName Method
GetUniqueName Method
GetUniqueNameWhereCondition Method
GetValue Method
GetValueForTranslation Method
GetVirtualFileRelativePath Method
ChangedColumns Method
CheckDefaultPermissions Method
CheckDependencies Method
CheckLicense Method
CheckPermissions Method
CheckPermissionsInternal Method
CheckPermissionsWithHandler Method
CheckUniqueCodeName Method
CheckUniqueValues Method
InitObjectsOrder Method
InitObjectsOrderPostprocessing Method
Insert Method
InsertAsClone Method
InsertAsCloneInternal Method
InsertAsClonePostprocessing Method
Invalidate Method
IsAvailableOnSite Method
IsCheckedOutByUser Method
IsChildOf Method
IsModifiedExternally Method
IsObjectInvalid Method
ItemChanged Method
LoadData Method
MacroRepresentation Method
MakeComplete Method
NewObject Method
PermissionCheckException Method
Reconnect Method
RemoveObjectDependencies Method
ResetChanges Method
RestoreSettings Method
RevertChanges Method
SaveExternalColumns Method
SerializationNotSupported Method
SetObject Method
SetObjectAlphabeticalOrder Method
SetObjectOrder Method
SetObjectOrderPostprocessing Method
SetParent Method
SetValue Method
SortAlphabetically Method
StoreSettings Method
SubmitChanges Method
ToMacroString Method
ToString Method
TouchParent Method
TryGetProperty Method
TryGetValue Method
Update Method
UpdateExternalColumns Method
UpdateFromDB Method
UpdatePhysicalFiles Method
WriteDefaultData Method
Click or drag to resize
BaseInfoGetData Method
Returns the data according to the set of input parameters.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 9.0.0
Syntax
C#
Copy
protected virtual DataSet GetData(
	QueryDataParameters parameters,
	string where,
	string orderBy,
	int topN,
	string columns,
	bool binaryData
)

Parameters

parameters
Type: CMS.DataEngineQueryDataParameters
Query parameters
where
Type: SystemString
Where condition to filter data
orderBy
Type: SystemString
Order by statement
topN
Type: SystemInt32
Specifies number of returned records
columns
Type: SystemString
Data columns to return
binaryData
Type: SystemBoolean
If true, binary data are returned in the result

Return Value

Type: DataSet
See Also