FlowWright.cDevDeAPI Namespace

apiFormEvents Enumeration

apiWorkflowEvents Enumeration

applicationStartType Enumeration

appRoleItemType Enumeration

archivalPeriodType Enumeration

arrowDirection Enumeration

authMode Enumeration

authProviders Class

cacheObjectType Enumeration

changeType Enumeration

clsActivity Class

clsConfigurationSettings Class

clsExtentions Class

clsHTTPClientExt Class

clsMalware Class

clsMalware.AMSI_RESULT Enumeration

clsModGlobal Class

clsObjectCache Class

clsRelChange Class

clsStatistics Class

clsStatItem Class

clsZipArchiveExtension Class

configChanges Enumeration

crticalPathType Enumeration

dashboardType Enumeration

deActiveDirectoryUserConnector Class

deAPIBase Class

deApplication Class

deApplications Class

deAppRoleItems Class

deArchivedEvent Class

deArchivedFormInstance Class

deArchivedInstance Class

deAuthConnection Class

deAuthProvider Class

deBusinessIntelligence Class

deDashboard Class

deDashboardWidget Class

deDecisionTable Class

deDefinition Class

deDefinitionPermissions Class

deDefinitionRelations Class

deDFSFileStorage Class

deDFSSynchronization Class

deEmailTemplate Class

deEmailTrigger Class

deEngineAlert Class

deEngineServices Class

deEventContext Class

deEventServiceBus Class

deExecutionResult Class

deExpression Class

deExpressions Class

deFileSystemTrigger Class

deFileTemplateList Class

definitionPerms Enumeration

definitionSaveType Enumeration

deFormAttachment Class

deFormComment Class

deFormDefinition Class

deFormDefinitionRelations Class

deFormDefSnapshot Class

deFormDesign Class

deFormInstance Class

deFormPermissions Class

deFormRuntime Class

defRelationTypes Enumeration

deFTPTrigger Class

deHolidaySchedule Class

deIEventHandler Interface

deInstance Class

deLDAPUserConnector Class

deMasterTenant Class

deMicroService Class

deMicroServices Class

deMSMQTrigger Class

deoAuthConnections Class

deOLEDBDatabaseUserConnector Class

dePermissions Class

deRabbitMQTrigger Class

deRealTime Class

deReportDefinition Class

deRuntime Class

deSFTPTrigger Class

deStepExecutionInfo Class

deSyncFileRequest Class

deSynchFileResult Class

deSystemRole Enumeration

deTableColumns Class

deTableExtensions Class

deTaskTemplateType Enumeration

deTenantManager Class

deWorkflowDefinition Class

deWorkflowDefSnapshot Class

deWorkflowInstance Class

deWorkflowInstance.clsInstReturnMaxDates Class

dfsConnector Class

DFSFileType Enumeration

DFSSyncAction Enumeration

DFSSyncStatus Enumeration

emailSendType Enumeration

emailStatus Enumeration

emptyType Enumeration

engineAlertStatus Enumeration

engineServices Enumeration

eventPriority Enumeration

eventStatus Enumeration

exportPackageType Enumeration

expressionType Enumeration

folderType Enumeration

globalizationItemType Enumeration

IEnumerableExtensions Class

IEnumerableExtensions.pathInfo(T) Class

instanceLevel Enumeration

itemExistStatus Enumeration

itemType Enumeration

loginType Enumeration

quartzTriggerIntervalType Enumeration

QueryStringBuilder Class

queueItems Enumeration

queuePermisionType Enumeration

resourceType Enumeration

roleType Enumeration

scheduleItemStepStatus Enumeration

scheduleType Enumeration

serverRole Enumeration

serverStatus Enumeration

serviceStartType Enumeration

statisticType Enumeration

StepInput Class

StepReturn Class

subDefType Enumeration

systemDashboardType Enumeration

tableExItemTypes Enumeration

tableExtDataTypes Enumeration

tableExtUIControl Enumeration

tableItemTypes Enumeration

taskStatus Enumeration

taskType Enumeration

tenantSelectionType Enumeration

tenantStatus Enumeration

translateProvider Enumeration

userConnectorEnabledType Enumeration

userConnectorPeriodType Enumeration

userConnectorStatus Enumeration

userDisplayMenuItems Enumeration

userLoginType Enumeration

userNameValidation Enumeration

userNotificationItemType Enumeration

userNotificationStatus Enumeration

userStatus Enumeration

wfBusinessObject Class

wfdatatype Class

wfeventhandler Class

wfFormWidget Class

wfFormWidgetEvents Class

wfFormWidgetInput Class

widgetType Enumeration

workStatus Enumeration

FlowWright.cDevDeAPI.Globalization Namespace

AzureTranslation Class

AzureTranslationResult Class

clsResourceItem Class

clsResourceItemComparer Class

deGlobalization Class

deGlobalizationItems Class

FlowWright.cDevDeAPI.Mobile Namespace

checklistItems Class

CheckListTaskData Class

clsFileAttachment Class

clsFormGlobalizationData Class

clsLangData Class

clsLanguageGlobalization Class

clsStatus Class

clsSynchStatus Class

clsTaskData Class

clsTaskList Class

clsUserList Class

clsUserSelectionData Class

FormTaskData Class

FormWidget Class

SingleOrArrayConverter(T) Class

FlowWright.cDevDecisionEngine Namespace

authResponseType Enumeration

clsActualDuration Class

clsAuthenticationResponse Class

clsBarChartWidgetReturn Class

clsBusinessObject Class

clsBusinessObjectCollection Class

clsBusinessObjectDef Class

clsButtonWidgetReturn Class

clsCategory Class

clsComment Class

clsConfig Class

clsConnection Class

clsCustomValidationMessage Class

clsDashboardWidget Class

clsDashboardWidgetContext Class

clsDataTableWidgetReturn Class

clsDataType Class

clsDataTypeContext Class

clsDecisionTable Class

clsDecisionTableDataRow Class

clsDecisionTableInput Class

clsDecisionTableIO Class

clsDecisionTableNoMatchedRow Class

clsDecisionTableOutput Class

clsDecisionTableResult Class

clsDEFile Class

clsDEFolder Class

clsDFSFileStoreConfig Class

clsDuplicateConnMessage Class

clsEngine Class

clsEngineContext Class

clsExecutionIteration Class

clsExpressionCacheItem Class

clsExpressionMethods Class

clsFigure Class

clsFormSchemaCollection Class

clsFormVariable Class

clsFormVariableCollection Class

clsFormVariableDefinition Class

clsFormWidget Class

clsFormWidgetCategory Class

clsFormWidgetContext Class

clsFormWidgetEvent Class

clsFormWidgetInput Class

clsFormWidgetReturn Class

clsGlobal Class

clsGlobalCollection Class

clsHTMLWidgetReturn Class

clsInvalidLinkValue Class

clsLineChartWidgetReturn Class

clsLoginInfo Class

clsLogOffInfo Class

clsModelValidator Class

clsNumberWidgetReturn Class

clsPieChartWidgetReturn Class

clsRequiredInput Class

clsReturnsCollection Class

clsSchema Class

clsSchemaItem Class

clsSchemaModel Class

clsSchemaProvider Class

clsSelfConnection Class

clsStatic Class

clsStepCategory Class

clsStepDefinition Class

clsStepInput Class

clsStepReturn Class

clsStepValidation Class

clsTimeLeftOverReturn Class

clsUIModel Class

clsUIModel.clsCPItem Class

clsValidationContext Class

clsVariable Class

clsVariableCollection Class

cornerType Enumeration

criticalPathRenderType Enumeration

dataTypeData Class

deBarchartSeries Class

deBarChartWidget Interface

deButtonWidget Interface

decisionDataType Enumeration

deDataTableWidget Interface

deExternalUser Class

deHTMLWidget Interface

deIAuthProvider Interface

deIBusinessObject Interface

deIDFSStorageConnector Interface

deIFormWidget Interface

deIStep Interface

deIStep2 Interface

deIStep2Async Interface

deIStepAsync Interface

deIStepEngineContext Interface

deIUserConnector Interface

deIWidget Interface

deIWidgetReturn Interface

deLineChartWidget Interface

deNumberWidget Interface

dePieChartSeries Class

dePieChartWidget Interface

deServerSession Class

deSession Class

deSQLBarChartWidget Interface

deSQLLineChartWidget Interface

deSQLNumberWidget Interface

deSQLPieChartWidget Interface

deTenantServerSession Class

deTenantUserSession Class

deTimeLeftOverWidget Interface

deUserSession Class

DFSFileStoreFileType Enumeration

eventExecutionStatus Enumeration

executionMode Enumeration

executionStatus Enumeration

figurePort Enumeration

formVariableDataType Enumeration

formWidgetData Class

formWidgetEvent Class

formWidgetInput Class

formWidgetStyleAttributes Class

getSetPropertyObjects Enumeration

globalDataType Enumeration

historyItemType Enumeration

httpMethod Enumeration

IDataType2 Interface

instancePriority Enumeration

lineType Enumeration

loginRequestType Enumeration

moveDirection Enumeration

payLoadType Enumeration

schemaMode Enumeration

schemaType Enumeration

stepInput Class

stepReturn Class

stepReturnCollectionKeys Class

stepState Enumeration

taskPriority Enumeration

variableDataType Enumeration

widgetData Class

FlowWright.cDevErrorProvider Namespace

actionType Enumeration

auditSource Enumeration

auditSourceold Enumeration

clsCommon Class

clsDBAuditLogProvider Class

clsDBErrorProvider Class

DBAuditMessage Class

entryType Enumeration

IAuditLogProvider Interface

IErrorProvider Interface

priorityLevel Enumeration

FlowWright.deDataAccess Namespace

clsDataAccess Class

clsDataAccess Members

clsDataAccess Constructor

clsDataAccess Methods

addItemsToLogXML Method

adjustDatesForTimeZone Method

beginTransaction Method

buildSQLServerConnectionString Method

changeDatabase Method

commitTransaction Method

createDatabase Method

dataSetToXML Method

dataTableToXML Method

deleteRecord Method

Disconnect Method

generateTableData Method

generateTableScripts Method

getConfigValue Method

getConnectionStringPropertiesValues Method

GetDataAdapter Method

GetDataset Method

GetDataTable Method

GetDataTable Method (String, String, String, OrderedDictionary)

GetDataTable Method (String, OrderedDictionary)

GetDateTimeColumns Method

getDBColumnNames Method

getInsertStatement Method

GetScalarBool Method

GetScalarInt Method

GetScalarLong Method

GetScalarString Method

GetScalarValue Method

GetSqlDataReader Method

getTableColumns Method

getTableNamesThatStartWith Method

getTables Method

hasDatabase Method

hasTable Method

hasTables Method

insertRecord Method

isValidSELECTQuery Method

NonQuery Method

readBinaryData Method

rollbackTransaction Method

tableExists Method

testConnection Method

updateRecord Method

upsertRecord Method

writeBinaryData Method

writeDBCall Method

writeError Method

clsDataAccess Properties

dbProviderType Enumeration

sqlAuthType Enumeration

weekendType Enumeration

System Namespace

clsDataTable Class

clsDateTimeExt Class

clsXDocument Class

clsDataAccess..::..GetDataTable Method (String, OrderedDictionary)

returns a data table by executing a sql statement

Namespace: FlowWright.deDataAccess
Assembly: deDataAccess (in deDataAccess.dll)

Syntax

public DataTable GetDataTable(
	string sql,
	OrderedDictionary oParms
)

Public Function GetDataTable ( _
	sql As String, _
	oParms As OrderedDictionary _
) As DataTable

public:
DataTable^ GetDataTable(
	String^ sql, 
	OrderedDictionary^ oParms
)

Parameters

sql: Type: String
sql statement

oParms: Type: OrderedDictionary
sql parameters

Return Value

DataTable.

See Also

clsDataAccess Class

GetDataTable Overload

FlowWright.deDataAccess Namespace