如何更新foreachloop中的数据表中的列中的值? [英] How to update a value in a column in a datatable which is in a foreachloop?

问题描述

我想使用 foreach 循环一一更新数据表中的所有列.下面的代码是我到目前为止所拥有的.但这似乎不起作用.您的帮助将不胜感激.

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?

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