从DataTable中删除行

3 回答

• 1

  你可以尝试这个......

  var checkValues = new string[]  { "Some value1", "Some value3" };
          DataTable dt = new DataTable();
          DataTable dt1 = new DataTable();
          dt.Columns.Add("Column1");
          dt.Columns.Add("Column2");
          dt.Columns.Add("Column3");
          dt.Rows.Add(new string[] {"Some value1", "Some value2", "Some value3" });
          dt.AsEnumerable().ToList().ForEach(x =>
              {
                  if (checkValues.Contains(x["Column1"]))
                  {
                      dt1.ImportRow(x);
                      dt.Rows.Remove(x);
                  }
              });
  

  回复于 2024-05-09T04:40:35+08:00
• 1

  此代码将起作用：

  for (int i = dt.Rows.Count - 1; i >= 0; i--)
      {
          DataRow row = dt.Rows[i];
  
          if (row["Column2"].ToString() == "This Value")
          {
              dt2nd.ImportRow(row); //Copy
              dt.Rows.Remove(row); //Remove
              continue;
          }
          if (row["Column2"].ToString() == "Other Value")
          {
              dt2nd.ImportRow(row); //Copy
              dt.Rows.Remove(row); //Remove
              continue; 
          }
          //This continues with more if
      }
  

  或者您可以使用switch语句而不是所有ifs或使用else if

  for (int i = dt.Rows.Count - 1; i >= 0; i--)
      {
          DataRow row = dt.Rows[i];
  
          if (row["Column2"].ToString() == "This Value")
          {
              dt2nd.ImportRow(row); //Copy
              dt.Rows.Remove(row); //Remove
          }
          else if (row["Column2"].ToString() == "Other Value")
          {
              dt2nd.ImportRow(row); //Copy
              dt.Rows.Remove(row); //Remove
          }
          //This continues with more else if
      }
  

  要么

  for (int i = dt.Rows.Count - 1; i >= 0; i--)
      {
          DataRow row = dt.Rows[i];
  
          switch(row["Column2"].ToString()){
          case "This Value":
          {
              dt2nd.ImportRow(row); //Copy
              dt.Rows.Remove(row); //Remove
              break;
          }
          case "Other Value":
          {
              dt2nd.ImportRow(row); //Copy
              dt.Rows.Remove(row); //Remove
              break; 
          }
          //This continues with more case
      }
  

  但是，您也可以在数据表上使用select，并输出需要移出的所有行 . 这样的事情：

  dt.select("Column2 == 'This value' or ...");
  

  它将返回满足条件的行 . 请参见此处的示例：http://www.dotnetperls.com/datatable-select

  但是如果操作总是相同的话，代码可以缩短很多：

  for (int i = dt.Rows.Count - 1; i >= 0; i--)
      {
          DataRow row = dt.Rows[i];
  
          if (
                 (row["Column2"].ToString() == "This Value") ||
                 (row["Column2"].ToString() == "Other Value") //more checks
             )
          {
              dt2nd.ImportRow(row); //Copy
              dt.Rows.Remove(row); //Remove
          }
      }
  

  要么

  for (int i = dt.Rows.Count - 1; i >= 0; i--)
  {
      DataRow row = dt.Rows[i];
  
      switch(row["Column2"].ToString()){
      case "This Value":
      case "Other Value": //more case values
      {
          dt2nd.ImportRow(row); //Copy
          dt.Rows.Remove(row); //Remove
          break;
      }
  }
  

  回复于 2024-05-09T04:40:35+08:00
• 1

  var valuesToBeChecked = new String[] { "value1", "value2" };
          var x = from y in dt.AsEnumerable()
                  where valuesToBeChecked.Any(t => valuesToBeChecked.Contains(y["Column2"].ToString()))
                  select y;
          var z = dt.AsEnumerable().Except(x);
  

  然后，您可以将 z 复制到您想要的 datatable ：

  DataTable dt2 = z.CopyToDataTable();
  

  回复于 2024-05-09T04:40:35+08:00