Class DataBaseProperty

Represents the data base property

Inheritance
System.Object
DataBaseProperty
ODBCConnection
OLEDBConnection
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public class DataBaseProperty : Object

Constructors

DataBaseProperty()

Declaration
public DataBaseProperty()

Properties

AlwaysUseConnectionFile

Connection file is always used to establish the connection to the DataSource

Declaration
public bool AlwaysUseConnectionFile { get; set; }
Property Value
Type
System.Boolean

BackgroundQuery

Query table performed Asynchronously

Declaration
public bool BackgroundQuery { get; set; }
Property Value
Type
System.Boolean

CommandText

Represent the command string for the specified data source

Declaration
public object CommandText { get; set; }
Property Value
Type
System.Object

CommandType

Command Type for specified connection

Declaration
public ExcelCommandType CommandType { get; set; }
Property Value
Type
ExcelCommandType

ConnectionString

Define connection information

Declaration
public virtual object ConnectionString { get; set; }
Property Value
Type
System.Object

EnableRefresh

Connection can be refreshed by the user.

Declaration
public bool EnableRefresh { get; set; }
Property Value
Type
System.Boolean

RefreshOnFileOpen

The Query Table is automatically updated when open the workbook

Declaration
public bool RefreshOnFileOpen { get; set; }
Property Value
Type
System.Boolean

RefreshPeriod

Represent the number of minutes between refreshes

Declaration
public int RefreshPeriod { get; set; }
Property Value
Type
System.Int32

SavePassword

Password information saved for ODBC connection

Declaration
public bool SavePassword { get; set; }
Property Value
Type
System.Boolean

ServerCredentialsMethod

Represent the server credential.

Declaration
public ExcelCredentialsMethod ServerCredentialsMethod { get; set; }
Property Value
Type
ExcelCredentialsMethod

SourceDataFile

Represent the source Data File

Declaration
public string SourceDataFile { get; }
Property Value
Type
System.String

Extension Methods