How do I fill a DataTable using DataReader

asp.net ado.net sqldatareader
NoviceToDotNet picture NoviceToDotNet · Nov 3, 2010 · Viewed 43.6k times · Source

I want to fill DataTable using DataReader.

I have created object like this

SqlDataReader dr = cmd.ExecuteReader();

if(dr.HasRows)
{

}

Answer

jerome picture jerome · Feb 13, 2014

If all you want is a ReadOnly DataTable for reporting or web, try this:

  conn = new SqlConnection(connString);
  string query = "SELECT * FROM Customers";
  SqlCommand cmd = new SqlCommand(query, conn);
  conn.Open();
  SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
  DataTable dt = new DataTable();
  dt.Load(dr);

Credit where it's due: http://www.dotnetcurry.com/showarticle.aspx?ID=143

Related questions

Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call a created stored procedure from my database. This a button insert I make work well. private void btnAdd_Click(object …

Read More
Connection timeout for SQL server

Can I increase the timeout by modifying the connection string in the web.config?

Read More
How to change the DataTable Column Name?

I have one DataTable which has four columns such as StudentID CourseID SubjectCode Marks ------------ ---------- ------------- -------- 1 100 MT400 80 2 100 MT400 79 3 100 MT400 88 Here I am inserting this Datatable into the Sql server table by passing this datatable as an XML Table. …

Read More