我有一个需要验证用户输入的数据库。我搞不清楚我用来验证输入的while循环的语法。
期望：

/*
User inputs "Hondas" 
Console checks database if "Hondas" exists.
If it doesn't exist, prompt user again.
If it does exist, continue w/ program.

* /

当前代码：

// Open a connection to MySQL 
            conn = new MySqlConnection(cs);
            conn.Open();

            //Declare DataReader
            MySqlDataReader rdr = null;

            // Form SQL Statement
            string stm = $"select count(*) from vehicle where make = \"{sqlInput}\"";

            // Prepare SQL Statement
            MySqlCommand cmd = new MySqlCommand(stm, conn);

            rdr = cmd.ExecuteReader();

            // Output Results
            while (rdr.Read() && rdr.GetInt32(0) <= 0)
            {
                Console.Clear();
                Console.WriteLine("This make doesn't exist in the database, try again.");
                sqlInput = Console.ReadLine();
            // I believe I'm supposed to have some connection info here.
            }

这成功地验证了循环是否正常工作。它只运行一次，如果我有多个 Incorrect 条目。我不太熟悉这种联系应该是什么样子。谢谢你的帮助。