• DR-IT Software
  • Products
  • Documentation
  • Product page
  • Examples
  • API reference
  • Support
Show / Hide Table of Contents

Class QueryTable

Represents a query table that connects to external data.

Inheritance
object
QueryTable
Inherited Members
object.ToString()
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
Namespace: DRIT.Spreadsheet.Data
Assembly: DRIT.Spreadsheet.dll
Syntax
public class QueryTable

Constructors

QueryTable()

Initializes a new instance of the QueryTable class.

Declaration
public QueryTable()

QueryTable(string, DataConnection)

Initializes a new instance of the QueryTable class with a name and connection.

Declaration
public QueryTable(string name, DataConnection connection)
Parameters
Type Name Description
string name

The name of the query table.

DataConnection connection

The data connection.

Properties

AdjustColumnWidth

Gets or sets whether to adjust column width.

Declaration
public bool AdjustColumnWidth { get; set; }
Property Value
Type Description
bool

BackgroundRefresh

Gets or sets whether to refresh in the background.

Declaration
public bool BackgroundRefresh { get; set; }
Property Value
Type Description
bool

Connection

Specifies the data connection for the query table.

Declaration
public DataConnection Connection { get; set; }
Property Value
Type Description
DataConnection

DisableEdit

Gets or sets whether editing is disabled.

Declaration
public bool DisableEdit { get; set; }
Property Value
Type Description
bool

FillFormulas

Gets or sets whether to fill formulas.

Declaration
public bool FillFormulas { get; set; }
Property Value
Type Description
bool

FirstBackgroundRefresh

Gets or sets whether this is the first background refresh.

Declaration
public bool FirstBackgroundRefresh { get; set; }
Property Value
Type Description
bool

GrowShrinkType

Specifies the grow/shrink type for the query table.

Declaration
public GrowShrinkType GrowShrinkType { get; set; }
Property Value
Type Description
GrowShrinkType

Headers

Gets or sets whether the first row of the query table contains headers.

Declaration
public bool Headers { get; set; }
Property Value
Type Description
bool

Intermediate

Gets or sets whether this is an intermediate query table.

Declaration
public bool Intermediate { get; set; }
Property Value
Type Description
bool

Name

Specifies the name of the query table.

Declaration
public string Name { get; set; }
Property Value
Type Description
string

PreserveFormatting

Gets or sets whether to preserve formatting.

Declaration
public bool PreserveFormatting { get; set; }
Property Value
Type Description
bool

Refresh

Gets the refresh settings for the query table.

Declaration
public QueryTableRefresh Refresh { get; }
Property Value
Type Description
QueryTableRefresh

RefreshDisabled

Gets or sets whether refresh is disabled.

Declaration
public bool RefreshDisabled { get; set; }
Property Value
Type Description
bool

RefreshOnLoad

Gets or sets whether to refresh on load.

Declaration
public bool RefreshOnLoad { get; set; }
Property Value
Type Description
bool

RemoveDataOnSave

Gets or sets whether to remove data on save.

Declaration
public bool RemoveDataOnSave { get; set; }
Property Value
Type Description
bool

RowNumbers

Gets or sets whether to show row numbers.

Declaration
public bool RowNumbers { get; set; }
Property Value
Type Description
bool
Back to top

DR-IT Software documentation

DR-IT Software · Products · Documentation index · Product page · Downloads · Support · Licensing

Generated by DocFX