C# Class CinderellaMGS.DatabaseIO

Afficher le fichier Open project: ThomasMoreCollege/CinderellaMGS Class Usage Examples

Méthodes publiques

Свойство Type Description
globConnectionString string

Méthodes publiques

Méthode Description
CheckForRows ( string sqlStatement ) : bool

This method allowed you to determine if an sql statement will return any rows.
CloseConnection ( ) : void

Closes the connection if it is open.
DatabaseIO ( ) : System
ExecuteQuery ( string sqlStatement ) : int

Method will execute a non query SQL statement and return the number of rows affected.
GetConnection ( ) : SqlConnection

Creates the SQLConnection object "conn" which is used throughout the rest of the databaseIO methods.
GetRows ( string sqlStatement ) : int

This method will allow you to determine how many rows will be returned from an sql query.
RetrieveConnectionString ( ) : string

Attempts to read the connection string from the computers registry. If it doesn't exist a new key is created.
checkConnection ( ) : bool

This method will check for a valid connection string and try opening a new connection.
createNewConnection ( ) : string

Creates and returns a connection string key in the computers registry.
getAggDataString ( string sqlComm, string tableName ) : string

Method used when executing an sql query that is retrieving aggregate data.
getDataSet ( string sqlComm, string tableName ) : DataSet

This method will allow you to retrieve a dataset containing the data from the executed query.
setupConnection ( ) : void

Checks for a valid connection string and tries to establish a connection to the database. If the connection fails the user is given an opportunity to enter a new connection string.

Private Methods

Méthode Description
errorCheck ( Exception errorMessage ) : void

Method is used to help centralize and customize database error messages.

Method Details

CheckForRows() public méthode

This method allowed you to determine if an sql statement will return any rows.
public CheckForRows ( string sqlStatement ) : bool
sqlStatement string SQL Query to use
Résultat bool

CloseConnection() public méthode

Closes the connection if it is open.
public CloseConnection ( ) : void
Résultat void

DatabaseIO() public méthode

public DatabaseIO ( ) : System
Résultat System

ExecuteQuery() public méthode

Method will execute a non query SQL statement and return the number of rows affected.
public ExecuteQuery ( string sqlStatement ) : int
sqlStatement string SQL Query to be executed.
Résultat int

GetConnection() public méthode

Creates the SQLConnection object "conn" which is used throughout the rest of the databaseIO methods.
public GetConnection ( ) : SqlConnection
Résultat System.Data.SqlClient.SqlConnection

GetRows() public méthode

This method will allow you to determine how many rows will be returned from an sql query.
public GetRows ( string sqlStatement ) : int
sqlStatement string SQL Query to use
Résultat int

RetrieveConnectionString() public méthode

Attempts to read the connection string from the computers registry. If it doesn't exist a new key is created.
public RetrieveConnectionString ( ) : string
Résultat string

checkConnection() public méthode

This method will check for a valid connection string and try opening a new connection.
public checkConnection ( ) : bool
Résultat bool

createNewConnection() public méthode

Creates and returns a connection string key in the computers registry.
public createNewConnection ( ) : string
Résultat string

getAggDataString() public méthode

Method used when executing an sql query that is retrieving aggregate data.
public getAggDataString ( string sqlComm, string tableName ) : string
sqlComm string SQL Aggregate Query
tableName string The specific table within the dataset.
Résultat string

getDataSet() public méthode

This method will allow you to retrieve a dataset containing the data from the executed query.
public getDataSet ( string sqlComm, string tableName ) : DataSet
sqlComm string The SQL query you are using to retrieve the dataset
tableName string The specific table within the dataset.
Résultat System.Data.DataSet

setupConnection() public méthode

Checks for a valid connection string and tries to establish a connection to the database. If the connection fails the user is given an opportunity to enter a new connection string.
public setupConnection ( ) : void
Résultat void

Property Details

globConnectionString public_oe property

public string globConnectionString
Résultat string