Click or drag to resize
DataExportServiceGetDataFromView 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
public DataTable GetDataFromView(
	string Username,
	string Password,
	string DbViewName,
	string WhereClause = ""
)

Parameters

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.exclude WHERE statement. Example: "FTG = 100 and OBJEKT like 'FOO%'"

Return Value

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

Implements

IDataExportServiceGetDataFromView(String, String, String, String)
See Also