IDataExportService.GetDataFromView Method

IDataExportServiceGetDataFromView Method

[This is preliminary documentation and is subject to change.]

Returns the result from a database view that is readable for the given database user. Result can be filtered by passing an optional where clause

Namespace: _3LProServices.DataExportService
Assembly: 3LProServices (in 3LProServices.dll) Version: 15.2.1.19 (15.2.1.19)

Syntax

DataTable GetDataFromView(
	string Username,
	string Password,
	string DbViewName,
	string WhereClause = ""
)

Function GetDataFromView ( 
	Username As String,
	Password As String,
	DbViewName As String,
	Optional WhereClause As String = ""
) As DataTable

Username: Type: SystemString
UserID for Database User
Password: Type: SystemString
Password for Database User
DbViewName: Type: SystemString
Name of the database view to fetch data from
WhereClause (Optional): Type: SystemString
Optional where-clause used to filter within the database view

Type: DataTable
a DataTable containing the untyped result from the database view