C# (CSharp) TEXCSDBUtil.DBGetConnectionStr Exemples

Exemple #1

        public TEXCSITRAuthentication(ConnString enumConnString, int intSessionTimeoutMins)
        {
            SessionTimeOutMins = intSessionTimeoutMins;

            this.SQLConn = new System.Data.SqlClient.SqlConnection();
            switch (enumConnString)
            {
            case ConnString.TEST:
                this.SQLConn.ConnectionString = TEXCSDBUtil.DBGetConnectionStr(EXCSDBUtil.TEXCSDBUtil.enmdb_EXDBApplUser.db_EXSQL06_TEMP3_EX_Itr_Authenticator_itr_user);                          // TEXCSDBUtil.C_CONSTR_ITR_EXSQL06_TEMP3;
                break;

            case ConnString.EX:
                this.SQLConn.ConnectionString = TEXCSDBUtil.DBGetConnectionStr(EXCSDBUtil.TEXCSDBUtil.enmdb_EXDBApplUser.db_EXSQL06_EX_Itr_Authenticator_itr_user);                         //TEXCSDBUtil.C_CONSTR_ITR_EXSQL06_EX;
                break;

            default:
                this.SQLConn.ConnectionString = TEXCSDBUtil.DBGetConnectionStr(EXCSDBUtil.TEXCSDBUtil.enmdb_EXDBApplUser.db_EXSQL06_TEMP3_EX_Itr_Authenticator_itr_user);                         // TEXCSDBUtil.C_CONSTR_ITR_EXSQL06_TEMP3;
                break;
            }


            this.SQLCmd             = new System.Data.SqlClient.SqlCommand();
            this.SQLCmd.CommandType = CommandType.StoredProcedure;
            this.SQLCmd.Connection  = this.SQLConn;

            this.SQLConn.Open();
        }