如何向已包含数据的数据表添加新列和数据? [英] How can I add a new column and data to a datatable that already contains data?

问题描述

如何向已经包含数据的 DataTable 对象添加新的 DataColumn?

How do I add a new DataColumn to a DataTable object that already contains data?

伪代码

//call SQL helper class to get initial data 
DataTable dt = sql.ExecuteDataTable("sp_MyProc");

dt.Columns.Add("NewColumn", type(System.Int32));

foreach(DataRow row in dr.Rows)
{
    //need to set value to NewColumn column
}

推荐答案

继续你的代码 - 你在正确的轨道上:

Just keep going with your code - you're on the right track:

//call SQL helper class to get initial data 
DataTable dt = sql.ExecuteDataTable("sp_MyProc");

dt.Columns.Add("NewColumn", typeof(System.Int32));

foreach(DataRow row in dt.Rows)
{
    //need to set value to NewColumn column
    row["NewColumn"] = 0;   // or set it to some other value
}

// possibly save your Dataset here, after setting all the new values

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