Create a DataView from a collection.

Syntax

ISDatabaseBL.CreateDataViewFromCollection(dataView, dataTable, sourceCollection, sourceCollectionDescription, idFieldName, alwaysIncludeId, includeInactive, sqlWhere, [additionalSqlWhere], [validationTarget])

Parameters

NameTypeOptionalByRefDescription
dataView DataView ByRef The newly created DataView.
dataTable DataTable ByRef The DataTable that the DataView will be created on. This is returned so that it can be cached if required.
sourceCollection ICollection The Source Collection.
sourceCollectionDescription String A description of the Source Collection which is used for error reporting purposes.
idFieldName String The name of the Id field.
alwaysIncludeId String The Id of a record to always include regardless of whether the SQL WHERE clauses or its Active state would usually exclude it.
includeInactive Boolean <para> Indicates whether to include collection items that have a Boolean 'Active' property which is set to False. </para> <para> Always set this to False if the collection does not contain items which have an 'Active' property. </para>
sqlWhere String An SQL WHERE clause which can be used as a Filter for the DataView.
additionalSqlWhere String Optional A second, additional SQL WHERE clause to use as a Filter. This will be ANDed with the sqlWhere parameter.
validationTarget iseCollectionDataViewValidationTarget Optional The Validation Target is used to filter out any Fields (Columns) that are not valid for a particular Target, e.g., HTML Widgets and Portals should not have automatic access to information such as Script Code. If omitted, a value of iseCollectionDataViewValidationTarget.Unspecified is assumed.

Return Value

Boolean

A Boolean value indicating success.

Member of:
ISDatabaseBL
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0