StiGoogleSheetsDatabase Class
Namespace: Stimulsoft.Report.Dictionary.Databases.Google
Inheritance
Inherits from: StiDatabase
Constructors
| Constructor | Description |
|---|---|
| StiGoogleSheetsDatabase() | |
| StiGoogleSheetsDatabase(string name, string alias, string key, string clientId, string clientSecret, string spreadsheetId, bool firstRowIsHeader) |
StiGoogleSheetsDatabase()
StiGoogleSheetsDatabase(name: string, alias: string, key: string, clientId: string, clientSecret: string, spreadsheetId: string, firstRowIsHeader: bool)
Parameters
- name (string)
- alias (string)
- key (string)
- clientId (string)
- clientSecret (string)
- spreadsheetId (string)
- firstRowIsHeader (bool)
Properties
| Property | Type | Description |
|---|---|---|
| ClientId | string | |
| ClientSecret | string | |
| FirstRowIsHeader | bool | |
| SpreadsheetId | string |
Methods
| Method | Returns | Description |
|---|---|---|
| ApplyDatabaseInformation (+1 overloads) | void | Adds tables, views and stored procedures to report dictionary from database information. |
| ApplyDatabaseInformationSource | void | |
| CreateConnector | StiDataConnector | |
| CreateGoogleSheetsConnector | StiGoogleSheetsConnector | |
| Edit | DialogResult | |
| EditAsync | Task |
|
| GetDataAdapter | StiGoogleSheetsAdapterService | |
| GetDatabaseInformation | StiDatabaseInformation | Returns full database information. |
| GetDatabaseInformationTables | List |
|
| RegData | void | Registers the database in dictionary. |
Method Details
ApplyDatabaseInformation
ApplyDatabaseInformation(information: StiDatabaseInformation, report: StiReport): void
Adds tables, views and stored procedures to report dictionary from database information.
Parameters
- information (StiDatabaseInformation)
- report (StiReport)
ApplyDatabaseInformation(information: StiDatabaseInformation, report: StiReport, informationAll: StiDatabaseInformation): void
Adds tables, views and stored procedures to report dictionary from database information.
Parameters
- information (StiDatabaseInformation)
- report (StiReport)
- informationAll (StiDatabaseInformation)
ApplyDatabaseInformationSource
ApplyDatabaseInformationSource(information: StiDatabaseInformation, report: StiReport, informationAll: StiDatabaseInformation, dataTable: DataTable, type: StiSqlSourceType): void
Parameters
- information (StiDatabaseInformation)
- report (StiReport)
- informationAll (StiDatabaseInformation)
- dataTable (DataTable)
- type (StiSqlSourceType)
CreateConnector
CreateConnector(connectionString: string): StiDataConnector
Parameters
- connectionString (string)
Returns StiDataConnector
CreateGoogleSheetsConnector
CreateGoogleSheetsConnector(): StiGoogleSheetsConnector
Returns StiGoogleSheetsConnector
Edit
Edit(dictionary: StiDictionary, newDatabase: bool): DialogResult
Parameters
- dictionary (StiDictionary)
- newDatabase (bool)
Returns DialogResult
EditAsync
EditAsync(dictionary: StiDictionary, newDatabase: bool): Task
Parameters
- dictionary (StiDictionary)
- newDatabase (bool)
Returns Task
GetDataAdapter
GetDataAdapter(): StiGoogleSheetsAdapterService
Returns StiGoogleSheetsAdapterService
GetDatabaseInformation
GetDatabaseInformation(report: StiReport): StiDatabaseInformation
Returns full database information.
Parameters
- report (StiReport)
Returns StiDatabaseInformation
GetDatabaseInformationTables
GetDatabaseInformationTables(dataSchema: StiDataSchema): List
Parameters
- dataSchema (StiDataSchema)
Returns List
RegData
RegData(dictionary: StiDictionary, loadData: bool): void
Registers the database in dictionary.
Parameters
- dictionary (StiDictionary) — Dictionary in which is registered database.
- loadData (bool) — Load the data or no.