从填充了sql select的数据表中读取值的C#

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password";
        string sqlQuery = "SELECT column1, column2 FROM your_table";

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

            using (SqlCommand command = new SqlCommand(sqlQuery, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string value1 = reader.GetString(0); // 读取第一个列的值
                        int value2 = reader.GetInt32(1); // 读取第二个列的值

                        Console.WriteLine("Value 1: " + value1);
                        Console.WriteLine("Value 2: " + value2);
                    }
                }
            }
        }
    }
}