如何使用c#将文本框中输入的值与数组(mysql数据集)中的值进行顺序比较？

using System;
using System.Data;
using MySql.Data.MySqlClient;
using System.Windows.Forms;

namespace YourNamespace
{
    public partial class YourForm : Form
    {
        private MySqlConnection connection;
        private string connectionString = "your_connection_string"; // 替换为你的MySQL连接字符串

        public YourForm()
        {
            InitializeComponent();
        }

        private void YourForm_Load(object sender, EventArgs e)
        {
            // 连接到MySQL数据库
            connection = new MySqlConnection(connectionString);
            connection.Open();
        }

        private void YourButton_Click(object sender, EventArgs e)
        {
            string inputValue = YourTextBox.Text;

            // 执行查询语句，将结果存储在DataSet中
            string query = "SELECT * FROM your_table"; // 替换为你的查询语句和表名
            MySqlCommand command = new MySqlCommand(query, connection);
            MySqlDataAdapter adapter = new MySqlDataAdapter(command);
            DataSet dataSet = new DataSet();
            adapter.Fill(dataSet);

            // 遍历数组进行比较
            foreach (DataRow row in dataSet.Tables[0].Rows)
            {
                string value = row["your_column"].ToString(); // 替换为你的列名
                if (inputValue.Equals(value))
                {
                    // 找到匹配值的处理逻辑
                    // ...
                    break; // 如果只需要找到第一个匹配值，可以使用break跳出循环
                }
            }
        }

        private void YourForm_FormClosing(object sender, FormClosingEventArgs e)
        {
            // 关闭数据库连接
            connection.Close();
        }
    }
}