如何添加两个数据表列。 [英] how to add two datatable column .

问题描述

先生，我有2个数据表，结果显示如下： -



Datatable1： -

sir, i have 2 datatable that result show like:-

Datatable1:-

Studentid --  marks
  101      --  6
  102      --  4
  103      --  5

Datatable2： -

Datatable2:-

Studentid  --- marks
  101       --  6
  102       --  7
  103       --  5

现在我需要第三个数据表来显示这两个数据表的添加。看起来像这样： -



Datatable3： -

now i need i third datatable that show the addition of this two datatables. and look like :-

Datatable3:-

Studentid  -- Marks
 101       -- 12
 102      --  11
 103     --   10

我该怎么办？

how can i do it?

推荐答案

试试这个！

Try this!

int length = 10 //considering 10 rows
for(int i = 0 ;i < length ; i++)
{
    DataRow drow = dt.NewRow();
    for(int k = 0;k < 2;k++) //Considering 2 columns
    {
         if(k % 2 == 0)
         {
              drow[k] = dt1.Rows[i][k].ToString(); // your student id from 1st table
         }
         else
         {
              drow[k] = (Convert.ToInt32(dt1.Rows[i][k]) + Convert.ToInt32(dt2.Rows[i][k])).ToString();   //dt2 your second table
         }
    }  
     dt.Rows.Add(drow);

}

你可以使用LINQ，它是一个C＃代码你可以找到相应的Vb代码>

You can use LINQ, Its a C# code you can find the corresponding Vb code here

var query =
    from table1 in Datatable1.AsEnumerable()
    join table2 in Datatable2.AsEnumerable()
    on Datatable1.Field <int>("Studentid") equals
    Datatable2.Field <int>("Studentid")
    select new
    {
        Studentid=
            Datatable1.Field <int>("Studentid"),
        Marks =
            Datatable1.Field <int>("marks") + Datatable2.Field <int> ("marks")
    };

这就是你要找的东西：合并内存中的两个数据表并将它们分组以获得列的总和 [ ^ ]



注意：将代码转换为vb.net



问候..

Is this what you are looking for : Merging two datatable in memory and grouping them to get sum of columns[^]

Note : Convert the code to vb.net

Regards..

这篇关于如何添加两个数据表列。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！