ExecuteReader

 public static SqlDataReader ExecuteReader(SqlConnection NewConnection, CommandType cmdType, string cmdText, params SqlParameter[] cmdParams)
        {
            try
            {
                SqlCommand cmd = new SqlCommand();
                PrepareCommand(cmd, NewConnection, null, cmdType, cmdText, cmdParams);
                SqlDataReader rdr = cmd.ExecuteReader();
                cmd.Parameters.Clear();
                cmd.Dispose();
                return rdr;
            }
            catch (SqlException ex)
            {
                throw ex;
            }
        }


private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter[] cmdParams)
        {
            if (conn.State != ConnectionState.Open)
                conn.Open();

            cmd.Connection = conn;
            cmd.CommandText = cmdText;

            if (trans != null)
                cmd.Transaction = trans;

            cmd.CommandType = cmdType;

            if (cmdParams != null)
            {
                foreach (SqlParameter objParams in cmdParams)
                    cmd.Parameters.Add(objParams);
            }
        }