menu

Document Processing

DataBaseProperty Class - C# Excel Library API Reference | Syncfusion

    Show / Hide Table of Contents

    DataBaseProperty Class

    Represents the data base property

    Inheritance
    System.Object
    DataBaseProperty
    ODBCConnection
    OLEDBConnection
    Namespace: Syncfusion.XlsIO.Implementation
    Assembly: Syncfusion.XlsIO.Base.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
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved