如果有必要的话,UpdateCommand可以执行如下的操作
strCommandText = "If Exists(Select * From AT_ShippingParameter Where ShippingPropertyID = @ShippingPropertyID)";
strCommandText = strCommandText + " Begin";
strCommandText = "Update AT_ShippingParameter Set";
strCommandText = strCommandText + " ShippingPropertyID = @ShippingPropertyID, LBP = @LBP, dF = @dF, dA = @dA, dM = @dM)";
strCommandText = strCommandText + " Where ShippingPropertyID = @ShippingPropertyID";
strCommandText = strCommandText + " End";
strCommandText = "If Exists(Select * From AT_ShippingParameter Where ShippingPropertyID = @ShippingPropertyID)";
strCommandText = strCommandText + " Begin";
strCommandText = "Update AT_ShippingParameter Set";
strCommandText = strCommandText + " ShippingPropertyID = @ShippingPropertyID, LBP = @LBP, dF = @dF, dA = @dA, dM = @dM)";
strCommandText = strCommandText + " Where ShippingPropertyID = @ShippingPropertyID";
strCommandText = strCommandText + " End";
ada.InsertCommand = cmdInsert;
ada.UpdateCommand = cmdUpdate;
ada.DeleteCommand = cmdDelete;strTableName = "AT_ShippingParameter";
ada.Update(p_SourceDataSet, strTableName);for(int i = 0;i < p_SourceDataSet.Tables[strTableName].Rows.Count;i++)
{
p_SourceDataSet.Tables[strTableName].Rows[i][0] = p_SourceDataSet.Tables[strTableName].Rows[i][0];
}ada.SelectCommand = cmdSelect;
ada.InsertCommand = cmdInsert;
ada.UpdateCommand = cmdUpdate;
ada.DeleteCommand = cmdDelete;ada.Update(p_SourceDataSet, strTableName);