public class DbControl : clsDB, INotifyPropertyChanged| DbControl | |
| DbControl | Initializes a new instance of the DbControl class |
| DbControl(DateTime, TimeSpan, Int32, Int32, Int32, Boolean, String, String, DateTime, String) | Initializes a new instance of the DbControl class |
| ColumnCount |
Reports column count
(Inherited from clsDB) |
| DbBackupClearDays | |
| DbBackupEnabled | |
| DbBackupLastDate | |
| DbBackupLocation | |
| DbBackupPeriod | |
| DbBackupStartDate | |
| DbBackupTime | |
| DbBackupTime24 | |
| DbManualLocation | |
| DbMappedDrive | |
| ErrorMessage |
Used to retrieve internal error messages
(Inherited from clsDB) |
| ID | |
| IsDupe |
Set true when a duplicate record is found on insertion
(Inherited from clsDB) |
| Item |
Generic method for getting values of property by names. Useful when iterating through columns in a record
(Inherited from clsDB) |
| delete |
Delete record
(Inherited from clsDB) |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| fill | |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetColumn |
Finds if specified Column name is in table. Datarows must have already been fetched.
(Inherited from clsDB) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetTableSchema |
Gets a table schema
(Inherited from clsDB) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| insertRecord |
Inserts a new record using instantiated Insert statement
(Inherited from clsDB) |
| load | |
| load(String, String, Boolean) |
Retrieve records from a table using the passes SQL string
(Inherited from clsDB) |
| loadAll |
Retrieve all records in a table
(Inherited from clsDB) |
| loadByPrimaryKey |
Load a record by Primary Key
(Inherited from clsDB) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| OnPropertyChanged | |
| query |
Execute custom query. Used mainly for special deletion scenarios
(Inherited from clsDB) |
| queryWithCount |
Custome query for getting record counts
(Inherited from clsDB) |
| save | Save or Update a record |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| updateRecord |
Updates records using update statement passed with child class instantiation
(Inherited from clsDB) |
| updateRecordSpecial |
Updates records using passed update statement
(Inherited from clsDB) |
| connectionString | (Inherited from clsDB) |
| DataSetName | (Inherited from clsDB) |
| insertStmt | (Inherited from clsDB) |
| loadAllStmt | (Inherited from clsDB) |
| loadStmt | (Inherited from clsDB) |
| LoadStmt | (Inherited from clsDB) |
| localCN | (Inherited from clsDB) |
| localTable | (Inherited from clsDB) |
| m_DbBackupClearDays | |
| m_DbBackupEnabled | |
| m_DbBackupLastDate | |
| m_DbBackupLocation | |
| m_DbBackupPeriod | |
| m_DbBackupStartDate | |
| m_DbBackupTime | |
| m_DbManualLocation | |
| m_DbMappedDrive | |
| m_ID | |
| m_isChanged | |
| priKeyName | (Inherited from clsDB) |
| SQL_COL_DB_BACKUP_CLEAR_DAYS | |
| SQL_COL_DB_BACKUP_ENABLED | |
| SQL_COL_DB_BACKUP_LAST_DATE | |
| SQL_COL_DB_BACKUP_LOCATION | |
| SQL_COL_DB_BACKUP_PERIOD | |
| SQL_COL_DB_BACKUP_START_DATE | |
| SQL_COL_DB_BACKUP_TIME | |
| SQL_COL_DB_MANUAL_LOCATION | |
| SQL_COL_DB_MAPPED_DRIVE | |
| SQL_COL_I_D | |
| SQL_DELETE | (Inherited from clsDB) |
| SQL_INSERT | |
| SQL_LOAD | |
| SQL_LOAD_ALL | |
| SQL_UPDATE | |
| TABLE | |
| updateStmt | (Inherited from clsDB) |