使用(LINQ /谓词)获取DataTable的所有列名称到字符串数组中 [英] Get all column names of a DataTable into string array using (LINQ/Predicate)
本文介绍了使用(LINQ /谓词)获取DataTable的所有列名称到字符串数组中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
string [] columnNames = dt.Columns?
或
string [] columnNames = from DataColumn dc in dt.Columns select dc.name;
解决方案
尝试这个(LINQ方法语法):
string [] columnNames = dt.Columns.Cast< DataColumn>()
.Select(x => x.ColumnName )
.ToArray();
或LINQ查询语法:
string [] columnNames =(from dc in dt.Columns.Cast< DataColumn>()
select dc.ColumnName).ToArray();
需要投放
,因为列是键入DataColumnCollection,它是一个 IEnumerable
,而不是 IEnumerable< DataColumn>
。其他部分应该是明显的。
I know we can easily do this by a simple loop, but I want to persue this LINQ/Predicate?
string[] columnNames = dt.Columns.?
or
string[] columnNames = from DataColumn dc in dt.Columns select dc.name;
解决方案
Try this (LINQ method syntax):
string[] columnNames = dt.Columns.Cast<DataColumn>()
.Select(x => x.ColumnName)
.ToArray();
or in LINQ Query syntax:
string[] columnNames = (from dc in dt.Columns.Cast<DataColumn>()
select dc.ColumnName).ToArray();
Cast
is required, because Columns is of type DataColumnCollection which is a IEnumerable
, not IEnumerable<DataColumn>
. The other parts should be obvious.
这篇关于使用(LINQ /谓词)获取DataTable的所有列名称到字符串数组中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文