How to convert DataTable to object type List in C#

c#, datatable, generic-list

Solution

If you have any Typed DataType for list object something like this

public class MyObj
{
    public string Name { get; set; }
    public int ID { get; set; }
}

then you can do like this

private List<MyObj> test(DataTable dt)
{
       
    var convertedList = (from rw in dt.AsEnumerable()
        select new MyObj() 
        {
            ID = Convert.ToInt32(rw["ID"]),
            Name = Convert.ToString(rw["Name"])
        }).ToList();

    return convertedList;
}

or if you still want `List<object>` then do like this

private List<object> GetListByDataTable(DataTable dt)
{

    var reult = (from rw in dt.AsEnumerable()
        select new
        {
            Name = Convert.ToString(rw["Name"]),
            ID = Convert.ToInt32(rw["ID"])
        }).ToList();

    return reult.ConvertAll<object>(o => (object)o);
}

or follow this it has generic resolution too https://www.c-sharpcorner.com/UploadFile/ee01e6/different-way-to-convert-datatable-to-list/

Problem

Original source