| Name | Description | |
|---|---|---|
 | C1ExpressTable Constructor | Initializes a new instance of the C1ExpressTable class. |
The following tables list the members exposed by C1ExpressTable.
Public Constructors
Public Properties
| Name | Description | |
|---|---|---|
 | AllowAddNew | Gets or sets a value indicating whether adding new rows to this table is allowed. |
| AllowDelete | Gets or sets a value indicating whether deleting rows from this table is allowed. |
| ConnectionComponent | Gets or sets the C1ExpressConnection component this table is attached to. |
| ConnectionString | Gets or sets the connection string used to connect to the database. |
| ConnectionTimeout | Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error. |
| ConnectionType | Gets or sets the type of database connection, either via OLE DB or using one of the native database access options. |
| Container | (Inherited from System.ComponentModel.Component) |
| Count | (Inherited from C1.Data.BaseDataTableSource) |
| CurrentRow | Gets the C1.Data.C1DataRow object representing the current row. (Inherited from C1.Data.BaseDataTableSource) |
| DataAccessMode | Gets or sets a DataAccessModeEnum value specifying static (everything fetch into memory) or virtual (fetch by segments, for a large data set) mode of operation. |
| DataAdapter | Returns or sets the IDBDataAdapter component used to fill and update the table with non-empty SelectCommandText. |
| Database | Gets the name of the current database or the database to be used once a connection is open. |
| DataSource | Gets the location and file name of the data source. |
| DataTable | Gets the source C1.Data.C1DataTable containing the data. (Inherited from C1.Data.BaseDataTableSource) |
| DbTableName | Gets or sets the name of the database table. |
| ExpressConnection | Gets the C1ExpressConnection component for this table. |
| Fields | The collection of C1ExpressTable fields. |
| FillFilter | Gets or sets the filter criteria for filling the table with data. |
| FillOnRequest | Gets or sets a value indicating whether the data set will be automatically filled with data when a data bound control requests data from it. |
| FillSort | Gets or sets the sort field or fields, and sort order for filling the table with data. |
| Position | Gets or sets the current row position for controls bound to this component. (Inherited from C1.Data.BaseDataSourceComponent) |
| Provider | Gets the name of the OLE DB provider. |
| ReadOnly | Gets or sets a value indicating whether changes to the rows of this table are allowed. |
| SelectCommandText | Gets or sets the command text (SQL statement or stored procedure) for fetching data from the database. |
| SelectCommandType | Determines how to interpret SelectCommandText property. |
| TableName | Gets or sets the name of the table as it appears to data bound controls. |
| UpdateLeavingRow | Gets or sets a value indicating whether modified rows are immediately updated to the database when the end user leaves the row. (Inherited from C1.Data.BaseDataTableSource) |
| UserReadOnly | Gets or sets a value indicating whether modifying table data in bould controls is allowed. |
Public Methods
| Name | Description | |
|---|---|---|
 | CreateObjRef | (Inherited from System.MarshalByRefObject) |
| Dispose | (Inherited from System.ComponentModel.Component) |
| GetLifetimeService | (Inherited from System.MarshalByRefObject) |
| InitializeLifetimeService | (Inherited from System.MarshalByRefObject) |
| MoveFirst | Moves to the first row. (Inherited from C1.Data.BaseDataTableSource) |
| MoveLast | Moves to the last row. (Inherited from C1.Data.BaseDataTableSource) |
| MoveNext | Moves to the next row. (Inherited from C1.Data.BaseDataTableSource) |
| MovePrevious | Moves to the previous row. (Inherited from C1.Data.BaseDataTableSource) |
| Seek | Seeks a row by its primary key values. (Inherited from C1.Data.BaseDataTableSource) |
| ToString | (Inherited from System.ComponentModel.Component) |
Public Events
| Name | Description | |
|---|---|---|
 | AfterAddNew | Fired after a new (empty) row is added. (Inherited from C1.Data.BaseDataTableSource) |
| AfterBeginEdit | Fired when the user starts editing a row, after the row enters edit mode. (Inherited from C1.Data.BaseDataTableSource) |
| AfterCancelEdit | Fired when the user cancels editing a row, after reverting the changes made to the row. (Inherited from C1.Data.BaseDataTableSource) |
| AfterChanges | Fired when all changes initiated by a field change are done and handled by the business logic code. (Inherited from C1.Data.BaseDataTableSource) |
| AfterDelete | Fired after a row has been deleted. (Inherited from C1.Data.BaseDataTableSource) |
| AfterEndAddNew | Fired after a newly added row becomes a regular row in the rowset, that is, when its primary key and other required (AllowDbNull=false) fields are specified. (Inherited from C1.Data.BaseDataTableSource) |
| AfterEndEdit | Fired when the user finishes editing a row, after the row leaves edit mode. (Inherited from C1.Data.BaseDataTableSource) |
| AfterFieldChange | Fired after a field value is set. (Inherited from C1.Data.BaseDataTableSource) |
| AfterFill | Fired after the table has been filled with data. |
| AfterFirstChange | Fired after first change is made to a row (a field value changes) after the row last entered edit mode. (Inherited from C1.Data.BaseDataTableSource) |
| AfterGenerateSql | Fired after generating the SQL SELECT statement for fetching table data from the database. |
| AfterUpdateRow | Fired after modifications made to a row are committed to the database. |
| AsyncFetchComplete | Fired in TableView.DataAccessMode = VirtualAutomatic, when all rows are fetched. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeAddNew | Fired before a new (empty) row is added. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeBeginEdit | Fired when the user starts editing a row, before the row enters edit mode. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeCancelEdit | Fired when the user cancels editing a row, before reverting the changes made to the row. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeDelete | Fired before a row is deleted. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeEndAddNew | Fired before a newly added row becomes a regular row in the rowset, that is, when its primary key and other required (AllowDbNull=false) fields are specified. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeEndEdit | Fired when the user finishes editing a row, before the row leaves edit mode. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeFieldChange | Fired before a field value is set. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeFill | Fired before the table is filled with data. |
| BeforeFirstChange | Fired before first change is made to a row (a field value changes) after the row last entered edit mode. (Inherited from C1.Data.BaseDataTableSource) |
| BeforeGenerateSql | Fired before generating the SQL SELECT statement for fetching table data from the database. |
| BeforeUpdateRow | Fired before modifications made to a row are committed to the database. |
| CurrentRowChanged | Fired when there are changes in the current row, whatever their cause, resulting from field change, current row change or complete data refresh. (Inherited from C1.Data.BaseDataSourceComponent) |
| Disposed | (Inherited from System.ComponentModel.Component) |
| PositionChanged | Fired when controls bound to this component change their current row position. (Inherited from C1.Data.BaseDataSourceComponent) |
| UpdateError | Fired when errors occur in an attempt to update the database when the end user leaves a modified row. |
See Also