DatabaseTable
Графический объект; таблица, которая работает с данными базы.
Шаблон DatabaseTable
<MyObject Name="" Type="DatabaseTable" Assembly="ComplexControls" ChangeForm="">
<!--Тэги, общие для всех графических объектов-->
<Top></Top>
<Left></Left>
<Height></Height>
<Width></Width>
<FontStyle></FontStyle>
<ForeColor></ForeColor>
<BackColor></BackColor>
<Enabled></Enabled>
<Visible></Visible>
<Hint></Hint>
<Change User="" Source="" ValueSet="" />
<!--Тэги, специфичные для DatabaseTable-->
<RowHeight Value="" />
<ColumnHeadersHeight Value="" />
<ColumnHeadersVisible Value="" />
<RowHeadersWidth Value="" />
<RowHeadersVisible Value="" />
<BackgroundColor Value="" />
<BorderStyle Value="" />
<CellBorderStyle Value="" />
<HideSelection Value="" />
<SelectionColor Name="" FadingRatio="" />
<AllowInsert></AllowInsert>
<AllowUpdate></AllowUpdate>
<AllowDelete></AllowDelete>
<MultiSelect Value="" />
<ScrollBars Value="" />
<SelectionMode Value="" />
<EditMode Value="" />
<AllowResizeColumns Value="" />
<AllowOrderColumns Value="" />
<AllowResizeRows Value="" />
<AutoSizeRowsMode Value="" />
<AutoSizeColumnsMode Value="" />
<AllowFilterColumns Value="" />
<ColumnHeadersHeightSizeMode Value="" />
<ColumnHeadersAlignment Value="" />
<ShowCellHints Value="" />
<ContextMenu Name="" MultiSelection="" />
<ColumnContextMenuBackColor Name="" />
<ColumnContextMenuForeColor Name="" />
<Formatting>
<BackColor Name="">
<Columns>
<Column Name="" />
<Column Name="" />
</Columns>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</BackColor>
<BackColor>
<Color></Color>
<Columns>
<Column Name="" />
<Column Name="" />
</Columns>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</BackColor>
<BackColor>
<ColorFromColumnValue></ColorFromColumnValue>
<Columns>
<Column Name="" />
<Column Name="" />
</Columns>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</BackColor>
<ForeColor Name="">
<Columns>
<Column Name="" />
<Column Name="" />
</Columns>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</ForeColor>
<ForeColor>
<Color></Color>
<Columns>
<Column Name="" />
<Column Name="" />
</Columns>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</ForeColor>
<ForeColor>
<ColorFromColumnValue></ColorFromColumnValue>
<Columns>
<Column Name="" />
<Column Name="" />
</Columns>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</ForeColor>
<FontStyle Name="">
<Columns>
<Column Name="" />
<Column Name="" />
</Columns>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</FontStyle>
<Alignment>
<Value></Value>
<Columns>
<Column Name="" />
</Columns>
<Expression></Expression>
</Alignment>
<Alignment Value="">
<Columns>
<Column Name="" />
</Columns>
<Expression></Expression>
</Alignment>
</Formatting>
<SourceDataConnection Name="" Query=""/>
<SaveOnFormClose Columns="" />
<Columns>
<Column Name="" Type="DatabaseTableColumnTextBox" Assembly="DatabaseTableColumnControls" >
<Title></Title>
<Width></Width>
<DisplayIndex></DisplayIndex>
<Frozen Value="" />
<WrapMode Value="" />
<ReadOnly></ReadOnly>
<AllowSort Value="" />
<Alignment Value="" />
<HeaderAlignment Value="" />
<AutoSizeMode Value="" />
<HeaderBackColor></HeaderBackColor>
<BackColor></BackColor>
<ForeColor></ForeColor>
<Visible></Visible>
<Hint></Hint>
<DataType DataType="" />
<Substitution SourceColumn="">
<DataConnection SourceDataConnection="">
<Fields>
<Field Name="" />
<Field Name="" />
</Fields>
</DataConnection>
</Substitution>
<Sorting>
<SortOrder Type="" />
<ColumnOrder Order="" />
</Sorting>
<Filter AutoFill="" FilterNullValue=""></Filter>
<DefaultNewRowValue></DefaultNewRowValue>
<AutoFill Type="" />
<Calculate>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</Calculate>
<ManagementMode></ManagementMode>
</Column>
<Column Name="" Type="DatabaseTableColumnComboBox" Assembly="DatabaseTableColumnControls" >
<Title></Title>
<Width></Width>
<DisplayIndex></DisplayIndex>
<Frozen Value="" />
<WrapMode Value="" />
<ReadOnly></ReadOnly>
<AllowSort Value="" />
<Alignment Value="" />
<HeaderAlignment Value="" />
<AutoSizeMode Value="" />
<HeaderBackColor></HeaderBackColor>
<BackColor></BackColor>
<ForeColor></ForeColor>
<Visible></Visible>
<Hint></Hint>
<DataType DataType="" />
<Substitution SourceColumn="">
<DataConnection SourceDataConnection="">
<Fields>
<Field Name="" />
<Field Name="" />
</Fields>
</DataConnection>
</Substitution>
<Sorting>
<SortOrder Type="" />
<ColumnOrder Order="" />
</Sorting>
<Filter AutoFill="" FilterNullValue=""></Filter>
<DefaultNewRowValue></DefaultNewRowValue>
<AutoFill Type="" />
<Calculate>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</Calculate>
<Sorted Value="" />
<ValueList></ValueList>
<ManagementMode></ManagementMode>
</Column>
<Column Name="" Type="DatabaseTableColumnCheckBox" Assembly="DatabaseTableColumnControls" >
<Title></Title>
<Width></Width>
<DisplayIndex></DisplayIndex>
<Frozen Value="" />
<WrapMode Value="" />
<ReadOnly></ReadOnly>
<AllowSort Value="" />
<Alignment Value="" />
<HeaderAlignment Value="" />
<AutoSizeMode Value="" />
<HeaderBackColor></HeaderBackColor>
<BackColor></BackColor>
<ForeColor></ForeColor>
<Visible></Visible>
<Hint></Hint>
<DataType DataType="" />
<Substitution SourceColumn="">
<DataConnection SourceDataConnection="">
<Fields>
<Field Name="" />
<Field Name="" />
</Fields>
</DataConnection>
</Substitution>
<Sorting>
<SortOrder Type="" />
<ColumnOrder Order="" />
</Sorting>
<Filter AutoFill="" FilterNullValue=""></Filter>
<DefaultNewRowValue></DefaultNewRowValue>
<AutoFill Type="" />
<Calculate>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</Calculate>
<ThreeState Value="" />
<HeaderCheckAll Value="" />
<ManagementMode></ManagementMode>
</Column>
<Column Name="" Type="DatabaseTableColumnDateTimePicker" Assembly="DatabaseTableColumnControls" >
<Title></Title>
<Width></Width>
<DisplayIndex></DisplayIndex>
<Frozen Value="" />
<WrapMode Value="" />
<ReadOnly></ReadOnly>
<AllowSort Value="" />
<Alignment Value="" />
<HeaderAlignment Value="" />
<AutoSizeMode Value="" />
<HeaderBackColor></HeaderBackColor>
<BackColor></BackColor>
<ForeColor></ForeColor>
<Visible></Visible>
<Hint></Hint>
<DataType DataType="" />
<Substitution SourceColumn="">
<DataConnection SourceDataConnection="">
<Fields>
<Field Name="" />
<Field Name="" />
</Fields>
</DataConnection>
</Substitution>
<Sorting>
<SortOrder Type="" />
<ColumnOrder Order="" />
</Sorting>
<Filter AutoFill="" FilterNullValue=""></Filter>
<DefaultNewRowValue></DefaultNewRowValue>
<AutoFill Type="" />
<Calculate>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</Calculate>
<Format Value="" />
<NullValue Show="" />
<ManagementMode></ManagementMode>
</Column>
<Column Name="" Type="DatabaseTableColumnNumericBox" Assembly="DatabaseTableColumnControls" >
<Title></Title>
<Width></Width>
<DisplayIndex></DisplayIndex>
<Frozen Value="" />
<WrapMode Value="" />
<ReadOnly></ReadOnly>
<AllowSort Value="" />
<Alignment Value="" />
<HeaderAlignment Value="" />
<AutoSizeMode Value="" />
<HeaderBackColor></HeaderBackColor>
<BackColor></BackColor>
<ForeColor></ForeColor>
<Visible></Visible>
<Hint></Hint>
<DataType DataType="" />
<Substitution SourceColumn="">
<DataConnection SourceDataConnection="">
<Fields>
<Field Name="" />
<Field Name="" />
</Fields>
</DataConnection>
</Substitution>
<Sorting>
<SortOrder Type="" />
<ColumnOrder Order="" />
</Sorting>
<Filter AutoFill="" FilterNullValue=""></Filter>
<DefaultNewRowValue></DefaultNewRowValue>
<AutoFill Type="" />
<Calculate>
<Expression></Expression>
<Items>
<Item></Item>
<Item></Item>
</Items>
</Calculate>
<Increment Value="" />
<Maximum Value="" />
<Minimum Value="" />
<DecimalPlaces Value="" />
<ThousandsSeparator Value="" />
<ManagementMode></ManagementMode>
</Column>
</Columns>
</MyObject>Описание DatabaseTable
Тэги, общие для всех графических объектов
Width
ContextMenu
Атрибуты тэга <ContextMenu>
<ContextMenu>Тэги, специфичные для DatabaseTable
RowHeight
Атрибуты тэга <RowHeight>
<RowHeight>ColumnHeadersHeight
Атрибуты тэга <ColumnHeadersHeight>
<ColumnHeadersHeight>ColumnHeadersVisible
Атрибуты тэга <ColumnHeadersVisible>
<ColumnHeadersVisible>RowHeadersWidth
Атрибуты тэга <RowHeadersWidth>
<RowHeadersWidth>RowHeadersVisible
Атрибуты тэга <RowHeadersVisible>
<RowHeadersVisible>BackgroundColor
Атрибуты тэга <BackgroundColor>
<BackgroundColor>BorderStyle
Атрибуты тэга <BorderStyle>
<BorderStyle>Типы границ таблицы
CellBorderStyle
Атрибуты тэга <CellBorderStyle>
<CellBorderStyle>Стили границ ячеек
HideSelection
Атрибуты тэга <HideSelection>
<HideSelection>SelectionColor
Атрибуты тэга <SelectionColor>
<SelectionColor>AllowInsert
AllowUpdate
AllowDelete
MultiSelect
Атрибуты тэга <MultiSelect>
<MultiSelect>ScrollBars
Атрибуты тэга <ScrollBars>
<ScrollBars>Типы полос прокрутки
SelectionMode
Атрибуты тэга <SelectionMode>
<SelectionMode>Типы выделения таблицы
BeginEditOnCellEnter
EditMode
AllowResizeColumns
Атрибуты тэга <AllowResizeColumns>
<AllowResizeColumns>AllowOrderColumns
Атрибуты тэга <AllowOrderColumns>
<AllowOrderColumns>AllowResizeRows
Атрибуты тэга <AllowResizeRows>
<AllowResizeRows>AutoSizeRowsMode
Атрибуты тэга <AutoSizeRowsMode>
<AutoSizeRowsMode>Типы автоматического изменения высоты строк таблицы
AutoSizeColumnsMode
Атрибуты тэга <AutoSizeColumnsMode>
<AutoSizeColumnsMode>Типы автоматического изменения ширины столбцов таблицы
AllowFilterColumns
Атрибуты тэга <AllowFilterColumns>
<AllowFilterColumns>ColumnHeadersHeightSizeMode
Атрибуты тэга <ColumnHeadersHeightSizeMode>
<ColumnHeadersHeightSizeMode>Типы возможности изменения высоты шапки таблицы
ColumnHeadersAlignment
Атрибуты тэга <ColumnHeadersAlignment>
<ColumnHeadersAlignment>Типы положения содержимого ячейки столбца таблицы
ShowCellHints
трибуты тэга <ShowCellHints>
<ShowCellHints>ColumnContextMenuBackColor
Атрибуты тэга <ColumnContextMenuBackColor>
<ColumnContextMenuBackColor>ColumnContextMenuForeColor
Атрибуты тэга <ColumnContextMenuForeColor>
<ColumnContextMenuForeColor>ColumnContextMenuWiden
ShowExportToExcel
Formatting
SourceDataConnection
Атрибуты тэга <SourceDataConnection>
<SourceDataConnection>SaveOnFormClose
Атрибуты тэга <SaveOnFormClose>
<SaveOnFormClose>Columns
Атрибуты столбцов DatabaseTable
Get-проперти для получения свойств
RowHeight
ColumnHeadersHeight
ColumnHeadersVisible
RowHeadersWidth
RowHeadersVisible
BackgroundColor
BorderStyle
CellBorderStyle
HideSelection
AllowInsert
AllowUpdate
AllowDelete
MultiSelect
SelectionMode
EditMode
AllowResizeColumns
AllowOrderColumns
AllowResizeRows
AutoSizeRowsMode
Column
ColumnUniqueValues
ColumnTitle
ColumnHint
ColumnLeft
ColumnOffset
ColumnVisible
ColumnDisplayIndex
ColumnWidth
ColumnSum
ColumnHeaderCheckBoxState
CountingSumMultiply
CountingSignSumMultiply
SelectedRowIndex
SelectedRowsIndices
SelectedColumnName
SelectedCellValue
SelectedRowsCount
SelectedCellsSumByColumnName
SelectedRowCellValueByColumnName
SelectedRowsCellValuesByColumnName
RowsCount
RowIndexOf
RowsIndicesOf
ValueByAnotherFieldValue
Data
ArrayData
DictionaryArrayData
FilteredColumnValues
RowAdded
SortedColumn
SortDirection
Направления сортировки столбца
VerticalScrollOffset
HorizontalScrollOffset
LastCellClickedRowIndex
LastCellClickedColumnName
LastCellDoubleClickedRowIndex
LastCellDoubleClickedColumnName
LastCellValueChangedRowIndex
LastCellValueChangedColumnName
CellValue
ColumnMinimumWidth
Set-проперти для динамического задания свойств
RowHeight
ColumnHeadersHeight
ColumnHeadersVisible
RowHeadersWidth
RowHeadersVisible
BackgroundColor
BorderStyle
CellBorderStyle
HideSelection
AllowInsert
AllowUpdate
AllowDelete
MultiSelect
SelectionMode
EditMode
AllowResizeColumns
AllowOrderColumns
AllowResizeRows
AutoSizeRowsMode
ColumnTitle
ColumnHint
ColumnDisplayIndex
ColumnWidth
SelectedRowIndex
SelectedRowsIndices
SelectedColumnName
SelectedCellValue
SelectCell
SelectRowByFieldValue
SelectRowsByFieldValue
AutoSize
AddRow
AddRows
UpdateRow
UpdateRows
UpdateColumn
UpdateColumnCellsValues
DeleteRowsByIndices
ColumnMinimumWidth
ClearSelection
ResetFilter
Last updated