如何在visual studio的c#脚本中使用查询结果？

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串

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

            string query = "SELECT * FROM YourTable"; // 替换为你的查询语句

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // 读取查询结果的具体值
                        string column1Value = reader.GetString(0);
                        int column2Value = reader.GetInt32(1);
                        // ...

                        // 处理查询结果
                        Console.WriteLine($"Column1: {column1Value}, Column2: {column2Value}");
                    }
                }
            }
        }
    }
}