将数据表转换为列表 [英] To convert datatable to list

问题描述

I have a DataTable with multiple columns. I want to get a List<String> of all column of DataTable. How can I do that?

List<string> fields;
foreach (DataRow dr in dt.Rows)
            {
                fields.Add(row[0].ToString());
            }

how can i do this??

推荐答案

使用下面代码：

Use Below Code :

List<string> fields = new List<string>();

for (int column = 0; column < dt.Columns.Count; column++)
{
  for (int row = 0; row < dt.Rows.Count; row++)
  {
    fields.Add(dt.Rows[row][column].ToString());
  }
}

嗨Rahul，试试这个

Hi Rahul, try this

List<string> NameList = (from r in dt.AsEnumerable()
select r.Field<Column1DataType>("Column1") + r.Field<Column2DataType>("Column2")).ToList();

i希望这会对你有帮助......

i hope this will help you...

这篇关于将数据表转换为列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！