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.DataExportServiceAssembly: 3LProServices (in 3LProServices.dll) Version: 15.2.1.19 (15.2.1.19)
Syntaxpublic DataTable GetDataFromView(
string Username,
string Password,
string DbViewName,
string WhereClause = ""
)
Public Function GetDataFromView (
Username As String,
Password As String,
DbViewName As String,
Optional WhereClause As String = ""
) As DataTable
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:
DataTablea DataTable containing the untyped result from the database view
Implements
IDataExportServiceGetDataFromView(String, String, String, String)
See Also