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