2.如果使用用户存储过程来替代表操作的话,并发问题的处理还需要一些额外的工作
3.Data Adapter配置向导能够创建存储过程来处理这个问题
4.当ContinueUpdateOnError为false(缺省值)时,在发生第一个冲突的时候会抛出DBConcurrencyException异常
5.捕获该异常并且通知用户,或者处理该异常或提示用户下一步需要做出哪些选择
1
DataSet changes
=
myDataSet.GetChanges();
2![](/Images/OutliningIndicators/None.gif)
3
try
4![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
5
mySqlDataAdapter.Update(changes);
6
myDataSet.Merge(changes);
7
}
catch
(DBConcurrencyException e)
8![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
9
//通知用户记录从上次更新到现在已经发生过变化,放弃更新
10
}
11
finally
![](https://www.cnblogs.com/Images/dot.gif)
12
更高级的操作模型:
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
8
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
11
![](/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/dot.gif)
12
![](/Images/OutliningIndicators/None.gif)
1
DataSet changes
=
myDataSet.GetChanges();
2![](/Images/OutliningIndicators/None.gif)
3
try
4![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
5
mySqlDataAdapter.ContinueOnError = true;
6
mySqlDataAdapter.Update(changes);
7![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
if(changes.HasErrors)
{
8
//获取错误
9
DataRow[] collisions = changes.Tables[0].GetErrors();
10
//处理错误
11
}
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)