如何在WPF中检查Mysql表中是否存在值

using MySql.Data.MySqlClient;

// 创建MySQL连接字符串
string connectionString = "server=localhost;database=mydatabase;uid=username;password=password";

// 创建MySQL连接对象
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    // 打开连接
    connection.Open();

    // 构建查询语句
    string query = "SELECT COUNT(*) FROM mytable WHERE column = 'value'";

    // 创建MySQL命令对象
    using (MySqlCommand command = new MySqlCommand(query, connection))
    {
        // 执行查询并获取结果
        int count = Convert.ToInt32(command.ExecuteScalar());

        // 判断结果
        if (count > 0)
        {
            // 表中存在满足条件的记录
            Console.WriteLine("值存在于表中");
        }
        else
        {
            // 表中不存在满足条件的记录
            Console.WriteLine("值不存在于表中");
        }
    }
}