Question

如何修改DataTable某一行中某一列的内容

Answer 1

/// </summary
/// <param name="argDataTable"数据表DataTable</param
/// <returns数据表DataTable</returns
private DataTable UpdateDataTable(DataTable argDataTable){
DataTable dtResult = new DataTable();
//克隆表结构
dtResult = argDataTable.Clone();
foreach (DataColumn col in dtResult.Columns){
if (col.ColumnName == "age"){
//修改列类型
col.DataType = typeof(String);}}
foreach (DataRow row in argDataTable.Rows){
DataRow rowNew = dtResult.NewRow();
rowNew["MemberId"] = row["MemberId"];
rowNew["NickName"] = row["NickName"];
//修改记录值
rowNew["age"] = row["age"] + "岁";
dtResult.Rows.Add(rowNew);}//返回希望的结果