One of the simplest way is to use
Linq to DataSet[
^].
void Main()
{
string myDelimitedText = "A123,C521,A224,B221,";
DataTable dt = CreateDataTable();
var dl = myDelimitedText.Split(new char[]{','}, StringSplitOptions.RemoveEmptyEntries)
.Select(x=>new
{
Alpha = x,
IsInDt = dt.AsEnumerable().Any(y=>y.Field<string>("MyField")==x)
});
foreach (var a in dl)
{
Console.WriteLine("{0} {1}", a.Alpha, a.IsInDt);
}
}
public static DataTable CreateDataTable()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("MyField", Type.GetType("System.String")));
dt.Rows.Add(new Object[]{"A123"});
dt.Rows.Add(new Object[]{"B123"});
dt.Rows.Add(new Object[]{"C123"});
dt.Rows.Add(new Object[]{"A224"});
dt.Rows.Add(new Object[]{"C324"});
return dt;
}
Result:
Alpha IsInDt
A123 True
C521 False
A224 True
B221 False
For futher information, please see:
Queries in LINQ to DataSet[
^]