数据表中存在字符串或c#中不存在字符串

本文关键字：字符串 不存在 数据表 存在 | 更新日期: 2023-09-27 18:30:01

我想在数据表的特定列中找到特定字符串，以便它出现或不出现在的所有行中

数据表中存在字符串或c#中不存在字符串

using System.Linq;
string columnName = "SomeColumnName;"
string matchPattern = "matchPattern";
// returns rows which contains pattern in specific columns
var result = tbl.AsEnumerable()
                .Select(f => f.Field<string>(columnName))
                .Where(c => c.Contains(matchPattern));

// returns true if all rows contains pattern in specific column
var result = tbl.AsEnumerable()
                .Select(f => f.Field<string>(columnName))
                .All(c => c.Contains(matchPattern));

// Checks whether all rows contain "data" in the column "colName"
var b1 = table.AsEnumerable().All(dr => dr["colName"].ToString().Contains("data"));
// Checks whether all rows equals "data" in the column "colName"
var b2 = table.AsEnumerable().All(dr => dr["colName"].ToString() == "data");
// Checks whether all employees have a last name containing "ab"
var b3 = table.AsEnumerable().All(dr => ((FullName)dr["fullName"]).Last.Contains("ab"));
相关文章：