Class DataBaseProperty
Represents the data base property
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public class DataBaseProperty : ObjectConstructors
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 |