bpmAppService.Services.DataSourceServices(datasource) Data retrieval from the database.
| Name | Type of Return | Input Parameter | Description |
|---|---|---|---|
| ExecuteQuery | System.Data.DataTable | BaseTemplate connection, string query | Fetch information from the database connection: Name Communication with the database defined in the communication / database connection, Rayvarz.BPMApp.BPMSTest.Connections.Connections.myConnectionName query: Required Query |
| GenerateSelectQuery | string | DataTable dataTable, List> schemadeclaration | Convert DataTable to Query for use in cascading list data Example : schemadeclaration.Add (new KeyValuePair (“Id”, “uniqueidentifier”)); schemadeclaration.Add (new KeyValuePair (“Name”, “nvarchar (100)”)); schemadeclaration.Add (new KeyValuePair (“Age”, “int”)); can query = mAppService.BPMSServices. DataSourceService.GenerateSelectQuery (dataTable, schemadeclaration); The output structure is the field name and field type that matches the data schema. Schemadeclaration The output structure is the field name and field type that matches the data schema. Schemadeclaration |