如何将DataTable转换为对象类型列表在C＃ [英] How to convert DataTable to object type List in C#

问题描述

我想在C＃中将 DataTable 转换为列表< object> 。这是我的代码但它不工作。请帮助我

I want to convert DataTable to List<object> in C#. Here is my code. But it is not working. Please help me

public List<object> ShowMessage()
{
    List<object> obj = new List<object>();

    DataTable dt = new DataTable();
    dt.Columns.Add("ID");
    dt.Columns.Add("Name");

    dt.Rows.Add("1","AAA");
    dt.Rows.Add("2", "BBB");
    dt.Rows.Add("3", "CCC");

    foreach (DataRow dr in dt.Rows)
    {
        obj.Add(dr);
    }

    return obj;
}

这是错误 -

推荐答案

如果您有任何类型的数据类型的列表对象这样的

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

那么你可以这样做

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

或者您仍然想要列表< object> / code>然后这样做

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

这篇关于如何将DataTable转换为对象类型列表在C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！