从SQLDataReader填充DataSet的最佳方法

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

// 创建连接字符串
string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True";

// 创建SQL命令
string commandText = "SELECT * FROM myTable";

// 创建连接
using (SqlConnection connection = new SqlConnection(connectionString))
{
    // 打开连接
    connection.Open();

    // 创建命令
    using (SqlCommand command = new SqlCommand(commandText, connection))
    {
        // 创建DataAdapter
        using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
        {
            // 创建DataSet
            DataSet dataSet = new DataSet();

            // 填充DataSet
            dataAdapter.Fill(dataSet);

            // 使用填充好的DataSet
            // ...
        }
    }
}