c# - 如何添加这两个在 DataTable 中具有多个值的变量？

Question

这里和两个变量存储两个表数据现在我想通过 Foreach 循环将这些表添加到 DataTable 中？

    var meterData = MeterTable(startDateTime, endDateTime);
    var levelData = LevelTable(startDateTime, endDateTime);

      var dataTable = new DataTable();
                dataTable.Columns.Add("Meter", typeof(string));
                dataTable.Columns.Add("Volume", typeof(int));
                dataTable.Columns.Add("OpeningBalance", typeof(int));
                dataTable.Columns.Add("IN", typeof(int));
                dataTable.Columns.Add("Transfer", typeof(int));
                dataTable.Columns.Add("OUT", typeof(int));
                dataTable.Columns.Add("ClosingBalance", typeof(int));
   // how Onward i have not any idea ?

标签： c#asp.netdatatable

Answer 1

你可以像这样new row通过foreach循环添加

  var dataTable = new DataTable();
  dataTable.Columns.Add("Meter", typeof(string));
  dataTable.Columns.Add("Volume", typeof(int));

foreach (var items in Source) //source is the where you want to loop
{
DataRow row = dataTable.NewRow();
row["Meter"] = "meter"; 
//you can access value of source items through item.NameofTargetField like items.meter  
row["Volume"] = 11;
dataTable.Rows.Add(row);
}