SqlDataReader转换为DataTable

SqlDataReader转换为DataTable

作者：未知　时间： 2007-6-11 13:05:56　文档类型：未知　来自：未知 浏览统计：37

代码一：
private void Form1_Load(object sender, EventArgs e)
{
    dataGridView1.DataSource = GetData();
}

private DataTable GetData()
{
    DataTable dt = new DataTable();

    using (SqlConnection connection
             = new SqlConnection("ConnectionString"))
    using (SqlCommand command = new SqlCommand())
    {
        command.Connection = connection;
        command.CommandText = "SELECT * FROM Customers";

        connection.Open();
        using (SqlDataReader reader =
            command.ExecuteReader
                (CommandBehavior.CloseConnection))
        {
            dt.Load(reader);
        }
    }

    return dt;
}

代码二：
private void Form1_Load(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt.Load(GetReader());
    dataGridView1.DataSource = dt;

}

private IDataReader GetReader()
{
    DataTable dt = new DataTable();
    dt.Columns.Add("ID", typeof(string));
    dt.Columns.Add("Firstname", typeof(string));
    dt.Columns.Add("Lastname", typeof(string));

    dt.Rows.Add((new Object[] {"HAYD", "David", "Hayden"}));

    return dt.CreateDataReader();
}

作者：未知　时间： 2007-6-11 13:05:56　文档类型：未知　来自：未知 浏览统计：37

代码一：
private void Form1_Load(object sender, EventArgs e)
{
    dataGridView1.DataSource = GetData();
}

private DataTable GetData()
{
    DataTable dt = new DataTable();

    using (SqlConnection connection
             = new SqlConnection("ConnectionString"))
    using (SqlCommand command = new SqlCommand())
    {
        command.Connection = connection;
        command.CommandText = "SELECT * FROM Customers";

        connection.Open();
        using (SqlDataReader reader =
            command.ExecuteReader
                (CommandBehavior.CloseConnection))
        {
            dt.Load(reader);
        }
    }

    return dt;
}

代码二：
private void Form1_Load(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt.Load(GetReader());
    dataGridView1.DataSource = dt;

}

private IDataReader GetReader()
{
    DataTable dt = new DataTable();
    dt.Columns.Add("ID", typeof(string));
    dt.Columns.Add("Firstname", typeof(string));
    dt.Columns.Add("Lastname", typeof(string));

    dt.Rows.Add((new Object[] {"HAYD", "David", "Hayden"}));

    return dt.CreateDataReader();
}