public static SqlDataReader executeQuery(string query)
        {
            SqlDataReader result = null;

            try
            {
                SqlCommand com = new SqlCommand(query, DatabaseConection.getInstance());
                com.CommandText = query;
                result          = com.ExecuteReader();
            }
            catch (SqlException e) {
                if (result != null & !result.IsClosed)
                {
                    result.Close();
                }
                throw e;
            }
            return(result);
        }
 public static SqlDataReader executeQuery(SqlCommand command)
 {
     command.Connection = DatabaseConection.getInstance();
     return(command.ExecuteReader());
 }