Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi;I am trying to execute this code
//////////////////////////////////////////////////////////////////////
    string sSql = "delete from Vacation where EmployeeID = ?";
               using (OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Feras\Documents\Visual Studio 2008\Projects\Manshiah\Manshiah\MansheyaDB_be.mdb"))
               {
                   connection.Open();
                   OleDbCommand command = new OleDbCommand(sSql, connection);
                   command.Parameters.AddWithValue("?", Convert.ToInt32(txtEmployeeId.Text));
                   OleDbDataReader myReader = command.ExecuteReader();
                   try
                   {
                       while (myReader.Read())
                       {
                           Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
                       }
                   }
                   finally
                   {
                       // always call Close when done reading.
                       myReader.Close();
                       connection.Close();
                   }
///////////////////////////////////////////////////////
but it results this Exception: Deleted row information cannot be accessed through the row
Posted 3-Aug-12 4:42am
Edited 3-Aug-12 4:46am
Wes Aday94.3K
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Instead of
OleDbDataReader myReader = command.ExecuteReader();
I think you want to use
int numDeleted = command.ExecuteNonQuery();
And then obviously remove the myReader.Read() loop.
 
Here's a link for more information:
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.executenonquery.aspx[^]
  Permalink  
Comments
feras.abulhaija at 3-Aug-12 10:40am
   
thanks a lot it is done and worked correctly

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.1411022.1 | Last Updated 3 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100