DataTable to List

by

I have another approach that might be worth taking a look at.
It’s a helper method. Create a custom class file named CollectionHelper:

    public static IList<T> ConvertTo<T>(DataTable table)
    {
        if (table == null)
            return null;

        List<DataRow> rows = new List<DataRow>();

        foreach (DataRow row in table.Rows)
            rows.Add(row);

        return ConvertTo<T>(rows);
    }

Imagine you want to get a list of customers. Now you’ll have the following caller:

List<Customer> myList = (List<Customer>)CollectionHelper.ConvertTo<Customer>(table);

The attributes you have in your DataTable must match your Customer class (fields like Name, Address, Telephone).

I hope it helps!

For who are willing to know why to use lists instead of DataTables: link text

The full sample:

http://lozanotek.com/blog/archive/2007/05/09/Converting_Custom_Collections_To_and_From_DataTable.aspx

More Related Contents:

  1. How I can filter a Datatable?
  2. How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
  3. Direct method from SQL command text to DataSet
  4. How to fill Dataset with multiple tables?
  5. Datatable vs Dataset
  6. Stored procedure return into DataSet in C# .Net
  7. Why is a SQL float different from a C# float
  8. How to bind crystal report to manually created DataSet
  9. Convert Dataset to XML
  10. Filtering DataSet
  11. How do I transform a List into a DataSet?
  12. Is it possible to dynamically compile and execute C# code fragments?
  13. How do I encode and decode a base64 string?
  14. What is the best way to store user settings for a .NET application?
  15. How do I specify the Linq OrderBy argument dynamically? [duplicate]
  16. Comparing arrays in C#
  17. How do I kill a process using Vb.NET or C#?
  18. Entity framework left join
  19. How to read attribute value from XmlNode in C#?
  20. How do you add an index field to Linq results
  21. How To Test if a Type is Anonymous? [duplicate]
  22. How do closures work behind the scenes? (C#)
  23. How to add OpenIdConnect via IdentityServer4 to ASP.NET Core ServerSide Blazor web app?
  24. How to throttle requests in a Web Api?
  25. how to create an audit trail with Entity framework 5 and MVC 4
  26. How to configure Swashbuckle to ignore property on model
  27. How does the registry entry HKEY_LOCAL_MACHINE\…\FEATURE_BFCACHE for InternetExplorerDriver solves the Internet Explorer 11 issue?
  28. Unity EventManager with delegate instead of UnityEvent
  29. Using a PagedList with a ViewModel ASP.Net MVC
  30. Pros and Cons of using SqlCommand Prepare in C#?

Leave a Comment