时间戳

首页 > 解决方案 > How to foreach through a list of datatables?

c# - How to foreach through a list of datatables?

问题描述

I have a list of 2 DataTables. I want to iterate through each of them, one at a time. How do I do this? There are 0 examples of going through a list of DataTables.

List<DataTable> test = new List<DataTable>();

foreach (DataRow dataRow in TEST.LIST)
{
    string value = dataRow.Field<string>("Slave_IO_Running");   //Looks for "Slave_IO_Running" status.

    if (value == "Yes")
    {
        results.Add(siteName + ": WORKING"); //adds working to the visual table 
    }
    else
    {
        results.Add(siteName + ": REPLICATION ERROR"); //adds not working to the result list
    }
    break;
}

标签： c#datatable

解决方案

对于您可以使用的每个数据DataTable.Rows表，对于每一行，您可以访问属性row["columnName"]或遍历相应行中的每一列，例如

 foreach(DataTable table in tables)
 {
   foreach(DataRow row in table.Rows)
   {
     foreach(DataColumn column in table.Columns)
     {
        Console.WriteLine(row[column]);
     }
   }
 }

推荐阅读