如何转换的DataTable对象在C#类型列表
问题描述:
我想数据表
转换为列表<对象>
在C#。这里是我的代码。但它不工作。请帮我。
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; }
}
那么你可以做这样的
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;
}
如果你仍然想列表<对象>
然后做这样的
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);
}