Replacing a DataReader with a DataTable

Question

I'm adapting some code that someone else wrote and need to return a DataTable for time's sake.

I have code like this:

using (SqlCommand command = new SqlCommand(query, conn))
{
      //add parameters and their values

      using (SqlDataReader dr = command.ExecuteReader())
      {
          return dr;
      }

But what's the best way to return a datatable?

Thomas C. G. de Vilhena · Accepted Answer · 2012-12-14 00:25:05Z

91

Use the DataTable.Load method to fill your table with values from the SqlDataReader:

using (SqlDataReader dr = command.ExecuteReader())
{
    var tb = new DataTable();
    tb.Load(dr);
    return tb;
}

answered Dec 14, 2012 at 0:25

Thomas C. G. de Vilhena

14.7k3 gold badges58 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dmaij · Accepted Answer · 2012-12-14 00:25:37Z

12

By using a DBDataAdapter

excerpt from ms documentation

// Create the DbDataAdapter.
DbDataAdapter adapter = new DbDataAdapter();
adapter.SelectCommand = command;

// Fill the DataTable.
DataTable table = new DataTable();
adapter.Fill(table);

answered Dec 14, 2012 at 0:25

dmaij

1,0077 silver badges15 bronze badges

1 Comment

Demodave Over a year ago

It says that I cannot create an instance of the abstract class

Collectives™ on Stack Overflow

Replacing a DataReader with a DataTable

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related