public static int numberFields(string query)
    {
        SqlCommand comm = CreateCommand();
        comm.CommandText = query;
        SqlDataReader reader = comm.ExecuteReader();

        try
        {
            comm.Connection.Open();
            IEnumerator ie = reader.GetEnumerator();
            while (ie.MoveNext())
            {
                SqlDataRecord sqlRecord = (SqlDataRecord)ie.Current;
                return sqlRecord.FieldCount;
            }
        }
        catch (Exception ex)
        {
            throw ex.Message;
        }
        finally
        {
            comm.Connection.Close();
        }
    }