Datatable vs Dataset

by

It really depends on the sort of data you’re bringing back. Since a DataSet is (in effect) just a collection of DataTable objects, you can return multiple distinct sets of data into a single, and therefore more manageable, object.

Performance-wise, you’re more likely to get inefficiency from unoptimized queries than from the “wrong” choice of .NET construct. At least, that’s been my experience.

More Related Contents:

  1. How I can filter a Datatable?
  2. ERROR: Cannot convert method group ‘CopyToDataTable’ to non-delegate type ‘System.Data.DataTable’. Did you intend to invoke the method?
  3. How to use Select method of DataTable
  4. Convert IEnumerable to DataTable
  5. Sorting rows in a data table
  6. Read SQL Table into C# DataTable
  7. Best way to remove duplicate entries from a data table
  8. How can I turn a DataTable to a CSV?
  9. How to convert datatable to json string using json.net?
  10. How to bind DataTable to Datagrid
  11. Efficient DataTable Group By
  12. Export DataTable to Excel File
  13. Convert DataTable to CSV stream
  14. Convert DataTable to generic List?
  15. Merge 2 DataTables and store in a new one
  16. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  17. Creating a SQL Server table from a C# datatable
  18. DataTable, How to conditionally delete rows
  19. Convert DataTable to IEnumerable
  20. Stored procedure return into DataSet in C# .Net
  21. Why is a SQL float different from a C# float
  22. How to bind crystal report to manually created DataSet
  23. Filtering DataSet
  24. Datatable select with multiple conditions
  25. DataTable internal index is corrupted
  26. How to make C# DataTable filter
  27. ComboBox.ValueMember and DisplayMember
  28. DataTable to List
  29. Why can’t I do foreach (var Item in DataTable.Rows)?
  30. Convert DataTable to Generic List in C#

Leave a Comment