DBSheetConfig Class
Helper module for easier manipulation of DBSheet definition
Inheritance Hierarchy
- System.Object
- DBaddin.DBSheetConfig
Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)
Syntax
public sealed class DBSheetConfig
The DBSheetConfig type exposes the following members.
Methods
| Name | Summary | |
|---|---|---|
 | createDBSheet(String) | create a DBSheet by creating lookups (with dblistfetch) and a dbsetquery that acts as a list-object for a CUD DBMapper. Called by clickAssignDBSheet (Ribbon) and assignDBSheet_Click (DBSheetCreateForm) |
 | finishDBMapperCreation() | after creating lookups and setting the dbsetquery finish the list-object area with reverse lookups and drop-downs |
| getEntry(String, String, ref Int32) | fetches value in entryMarkup within XMLString, search starts optionally at position startSearch (default 1) |
| getEntryList(String, String, String, String, Boolean) | fetches entryMarkup parts contained within lists denoted by listMarkup within parentMarkup inside XMLString |
| setEntry(String, String) | creates markup with setting value content in entryMarkup, used in DBSheetCreateForm.xmlDbsheetConfig |
Fields
| Name | Description | |
|---|---|---|
 | addedCells | counter to know how many cells we filled for the db-mapper query (at least 2: dbsetquery function and query string, if an additional where clause exists, add one for this where clause and then one for each parameter) |
 | clipboardDataRow | public clipboard row for DBSheet definition rows (foreign lookup info) |
| createdListObject | the list object of the main query for the db mapper |
| curCell | the current cell where the DBSheet Definition is inserted at |
| curConfig | the complete db-sheet configuration (XML) |
| databaseName | the database name |
| existingName | if an existing DBSheet is overwritten, this is set to the existing DBModifier Name |
| existingPwd | for DBSheetCreateForm, store the password once so we don't have to enter it again... |
| lookupsList | the lookups list of the DBSheet definition (xml element with query, name, etc.) |
| lookupWS | the added and hidden worksheet with lookups inside |
| specialNonNullableChar | these three need to be global, so that finishDBMapperCreation also knows about them |
| tableName | the Database table name of the DBSheet |
| tblPlaceHolder | these three need to be global, so that finishDBMapperCreation also knows about them |
| whereClauseStart | these three need to be global, so that finishDBMapperCreation also knows about them |