예제 #1
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="regID"></param>
        /// <param name="objDS"></param>
        /// <returns></returns>
        public bool getCountryDetailsDAL(int regID, ref DataSet objDS)
        {
            try
            {
                paramIn = new SqlParameter[1];
                paramIn[0] = new SqlParameter("@p_RegionID", SqlDbType.Int);
                paramIn[0].Value = regID;

                if (objDBPool.SpQueryDataset("USP_GET_RegionCountry", paramIn, ref objDS))
                    return true;
                else return false;
            }
            finally
            {
                objDBPool = null;
            }
        }
예제 #2
0
 /// <summary>
 /// Constructor to initialize the DB Connection
 /// </summary>
 public clsPTFQA_DAL()
 {
     objDBPool = new DBPool();
     objDBPool.ConnectionString = ConnectionString;
 }