• 홈
• EmTrac2SF
• DBAccess

C# 클래스 EmTrac2SF.DBAccess

파일 보기 프로젝트 열기: fmendes/SalesForceCSharpAPI

공개 프로퍼티들

프로퍼티	타입	설명
Cache	System.Web.Caching.Cache
ErrorLabel	System.Web.UI.WebControls.Label
ErrorMessage	string
MainDB	string
iConnectionRetries	int
objConn	System.Data.SqlClient.SqlConnection
objIsolationLevel	IsolationLevel
objLastUpdateRow	System.Data.DataRow
objSync	object
strLogFlag	string
strPath	string

공개 메소드들

메소드	설명
Dispose ( ) : void
GetConnection ( ) : SqlConnection	Creates a SqlConnection using the Default Connection String
GetConnection ( string strName ) : SqlConnection	Creates a SqlConnection using the given Connection String
GetConnectionRef ( string strName ) : SqlConnection
GetConnectionString ( ) : string
GetConnectionString ( string strName ) : string
GetDataSetFromSQL ( string strSQL ) : DataSet
GetDataTableFromSQL ( string strSQL ) : DataTable
GetDataTableFromSQLFile ( string strFileName, string strPrependScript = null, string strCondition = null ) : DataTable
GetIntegerFromSQL ( string strSQL ) : int
GetSQLFromFile ( string strFile ) : string
GetSqlDataReaderFromSQL ( string strSQL ) : System.Data.SqlClient.SqlDataReader
GetStringFromSQL ( string strSQL ) : string
ReplaceApostrophes ( string strValue ) : string
ReportError ( string strErrorMsg ) : void
RunSQL ( string strSQL ) : int
SetConnectionRef ( string strName, SqlConnection sc ) : void
StringFormat ( string strFormat ) : string	Does the same thing as 'string.Format' but duplicating single quotes so it will be accepted in the SQL statement context. Example: O'Hare will become O''Hare
TryConnect ( ) : bool	Opens the connection to the database
TryConnect ( string strName ) : bool	Opens the connection to the database using the given Connection String
UpdateAdapter ( DataSet ds, SqlDataAdapter objSqlAdapter, SqlCommand objComm ) : void
UpdateAdapterRowCheck ( DataSet ds, SqlDataAdapter objSqlAdapter, SqlCommand objComm ) : void
objSqlAdapter_RowUpdated ( object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e ) : void
objSqlAdapter_RowUpdating ( object sender, System.Data.SqlClient.SqlRowUpdatingEventArgs e ) : void

보호된 메소드들

메소드	설명
Dispose ( bool bNative = true ) : void

비공개 메소드들

메소드	설명
CommitAndDisconnect ( SqlTransaction &objTrans ) : void
RollbackAndReportError ( SqlTransaction &objTrans, Exception excpt ) : void

메소드 상세

프로퍼티 상세