C# Class DataAccessModule.DAConnect

Public Methods

Method	Description
ExecuteCmd ( string P_cmd, ParmList P_parmList ) : void	This method will take in a stored procedure call and return a SqlDataReader
ExecuteStoredProc ( string P_storedProcedureCall ) : void	This method will execute a command in the database. This can be any command that the database can execute, select, insert, update, exec, etc.
GetConnectionString ( ) : string
ReturnSQLDataReader ( string P_cmd, ParmList P_parmList ) : DataTable	This method will take in a stored procedure call and return a SqlDataReader
SetupConnectionString ( string P_ConnectionStr ) : void	This is the conncetion string for an Integrated Security connection
SetupConnectionString ( string P_server, string P_database ) : void	This is the conncetion string for an Integrated Security connection
SetupConnectionString ( string P_user, string P_password, string P_server, string P_database ) : void	This method will get the connection information and store it for later use.

This method will take in a stored procedure call and return a SqlDataReader

public ExecuteCmd ( string P_cmd, ParmList P_parmList ) : void
P_cmd	string	/// Stored Procedure to execute ///
P_parmList	ParmList	/// List of parameters ///
return	void

This method will execute a command in the database. This can be any command that the database can execute, select, insert, update, exec, etc.

public ExecuteStoredProc ( string P_storedProcedureCall ) : void
P_storedProcedureCall	string	/// Command to execute ///
return	void

public abstract GetConnectionString ( ) : string
return	string

This method will take in a stored procedure call and return a SqlDataReader

public ReturnSQLDataReader ( string P_cmd, ParmList P_parmList ) : DataTable
P_cmd	string	/// Stored Procedure to execute ///
P_parmList	ParmList	/// List of parameters ///
return	System.Data.DataTable

This is the conncetion string for an Integrated Security connection

public abstract SetupConnectionString ( string P_ConnectionStr ) : void
P_ConnectionStr	string	/// Connection String ///
return	void

This is the conncetion string for an Integrated Security connection

public abstract SetupConnectionString ( string P_server, string P_database ) : void
P_server	string	/// Name of the server ///
P_database	string	/// name of database ///
return	void

This method will get the connection information and store it for later use.

public abstract SetupConnectionString ( string P_user, string P_password, string P_server, string P_database ) : void
P_user	string	/// User name used to connect to the database ///
P_password	string	/// Password to connect to the database with ///
P_server	string	/// Name of the server where the database is ///
P_database	string	/// Name of the database to use when connected ///
return	void