Class DBConnection
Namespace: Aspose.Cells.ExternalConnections
Assembly: Aspose.Cells.dll (25.2.0)
Specifies all properties associated with an ODBC or OLE DB external data connection.
public class DBConnection : ExternalConnectionInheritance
object ← ExternalConnection ← DBConnection
Inherited Members
ExternalConnection.Id, ExternalConnection.ClassType, ExternalConnection.PowerQueryFormula, ExternalConnection.SourceType, ExternalConnection.SSOId, ExternalConnection.SavePassword, ExternalConnection.SaveData, ExternalConnection.RefreshOnLoad, ExternalConnection.ReconnectionMethodType, ExternalConnection.OnlyUseConnectionFile, ExternalConnection.OdcFile, ExternalConnection.SourceFile, ExternalConnection.ConnectionFile, ExternalConnection.IsNew, ExternalConnection.Name, ExternalConnection.KeepAlive, ExternalConnection.RefreshInternal, ExternalConnection.ConnectionDescription, ExternalConnection.IsDeleted, ExternalConnection.CredentialsMethodType, ExternalConnection.BackgroundRefresh, ExternalConnection.Parameters, ExternalConnection.Command, ExternalConnection.CommandType, ExternalConnection.ConnectionString, ExternalConnection.SecondCommand, object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Properties
ClassType
Gets the type of this Aspose.Cells.ExternalConnections.ExternalConnection object.
public override ExternalConnectionClassType ClassType { get; }Property Value
Command
The string containing the database command to pass to the data provider API that will interact with the external source in order to retrieve data
public override string Command { get; set; }Property Value
CommandType
Specifies the OLE DB command type.
- Query specifies a cube name
- Query specifies a SQL statement
- Query specifies a table name
- Query specifies that default information has been given, and it is up to the provider how to interpret.
- Query is against a web based List Data Provider.
public override OLEDBCommandType CommandType { get; set; }Property Value
ConnectionString
The connection information string is used to make contact with an OLE DB or ODBC data source.
public override string ConnectionString { get; set; }Property Value
PowerQueryFormula
Gets the definition of power query formula.
public override PowerQueryFormula PowerQueryFormula { get; }Property Value
SecondCommand
Specifies a second command text string that is persisted when PivotTable server-based page fields are in use. For ODBC connections, serverCommand is usually a broader query than command (no WHERE clause is present in the former). Based on these 2 commands(Command and ServerCommand), parameter UI can be populated and parameterized queries can be constructed
public override string SecondCommand { get; set; }