如何更新在一个DataTable这在foreachloop一列的值？ [英] How to update a value in a column in a datatable which is in a foreachloop?

问题描述

我要更新所有列的一个个数据表使用foreach循环。下面的code是我迄今。但它似乎并没有工作。您的帮助将非常AP preciated。

 的foreach（在myTable.Rows的DataRow行）
 {
     双I;
     双J = Convert.ToDouble（行[X]）;
     INT Y = 1;     INT AAN =（int）的行[年];         如果（Y == AAN）
         {
            I = J + 2;
         }     行[X] =我;
     row.EndEdit（）;
     myTable.AcceptChanges（）;  }
 

解决方案

在code正常工作对我来说，除了一些调整。在code为如下：

 的foreach（在myTable.Rows的DataRow行）
        {
             双I = 0;
             双J = Convert.ToDouble（行[X]）;
             INT Y = 1;             INT AAN = Convert.ToInt32（行[年]）;                 如果（Y == AAN）
                 {
                    I = J + 2;
                 }             行[X] =我;
             row.EndEdit（）;
             myTable.AcceptChanges（）;        }
 

您面临的任何具体问题？

I want to update all columns one by one in a datatable using a foreach loop. The code below is what I have so far. But it does not seem to work. Your help will be much appreciated.

 foreach (DataRow row in myTable.Rows) 
 {
     Double i;
     Double j = Convert.ToDouble(row["x"]);
     int y = 1;

     int aan = (int)row["year"];

         if(y == aan) 
         {
            i = j + 2;
         }

     row["x"]=i;
     row.EndEdit();
     myTable.AcceptChanges();

  }

解决方案

The code works fine for me, except for a few tweaks. The code is given below:

        foreach (DataRow row in myTable.Rows) 
        {
             Double i = 0;
             Double j = Convert.ToDouble(row["x"]);
             int y = 1;

             int aan = Convert.ToInt32(row["year"]);

                 if(y == aan) 
                 {
                    i = j + 2;
                 }

             row["x"]=i;
             row.EndEdit();
             myTable.AcceptChanges();

        }

Are you facing any specific issues?

这篇关于如何更新在一个DataTable这在foreachloop一列的值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！