/// <summary>
    /// Returns the number of fields contained within a query result set
    /// </summary>
    /// <param name="query"></param>
    /// <returns></returns>
    public static int numberFields(string query)
    {
        SqlCommand comm = CreateCommand();
        comm.CommandText = query;
        int numFields = -1;
        try
        {
            comm.Connection.Open();
            numFields = comm.ExecuteReader().FieldCount;

        }
        catch (Exception ex)
        {
            throw ex.Message;
        }
        finally
        {
            comm.Connection.Close();
        }
        return numFields;
    }