Replacing a DataReader with a DataTable

by

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;
}

More Related Contents:

  1. LINQ query on a DataTable
  2. How to read a CSV file into a .NET Datatable
  3. Creating a DateTime in a specific Time Zone in c#
  4. How can I convert an integer into its verbal representation?
  5. Best way to remove duplicate entries from a data table
  6. How to change the color of progressbar in C# .NET 3.5?
  7. How to parse a string into a nullable int
  8. How to select min and max values of a column in a datatable?
  9. Don’t stop debugger at THAT exception when it’s thrown and caught
  10. How to compare 2 dataTables
  11. Inconsistency in divide-by-zero behavior between different value types
  12. Software rendering mode – WPF
  13. Convert DataTable to generic List?
  14. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  15. Operation could destabilize the runtime?
  16. Monitoring Garbage Collector in C#
  17. How do I get the Local Network IP address of a computer programmatically?
  18. How can I join int[] to a character-separated string in .NET?
  19. DataTable equivalent in Java [duplicate]
  20. Dependency Injection wcf
  21. Put WPF control into a Windows Forms Form?
  22. Best way to check if a Data Table has a null value in it
  23. Get Cell Value from a DataTable in C#
  24. Returning DataTables in WCF/.NET
  25. Finding all classes with a particular attribute
  26. How to convert DataTable to class Object?
  27. DataTable internal index is corrupted
  28. How can I convert a DataTable to an XML file in C#?
  29. Get first element from a dictionary
  30. How to check if process is not responding?

Leave a Comment