Populate data table from data reader

by

You can load a DataTable directly from a data reader using the Load() method that accepts an IDataReader.

var dataReader = cmd.ExecuteReader();
var dataTable = new DataTable();
dataTable.Load(dataReader);

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. MetadataException: Unable to load the specified metadata resource
  3. Get output parameter value in ADO.NET
  4. When should “SqlDbType” and “size” be used when adding SqlCommand Parameters?
  5. SQLite Database Locked exception
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  8. Difference with Parameters.Add and Parameters.AddWithValue
  9. SqlConnection SqlCommand SqlDataReader IDisposable
  10. Exception when AddWithValue parameter is NULL
  11. Calling Oracle stored procedure from C#?
  12. Insert into C# with SQLCommand
  13. MultipleActiveResultSets=True or multiple connections?
  14. How to pass a table-value parameter
  15. How DataReader works?
  16. How to keep single SQL Server connection instance open for multiple request in C#?
  17. DataTable equivalent in Java [duplicate]
  18. How do I re-write a SQL query as a parameterized query?
  19. Check if a SQL table exists
  20. What is the difference between dataview and datatable?
  21. Reading a date using DataReader
  22. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  23. How do I connect to a SQL database from C#?
  24. .net connection pooling
  25. Do we have transactions in MS-Access?
  26. Sorting Win Form CheckListbox [closed]
  27. Best way to store encryption keys in .NET C#
  28. Is there a possibility to differ virtual printer from physical one?
  29. Parsing a Auto-Generated .NET Date Object with Javascript/JQuery
  30. Which C# method overload is chosen?

Leave a Comment