C# -将DataReader转换为DataTable

using System;
using System.Data;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string query = "YourQuery";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();

            DataTable dataTable = new DataTable();
            dataTable.Load(reader);

            reader.Close();
            connection.Close();

            // 现在你可以使用转换后的DataTable进行后续操作
            // 例如，可以遍历DataTable的行和列，或者将其绑定到UI控件上进行显示
        }
    }
}