Convert SqlDataReader to DataTable c#

By Mash B

Copy data from SqlDatareader to DataTable using Load function of DataTable.


using(SqlConnection conn = new SqlConnection(YourConnectionString))
    String sqlQuery = "Select * from Emp";
// open the connection

using(SqlCommand cmd = new SqlCommand(sqlQuery,conn))
// execute query and read data in SqlDataReader
       using(SqlDataReader reader = cmd.ExecuteReader())
   DataTable dt = new DataTable();
// call load method of datatable to copy content of reader
dt.Load(reader); // Load method does not close the connnection. In this case, the using statement does.



Convert SqlDataReader to DataTable c#  (7258 Views)