获取DataTable列集合与行集合:
var dd = 创建表.Columns.Cast<DataColumn>().ToArray();
var aa = 创建表.Rows.Cast<DataRow>().ToArray();//[0].ItemArray;
foreach (DataRow aaaa in aa) MessageBox.Show(aaaa.ItemArray[0].ToString());
获取某列所有行的集合:
var aaa = 创建表.Rows.Cast<DataRow>().Select(aadd=>aadd[0]).ToArray();
foreach (object aaaa in aaa) MessageBox.Show(aaaa.ToString());
foreach (DataRow aaaa in 创建表.Rows) MessageBox.Show(aaaa.ItemArray[0].ToString());
明确类型:
DataColumn[] 表列 = 创建表.Columns.Cast<DataColumn>().ToArray();
DataColumn[] 表列名 = new DataColumn[数据表.Columns.Count];
数据表.Columns.CopyTo(表列名, 0);
DataRow[] 表行 = 创建表.Rows.Cast<DataRow>().ToArray();
foreach (DataRow 数据 in 表行) MessageBox.Show(数据.ItemArray[0].ToString());
foreach (DataRow 数据 in 创建表.Rows) MessageBox.Show(数据.ItemArray[0].ToString());
object[] a表行 = 创建表.Rows.Cast<DataRow>().Select(aadd => aadd[0]).ToArray();
foreach (object 数据 in a表行) MessageBox.Show(数据.ToString());
object[] 行组 = 中草药数据表.NewRow().ItemArray ;//.Rows.Cast<DataRow>().Take(1).ToArray()[0].ItemArray;
DataTable aa = new DataTable();
aa.Columns.Add("d1"); aa.Columns.Add("d2");
aa.Rows.Add(new string[] { "20181123051641", "20181123051944" });
aa.Rows.Add(new string[] { "20181123051742", "20181123051634" });
var dd = aa.Rows.Cast<DataRow>().Select(值 => DateTime.ParseExact(值[0].ToString(), "yyyyMMddhhmmss", System.Globalization.CultureInfo.CurrentCulture)).ToArray();
aa.Rows.Add(new string[] { "1", "2" });
aa.Rows.Add(new string[] { "5", "6" });
var dd = aa.AsEnumerable().Select(t => t.Field<string>("d1")).Max();
var dd = aa.Select().Select(t => t.Field<string>("d2")).Max();
var dd = aa.Select().Select(t=>t["d2"]).Max();
var dd = aa.Rows.Cast<DataRow>().Select(t => t.Field<string>("d2")).Max();
DataTable 啊啊 = new DataTable("啊啊");
啊啊.Columns.Add("D1", typeof(decimal)); 啊啊.Columns.Add("D2", typeof(decimal));
啊啊.Rows.Add(1,2); 啊啊.Rows.Add(5,6);
var dd = 啊啊.Rows.Cast<DataRow>().Select(t => t.Field<decimal>("D1")).Max();
var ddd = 啊啊.Rows.Cast<DataRow>().Select(t => t.Field<decimal>("D2")).Max();
MessageBox.Show(dd + "最大化!" + ddd, "最大化!");
var aa = 数据表.AsEnumerable().Any (比 => 比.ItemArray[0].ToString().Trim() == 待查[0].Trim());
var aaa = 数据表.Select().Any(比 => 比.ItemArray[0].ToString().Trim() == 待查[0].Trim());
var aaaa = 数据表.Select().TakeWhile(值 => 值.ItemArray[0].ToString().Trim() == 待查[0].Trim()).All(比 => 比.ItemArray[0].ToString().Trim() == 待查[0].Trim());