Exemplo n.º 1
0
        /// <summary>
        /// Executes a SQL Query and returns the results as a SafeReader object
        /// </summary>
        /// <param name="SQLQuery">The Query to execute</param>
        /// <param name="PID">The Program ID that matches the configured connection string name</param>
        /// <returns></returns>
        public static SafeReader ExecuteSafeReader(string SQLQuery, string PID)
        {
            string cstr = ConfigurationManager.ConnectionStrings[PID].ToString();
            using (SqlConnection cn = new SqlConnection(cstr))
            {
                cn.Open();
                using (SqlCommand cmd = new SqlCommand(SQLQuery, cn))
                {
                    cmd.CommandType = CommandType.Text;

                    using (SqlDataReader dr = cmd.ExecuteReader())
                    {
                        SafeReader sr = new SafeReader(dr);
                        return sr;
                    }
                }
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// Returns data in a safe reader
        /// </summary>
        /// <param name="bo"></param>
        /// <remarks>
        /// [07/02/10] Created
        /// </remarks>
        public static SafeReader ExecuteSafeReader(string StoredProcName, SqlParameter[] Parameters, string PID)
        {
            string cstr = ConfigurationManager.ConnectionStrings[PID].ToString();
            using (SqlConnection cn = new SqlConnection(cstr))
            {
                cn.Open();
                using (SqlCommand cmd = new SqlCommand(StoredProcName, cn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddRange(Parameters);

                    using (SqlDataReader dr = cmd.ExecuteReader())
                    {
                        SafeReader sr = new SafeReader(dr);
                        return sr;
                    }
                }
            }
        }