c# datatable 根据字段查询

/ 假设你有一个名为myDataTable的DataTable
DataTable myDataTable = new DataTable();

// ... 使用数据填充DataTable ...

// 使用Select方法根据"Name"字段查询DataTable
string nameToSearch = "John";
DataRow[] foundRows = myDataTable.Select("Name = '" + nameToSearch + "'");

// 遍历找到的行
foreach (DataRow row in foundRows)
{
    Console.WriteLine("ID: " + row["ID"] + ", Name: " + row["Name"] + ", Age: " + row["Age"]);
}