DataTable 增加列 并按字段排序

 StrSql_M = "SELECT * FROM [Base_TagInfo] where status = '0' and ReaderID=@ReaderID order by savetime";
                       
 dt_TagInfo1 = SQLHelper.Query(StrSql_M, new SqlParameter("@ReaderID", readerid)).Tables[0];

 

 //添加一列样品编号 2020-09-14

   dt_TagInfo1.Columns.Add(new DataColumn("TestTaskNum", typeof(string))); //添加更新时间列，数据类型string
   for (int i = 0; i < dt_TagInfo1.Rows.Count; i++)
   {
          for (int ii = 0; ii < dt_TestNum.Rows.Count; ii++)
          {
                 if (dt_TagInfo1.Rows[i]["TagID"].ToString() == dt_TestNum.Rows[ii]["RFID"].ToString())
                  {

                       //第i行的TestTaskNum = 原有的第i行的TestTaskNum

                       dt_TagInfo1.Rows[i]["TestTaskNum"] = dt_TestNum.Rows[ii]["TestTaskNum"].ToString() ;
                       break;
                   }
           }                     
     }

   #region 利用linq将dataTable转换为集合，然后排序
   dt_TagInfo1 = dt_TagInfo1.Rows.Cast<DataRow>().OrderBy(r => int.Parse(r["TestTaskNum"].ToString())).CopyToDataTable();
    #endregion