连接数据表中两列的值 [英] Joining Values Of Two Columns From DataTable

问题描述

连接数据表中两列的值两列使其成为数据表中的一列

Joining Values Of Two Columns From DataTable Two columns make it in one columns from datatable

我的数据表是

   TagNumber, LogNumber  Combined
    124           1         2
    125           1         3
    126           2         4
o/p:

     TagNumber 
    124 ~1~2          
    125 ~1~3         
    126 ~2~4         
 combined column is merge from column0 and column1

我不明白硬件我能做些什么请写代码示例

i dont understand hw can i do please write sample of code

我没有 linq 的经验.我添加列 bt hw 我可以合并那一列中的两列

I dont have experience on linq . I add column bt hw can i merge two columns in that one columns

I got answer:

For i As Integer = 0 To dstemp.Tables(0).Rows.Count - 1
dstemp.Tables(0).Rows(i)(0) = dstemp.Tables(0).Rows(i)("TagNumber") & "~" &      dstemp.Tables(0).Rows(i)("LogNumber") & "~" & dstemp.Tables(0).Rows(i)("Combined")
next

推荐答案

好吧，如果你真的想这样做，那么你已经创建了一个额外的三列数据表:

Ok if you really want to do this then you have create a extra DataTable with Three Columns:

TagNumber、LogNumber 组合:如下:

private DataTable CreateDataTableColumns()
{
    DataTable dtThreeItems = new DataTable();
    dtThreeItems.Columns.Add("TagNumber", typeof(String));
    dtThreeItems.Columns.Add("LogNumber", typeof(String));
    dtThreeItems.Columns.Add("Combined", typeof(String));
    return dtThreeItems;
}

现在按如下方式迭代旧数据表以获得组合值:

Now iterate the old datatable as below to get combined value:

foreach (DataRow dr in dtTwoItems.Rows)
            {
                row = dtThreeItems.NewRow();
                row["TagNumber"] = dr["TagNumber"].ToString();
                row["LogNumber"] = dr["LogNumber"].ToString();
                row["Combined"] = dr["TagNumber"].ToString()+"/"+dr["LogNumber"].ToString() ;
                dtThreeItems.Rows.Add(row);
            }

仅此而已

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