/// <summary>
/// 修改數據表DataTable某一列的類型和記錄值(正確步驟：1.克隆表結構，2.修改列類型，3.修改記錄值，4.返回希望的結果)
/// </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);
}
//返回希望的結果
return dtResult;
}