c# - mysql 查询不工作

Question

我正在尝试用 C# 编写一个 MySQL 查询，如下所示，我没有看到任何错误，但也没有看到所需的输出，该查询在 mysqlworkbench 中工作正常，正在使用 MySql.Data.dll 连接 6.9.9，我缺少什么？如何调试错误？

        string connectionString = "server=10.xx.xxx.xx;database=databasename;uid=username;pwd=password;";

        var conn = new MySql.Data.MySqlClient.MySqlConnection();
        conn.ConnectionString = connectionString;
        try
        {
            Console.WriteLine("Connecting to MySQL...");
            conn.Open();

            string sql = "select bb.version,bb.baat,bb.au from build bb where bb.version='x.xxx' and bb.state='COMPLETE'";
            MySqlCommand cmd = new MySqlCommand(sql, conn);
            MySqlDataReader rdr = cmd.ExecuteReader();

            while (rdr.Read())
            {
                Console.WriteLine(rdr[0] + " -- " + rdr[1]);
                Console.ReadLine();
            }
            rdr.Close();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.ToString());
        }

Answer 1

尝试改变:

from rdr[0] 

至:

rdr.GetString(0)