C# 클래스 CinderellaMGS.DatabaseIO

파일 보기 프로젝트 열기: ThomasMoreCollege/CinderellaMGS 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
globConnectionString	string

공개 메소드들

메소드	설명
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.

비공개 메소드들

메소드	설명
errorCheck ( Exception errorMessage ) : void	Method is used to help centralize and customize database error messages.

메소드 상세

CheckForRows() 공개 메소드

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

CloseConnection() 공개 메소드

Closes the connection if it is open.

public CloseConnection ( ) : void
리턴	void

DatabaseIO() 공개 메소드

public DatabaseIO ( ) : System
리턴	System

ExecuteQuery() 공개 메소드

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

GetConnection() 공개 메소드

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

public GetConnection ( ) : SqlConnection
리턴	System.Data.SqlClient.SqlConnection

GetRows() 공개 메소드

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

RetrieveConnectionString() 공개 메소드

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

public RetrieveConnectionString ( ) : string
리턴	string

checkConnection() 공개 메소드

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

public checkConnection ( ) : bool
리턴	bool

createNewConnection() 공개 메소드

Creates and returns a connection string key in the computers registry.

public createNewConnection ( ) : string
리턴	string

getAggDataString() 공개 메소드

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

getDataSet() 공개 메소드

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

setupConnection() 공개 메소드

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
리턴	void

프로퍼티 상세

globConnectionString 공개적으로 프로퍼티

public string globConnectionString
리턴	string