clsDataAccess Members
The clsDataAccess type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
|
clsDataAccess()()()() |
Initializes a new instance of the clsDataAccess class.
|
|
|
clsDataAccess(String) |
Connect using the connection string
|
|
|
clsDataAccess(String, Boolean) |
Initializes a new instance of the clsDataAccess class.
|
Methods
| Name | Description | |
|---|---|---|
|
|
addItemsToLogXML |
add items to the log file
|
|
adjustDatesForTimeZone |
Adjusts the dates for time zone.
|
|
|
beginTransaction |
starts the transaction mode
|
|
|
buildSQLServerConnectionString |
Builds the SQL server connection string.
|
|
|
changeDatabase |
Changes the database.
|
|
|
commitTransaction |
commits all the transactions
|
|
|
connect |
Connect using the connection string
|
|
|
createDatabase |
Creates the database.
|
|
|
dataSetToXML |
Convert to dataset to XML.
|
|
|
dataTableToXML |
convert data table to XML
|
|
|
deleteRecord |
delete a given record
|
|
|
Disconnect |
Disconnects the connection from the database
|
|
|
generateTableData |
Generates the table data.
|
|
|
generateTableScripts |
Generates table scripts
|
|
|
getConfigValue |
Get the config value from config table
|
|
|
getConnectionStringPropertiesValues |
Gets the connection string properties values.
|
|
|
GetDataAdapter |
returns a data adapter by executing a sql statement
|
|
|
GetDataset(String, String, String%, OrderedDictionary) |
Gets the data set.
|
|
|
GetDataset(String, OrderedDictionary) |
returns a data set by executing a sql statement
|
|
|
GetDataset(String, OleDbCommand) |
returns a data set by executing a stored procedure
|
|
|
GetDataset(String, SqlCommand) |
Gets the dataset.
|
|
|
GetDataTable(String, String, String%, OrderedDictionary) |
Gets the data table.
|
|
|
GetDataTable(String, OrderedDictionary) |
returns a data table by executing a sql statement
|
|
|
GetDateTimeColumns |
get all datetime columns for a db
|
|
|
getDBColumnNames |
Gets the Data Table Column names
|
|
|
getInsertStatement |
Gets the insert statement.
|
|
|
GetScalarBool(String, OrderedDictionary) |
Gets the scalar int.
|
|
|
GetScalarBool(String, String, String%, OrderedDictionary) |
Gets the scalar bool.
|
|
|
GetScalarInt(String, OrderedDictionary) |
Gets the scalar int value by executing a sql statement
|
|
|
GetScalarInt(String, String, String%, OrderedDictionary) |
Gets the scalar int.
|
|
|
GetScalarLong(String, OrderedDictionary) |
Gets the scalar long value by executing a sql statement
|
|
|
GetScalarLong(String, String, String%, OrderedDictionary) |
Gets the scalar long.
|
|
|
GetScalarString(String, OrderedDictionary) |
Gets the scalar string value by executing a sql statement
|
|
|
GetScalarString(String, String, String%, OrderedDictionary) |
Gets the scalar string.
|
|
|
GetScalarValue(String, OrderedDictionary) |
Gets the scalar value by executing a sql statement
|
|
|
GetScalarValue(String, String, String%, OrderedDictionary) |
Gets the scalar value.
|
|
|
GetSqlDataReader(String) |
returns a data reader from executing a sql statement
|
|
|
GetSqlDataReader(String, OleDbCommand%) |
returns a data reader by executing a stored procedure
|
|
|
getTableColumns |
Gets the list of table columns within a database table.
|
|
|
getTableNamesThatStartWith |
Gets the table names that start with.
|
|
|
getTables |
Gets the list of tables within the database.
|
|
|
hasDatabase |
Determines whether the specified connection string has database.
|
|
|
hasTable |
Determines whether the specified table name has table.
|
|
|
hasTables |
Returns if the db has user tables
|
|
|
insertRecord |
insert a record into the table
|
|
|
isValidSELECTQuery |
Determines whether [is valid select query] [the specified s SQL].
|
|
|
NonQuery(String, String, Int32%, String%, OrderedDictionary) |
Nons the query.
|
|
|
NonQuery(String, String, String%, OrderedDictionary, Int32) |
Nons the query.
|
|
|
NonQuery(String, OrderedDictionary, Int32) |
execute a non-query
|
|
|
NonQuery(String, Int32%, OrderedDictionary, Int32) |
execute a non returning sql statement, insert, update, delete
|
|
|
NonQuery(SqlCommand%) |
execute non query using the sql command
|
|
|
NonQuery(SqlCommand%, Int32%) |
execute non query using sql command
|
|
|
NonQuery(OleDbCommand%) |
execute non query using ole db command
|
|
|
NonQuery(OleDbCommand%, Int32%) |
execute a non returning sql statement, insert, update, delete
|
|
|
NonQuery(String, SqlCommand%) |
execute non query using the stored procedure and sql command object
|
|
|
NonQuery(String, OleDbCommand%) |
execute non query using stored procedure and ole db command
|
|
|
readBinaryData |
Reads the binary data.
|
|
|
rollbackTransaction |
rolls back all the transactions
|
|
|
tableExists |
Table exists
|
|
|
testConnection |
Tests the connection.
|
|
|
updateRecord |
update or insert a record
update record
|
|
|
upsertRecord(String, Hashtable, String) |
Upserts the record.
|
|
|
upsertRecord(String, Hashtable, String, List<(Of <<'(String>)>>), List<(Of <<'(String>)>>)) | |
|
|
writeBinaryData |
Writes the binary data.
|
|
|
writeDBCall(String, String) |
SQL call logging
|
|
|
writeDBCall(String, OrderedDictionary, Stopwatch) |
SQL call logging
|
|
|
writeError |
write the error message to the log file
|
Properties
| Name | Description | |
|---|---|---|
|
commandTimeOut |
Gets or sets the command time out.
|
|
|
connectionString |
returns the connection string
|
|
|
connType |
returns the connection type
|
|
|
database |
returns the name of the database
|
|
|
getDatabaseVersion |
returns the database version
|
|
|
lastError |
return the last error message
|
|
|
serverName |
returns the name of the database server
|
|
|
setFieldNamesToUpper |
get/set the field name upper flag
|