"DBConcurrencyException was unhandled" error using C# with help of dodads and Microsoft Access 2003
<p>I got "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records" error when i try to update more than one records from Microsoft Access using C# with helping dodads. the code look like this, be sure dtStock has record from Access database, thanks. </p>

<pre><code>            dtStock = (DataTable)grStock.DataSource;
            BLL.StockOnHand answer = new BLL.StockOnHand();

            int id = 0;
            foreach (DataRow dr in dtStock.Rows)
            {
                 id=Convert.ToInt32(dr["ID"]);

                 if (id == 0)                     
                     answer.AddNew();                                              
                 else                     
                     answer.LoadByPrimaryKey(Convert.ToInt32(dr["ID"]));

                 answer.Product = Convert.ToInt32(dr["PID"]);
                 answer.StockOnHand = dr["Stock on Hand"].ToString();
                 answer.AvgMonthlyConsumption = dr["AMC"].ToString();
                 answer.EstMonthsOfStock = dr["Estimated Months of Stock"].ToString();
                 answer.Comments = dr["Comments"].ToString();
                 answer.LastModifiedDate = DateTime.Today;
                 answer.Updated = false;
                 answer.LogisticOfficerID = Convert.ToInt32(this.LogisticOfficer);
                 answer.YearValue = int.Parse(MainWindow.year);
                 answer.Quarter = MainWindow.quarter;
                 answer.Mon = MainWindow.month;
                 answer.FacilityID = MainWindow.facilityID;
                 answer.Save();                                                                                                                                                                                                                           
            }

            MessageBox.Show("Data is saved sucessfully!", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
</code></pre>
