Click here to Skip to main content
12,397,027 members (68,844 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: Access table Microsoft
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 3:42am
Updated 3-Aug-12 3:46am
Wes Aday104.2K
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 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 3 Aug 2012
Copyright © CodeProject, 1999-2016
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