C# Mysql datareader -如何使用datareader获取其他列

using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "your_connection_string";
        string query = "SELECT column1, column2, column3 FROM your_table";

        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            using (MySqlCommand command = new MySqlCommand(query, connection))
            {
                using (MySqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        int column1Value = reader.GetInt32(0);
                        string column2Value = reader.GetString(1);
                        double column3Value = reader.GetDouble(2);

                        Console.WriteLine("Column1: " + column1Value);
                        Console.WriteLine("Column2: " + column2Value);
                        Console.WriteLine("Column3: " + column3Value);
                    }
                }
            }
        }
    }
}