c# - Tableadapter 不更新

Question

我正在尝试更新一个 tableadapter。这是我的代码示例。

DestTableAdapter destTableAdapter = new DestTableAdapter();
MissioniDataSet.DestDataTable destDataTable =
           destTableAdapter.GetDataByMissioneID(MissioneID);
for(int i = 0; i < destDataTable.Rows.Count; i++)
{
    destRow = (MissioniDataSet.DestRow)destDataTable.Rows[i];
    destRow.AccontoMax = i;
}
destTableAdapter.Update(missioniDataSet.Dest);

怎么了？

谢谢

Answer 1

这是更正后的代码..

DestTableAdapter destTableAdapter = new DestTableAdapter();
MissioniDataSet.DestDataTable destDataTable =
           destTableAdapter.GetDataByMissioneID(MissioneID);
for(int i = 0; i < destDataTable.Rows.Count; i++)
{
    destRow = (MissioniDataSet.DestRow)destDataTable.Rows[i];
    destRow.AccontoMax = i;
}
destTableAdapter.Update(destDataTable);

You are updating with wrong object. In the Update call replace "missioniDataSet.Dest" with "destDataTable". Becuase you're practically having records in "destDataTable", you must update with "destDataTable" in the Update method.