并发冲突？怎么解决，十分感谢！！！

Question

连续操作是会发生并发冲突的错误，而且还有什么 updatecommand 影响的语句为0 和insertcommand 影响的语句为0的错误！private void ConnectToAccess(String sql)
{
     try
     {
String url=Environment.CurrentDirectory.ToString();
objOleDbConnection=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+url+"\\data.mdb");
        objOleDbDataAdapter=new OleDbDataAdapter(sql,objOleDbConnection);
objDataSet=new DataSet();
objOleDbDataAdapter.Fill(objDataSet,"results");
this.dgManageResult.DataSource=objDataSet.Tables["results"];
     }
     catch(Exception ex)
     {
MessageBox.Show(ex.Message);
     }}   
private void Manage_Load(object sender, System.EventArgs e)
{
this.cbxMType.Items.Add("全部");
for(int i=0;i<46;i++)
{
this.cbxMType.Items.Add(i.ToString());
}}
private void btnAdd_Click(object sender, System.EventArgs e)
{
string insCmd="insert into datasource (Type,[Group],ChineseName,Page,Part,Paragraph,SN,EnglishName,ProID,Re) values ( @Type,@Group,@ChineseName,@Page,@Part,@Paragraph,@SN,@EnglishName,@ProID,@Re)";
try
{
        String url=Environment.CurrentDirectory.ToString();
        objOleDbConnection=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+url+"\\data.mdb");
                objOleDbDataAdapter.InsertCommand=new OleDbCommand(insCmd,objOleDbConnection);
                objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@Type",System.Data.OleDb.OleDbType.Integer,4,"Type");
objOleDbParameter.SourceVersion=DataRowVersion.Current;
                objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@Group",System.Data.OleDb.OleDbType.Integer,4,"Group");
        objOleDbParameter.SourceVersion=DataRowVersion.Current; objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@ChineseName",System.Data.OleDb.OleDbType.VarChar,255,"ChineseName");
objOleDbParameter.SourceVersion=DataRowVersion.Current; objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@Page",System.Data.OleDb.OleDbType.Integer,4,"Page");
objOleDbParameter.SourceVersion=DataRowVersion.Current;         objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@Part",System.Data.OleDb.OleDbType.Integer,4,"Part");
objOleDbParameter.SourceVersion=DataRowVersion.Current; objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@Paragraph",System.Data.OleDb.OleDbType.Integer,4,"Paragraph");
objOleDbParameter.SourceVersion=DataRowVersion.Current; objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@SN",System.Data.OleDb.OleDbType.Integer,4,"SN");
objOleDbParameter.SourceVersion=DataRowVersion.Current; objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@EnglishName",System.Data.OleDb.OleDbType.VarChar,255,"EnglishName");
objOleDbParameter.SourceVersion=DataRowVersion.Current; objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@ProID",System.Data.OleDb.OleDbType.VarChar,50,"ProID");
objOleDbParameter.SourceVersion=DataRowVersion.Current; objOleDbParameter=objOleDbDataAdapter.InsertCommand.Parameters.Add("@Re",System.Data.OleDb.OleDbType.VarChar,255,"Re");
objOleDbParameter.SourceVersion=DataRowVersion.Current; if(objDataSet.HasChanges())
{
objOleDbDataAdapter.Update(objDataSet,"results");

}
objOleDbConnection.Close(); }
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}private void btnDelete_Click(object sender, System.EventArgs e)
{
try
{
//删除数据
string strsql = "delete from datasource where [id]=@id";
objOleDbDataAdapter.DeleteCommand = new OleDbCommand(strsql,objOleDbConnection); objOleDbParameter = objOleDbDataAdapter.DeleteCommand.Parameters.Add("@id",System.Data.OleDb.OleDbType.Integer,4,"ID");
objOleDbParameter.SourceVersion = DataRowVersion.Original; if(objDataSet.HasChanges())
{
DialogResult drt = MessageBox.Show("确定删除吗？","提示",MessageBoxButtons.YesNo);
if(drt == DialogResult.Yes)
{
//确定要输出的行
objDataSet.Tables[0].Rows[this.dgManageResult.CurrentRowIndex].Delete();
objOleDbDataAdapter.Update(objDataSet,"results");

}
}

}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
objOleDbConnection.Close();
}
private void btnUpdate_Click(object sender, System.EventArgs e)
{
        try
{
//修改数据
String url=Environment.CurrentDirectory.ToString();
objOleDbConnection=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+url+"\\data.mdb"); string strsql = "update datasource set Type=@Type,[Group]=@Group,ChineseName=@ChineseName,Page=@Page,Part=@Part,Paragraph=@Paragraph,SN=@SN,[EnglishName]=@EnglishName,[ProID]=@ProID,[Re]=@Re where [ID]=@id";
objOleDbDataAdapter.UpdateCommand = new OleDbCommand(strsql,objOleDbConnection); objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@id",System.Data.OleDb.OleDbType.Integer,4,"ID");
objOleDbParameter.SourceVersion = DataRowVersion.Original; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@Type",System.Data.OleDb.OleDbType.Integer,4,"Type");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@Group",System.Data.OleDb.OleDbType.Integer,4,"Group");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@ChineseName",System.Data.OleDb.OleDbType.VarChar,255,"ChineseName");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@Page",System.Data.OleDb.OleDbType.Integer,4,"Page");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@Part",System.Data.OleDb.OleDbType.Integer,4,"Part");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@Paragraph",System.Data.OleDb.OleDbType.Integer,4,"Paragraph");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@SN",System.Data.OleDb.OleDbType.Integer,4,"SN");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@EnglishName",System.Data.OleDb.OleDbType.VarChar,255,"EnglishName");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@ProID",System.Data.OleDb.OleDbType.VarChar,50,"ProID");
objOleDbParameter.SourceVersion = DataRowVersion.Current; objOleDbParameter = objOleDbDataAdapter.UpdateCommand.Parameters.Add("@Re",System.Data.OleDb.OleDbType.VarChar,255,"Re");
objOleDbParameter.SourceVersion = DataRowVersion.Current; if(objDataSet.HasChanges())
{
DialogResult drt = MessageBox.Show("确定要修改吗？","提示",MessageBoxButtons.YesNo);
if(drt == DialogResult.Yes)
{
objOleDbDataAdapter.Update(objDataSet,"results");

}
}

}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
objOleDbConnection.Close();
}private void btnMSeletct_Click(object sender, System.EventArgs e)
{
select();
}}
}

Answer 1

执行update方法后,你要调用AcceptChanges提交dataset的更改.如:
if(drt == DialogResult.Yes)
            {
                objOleDbDataAdapter.Update(objDataSet,"results");
                        objDataSet.AcceptChanges();
            }