>acceptchanges first. Better yet move update to another place so you have a chance to accept or reject pending deletions.

No Cetin, that's not correct ... if he does .AcceptChanges() before the .Update(), the .Update will not think there are any changes to be sent to the database.

Rene, I think the problem might not actually be the .Update(), but somewhere else in your program after you've updated and then you try to access the Deleted row. Cetin was halfway correct <g> ... do the .AcceptChanges() after you do the .Update().

~~Bonnie



>>Hi All,
>>
>>I have encountered error "'Deleted row information cannot be accessed through the row." when saving data.
>>
>>Below is the sample of my code.
>>
>>
>>using System;
>>using System.Drawing;
>>using System.Collections;
>>using System.ComponentModel;
>>using System.Windows.Forms;
>>using System.Data;
>>using System.Data.SqlClient;
>>using System.Data.OleDb;
>>
>>namespace SampleCode
>>{
>> ///

>> /// Summary description for Form1.
>> ///

>> public class Form1 : System.Windows.Forms.Form
>> {
>> private System.Windows.Forms.Button buttonLoad;
>> private System.Windows.Forms.Button buttonDelete;
>>
>> private SqlConnection objCnn = new SqlConnection("server=dbasrv03;Trusted_Connection=yes;database=northwind");
>> private SqlDataAdapter objDataAdapter = new SqlDataAdapter();
>> private DataSet objDataSet = new DataSet();
>> private DataRow objDataRow;
>> private SqlParameter workParam = null;
>>
>> // some c# generated code
>>
>> private void buttonLoad_Click(object sender, System.EventArgs e)
>> {
>> string lcSqlCmd;
>>
>> lcSqlCmd = "Select RegionID, RegionDescription from Region where RegionID = 123" ;
>> objDataAdapter.SelectCommand = new SqlCommand(lcSqlCmd, objCnn);
>> objDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
>> objDataAdapter.Fill(objDataSet, "Region");
>> objDataRow = objDataSet.Tables["Region"].Rows.Find(1);
>> }
>> private void buttonDelete_Click(object sender, System.EventArgs e)
>> {
>> objDataSet.Tables["Region"].Rows[0].Delete();
>> objDataAdapter.Update(objDataSet, "Region");
>> }
>> }
>>}
>>
>>Any idea about this problem.
>>The error occurs when i click the delete button.
>>
>>TIA,
>>
>>Rene
>
>acceptchanges first. Better yet move update to another place so you have a chance to accept or reject pending deletions.
>Cetin