How to convert DataTable to class Object?

by

Initialize DataTable:

DataTable dt = new DataTable(); 
dt.Columns.Add("id", typeof(String)); 
dt.Columns.Add("name", typeof(String)); 
for (int i = 0; i < 5; i++)
{
    string index = i.ToString();
    dt.Rows.Add(new object[] { index, "name" + index });
}

Query itself:

IList<Class1> items = dt.AsEnumerable().Select(row => 
    new Class1
        {
            id = row.Field<string>("id"),
            name = row.Field<string>("name")
        }).ToList();

More Related Contents:

  1. LINQ query on a DataTable
  2. Read SQL Table into C# DataTable
  3. Find all child controls of specific type using Enumerable.OfType() or LINQ
  4. How to Convert JSON object to Custom C# object?
  5. Fire and forget async method in asp.net mvc
  6. Object cannot be cast from DBNull to other types
  7. How can I get a list of users from active directory?
  8. Has an event handler already been added?
  9. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  10. Extension methods syntax vs query syntax
  11. Conversion from List to array T[]
  12. How to show a image in database in the image control of Asp.net?
  13. How do I create an expression tree calling IEnumerable.Any(…)?
  14. Can I have an optional parameter for an ASP.NET SOAP web service
  15. How to use custom Authorize attribute for roles as well as a specific user?
  16. Upload file on FTP
  17. What is the performance of the Last() extension method for List?
  18. Overloading getter and setter causes a stack overflow in C# [duplicate]
  19. Should I use two “where” clauses or “&&” in my LINQ query?
  20. Performance of Find() vs. FirstOrDefault() [duplicate]
  21. How do I do a left outer join with Dynamic Linq?
  22. LINQ performance FAQ
  23. A dictionary where value is an anonymous type in C#
  24. Convert DataTable to List
  25. DataTable internal index is corrupted
  26. Reading XML with an “&” into C# XMLDocument Object
  27. Limit only one session per user in ASP.NET
  28. Web Service without adding a reference?
  29. Map two lists into a dictionary in C#
  30. Why can’t I do foreach (var Item in DataTable.Rows)?

Leave a Comment