我试图从一个有2行的mysql表中检索数据，但是只返回第一行。使用的sql语句非常简单sqlquery=“select*from table”
对于下面的代码，类只返回找到的第一个值

private ArrayList dbRead(String sqlQuery, String classQuery)
    {
        ArrayList dbCategoryResults = new ArrayList();

    //***CONNECT TO DATABASE
        Console.WriteLine("**Database Connection: Connecting to database");
        MySqlConnection dbConnection = new MySqlConnection(dbStringConnection);

        try
        {
            dbConnection.Open();
            Console.WriteLine("**Database Connection: Connected to database server");

            //***READ FROM DATABASE
            MySqlCommand command = new MySqlCommand(sqlQuery, dbConnection);
            MySqlDataReader dataReader = command.ExecuteReader();

            if (dataReader.Read())
            {
                if (classQuery == "categories")
                {
                    //String det = dataReader[1].ToString();

                    dbCategoryResults.Add(dataReader[1]);

                    Console.WriteLine("Found " + dbCategoryResults.Count);

                    return dbCategoryResults;
                }
            }
            dataReader.Close();

            command.Dispose();
            dbConnection.Close();
        }
        catch (MySqlException e)
        {
            Console.WriteLine(e.ToString());
            MessageBox.Show(e.Message, "Database Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }

        // CLOSE DATABASE
        try
        {
            dbConnection.Close();
        }
        catch (Exception e)
        {
            Console.WriteLine(e.ToString());
        }

        return null;
    }