Information générale
Titre:
Deleted row information cannot be accessed through the row.
Versions des environnements
Network:
Windows 2000 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement