StoredQueries Class

Definition

Namespace: MbcsCentral
Assembly: MbcsCentral (in MbcsCentral.exe) Version: 2.0.1.15 (2.0.1.15)
C#
public class StoredQueries : clsDB, 
	INotifyPropertyChanged
Inheritance
Object    clsDB    StoredQueries
Implements
INotifyPropertyChanged

Constructors

StoredQueries 
StoredQueriesInitializes a new instance of the StoredQueries class
StoredQueries(Int32, String, String, String)Initializes a new instance of the StoredQueries class

Properties

ColumnCount Reports column count
(Inherited from clsDB)
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)
Name 
Parameters 
Query 

Methods

delete Delete record
(Inherited from clsDB)
EqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
fill 
FinalizeAllows 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)
GetHashCodeServes as the default hash function.
(Inherited from Object)
GetTableSchema Gets a table schema
(Inherited from clsDB)
GetTypeGets the Type of the current instance.
(Inherited from Object)
insertRecord Inserts a new record using instantiated Insert statement
(Inherited from clsDB)
load 
load(Int32) 
load(String) 
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)
MemberwiseCloneCreates 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 
ToStringReturns 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)

Events

Fields

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_ID 
m_isChanged 
m_Name 
m_Parameters 
m_Query 
priKeyName
(Inherited from clsDB)
SQL_COL_I_D 
SQL_COL_NAME 
SQL_COL_PARAMETERS 
SQL_COL_QUERY 
SQL_DELETE
(Inherited from clsDB)
SQL_INSERT 
SQL_LOAD 
SQL_LOAD_ALL 
SQL_LOAD_BY_NAME 
SQL_UPDATE 
TABLE 
updateStmt
(Inherited from clsDB)

See Also