使用linq将2个Datatable合并

DataTable dtStepX = new DataTable("dtStepX");
DataTable dtStepS = new DataTable("dtStepS");
//获取两个数据源的并集
IEnumerable<DataRow> query = dtStepS.AsEnumerable().Union(dtStepX.AsEnumerable(), DataRowComparer.Default);
//两个数据源的并集集合
DataTable dt = query.CopyToDataTable();
 

第二种方法

DataTable dt1 = new DataTable();
DataTable frm = new DataTable();
foreach (DataRow dr in dt1.Rows)
{
    frm.ImportRow(dr);
}
dataGridView1.DataSource = frm;

   var queryDanTi = dtDanTi.Rows.Cast<DataRow>().Where(row => Convert.ToDecimal(row["Temp"]) > warnTemp).OrderBy(row => row["No"]).Select(row => new { ColdNo = row["No"], WarnTemperature = row["Temp"] }).ToList();