C# Класс CinderellaLauncher.DatabaseIO

Открытые методы

Метод	Описание
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.
ReturnFirstCellInt ( string sqlStatement ) : int
ReturnFirstCellString ( string sqlStatement ) : string
checkConnection ( ) : bool	This method will check for a valid connection string and try opening a new connection.
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.

Метод	Описание
errorCheck ( Exception errorMessage ) : void	Method is used to help centralize and customize database error messages.

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
Результат	bool

Closes the connection if it is open.

public CloseConnection ( ) : void
Результат	void

public DatabaseIO ( ) : System
Результат	System

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.
Результат	int

Creates the SQLConnection object "conn" which is used throughout the rest of the databaseIO methods.

public GetConnection ( ) : SqlConnection
Результат	System.Data.SqlClient.SqlConnection

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
Результат	int

public ReturnFirstCellInt ( string sqlStatement ) : int
sqlStatement	string
Результат	int

public ReturnFirstCellString ( string sqlStatement ) : string
sqlStatement	string
Результат	string

This method will check for a valid connection string and try opening a new connection.

public checkConnection ( ) : bool
Результат	bool

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.
Результат	string

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.
Результат	System.Data.DataSet