/// <summary>
/// 修改數(shù)據(jù)表DataTable某一列的類型和記錄值(正確步驟：1.克隆表結(jié)構(gòu)，2.修改列類型，3.修改記錄值，4.返回希望的結(jié)果)
/// </summary>
/// <param name="argDataTable">數(shù)據(jù)表DataTable</param>
/// <returns>數(shù)據(jù)表DataTable</returns>
private DataTable UpdateDataTable(DataTable argDataTable)
{
DataTable dtResult = new DataTable();
//克隆表結(jié)構(gòu)
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);
}
//返回希望的結(jié)果
return dtResult;
}