Click here to Skip to main content
13,145,464 members (89,791 online)
Rate this:
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"))
               OleDbCommand command = new OleDbCommand(sSql, connection);
               command.Parameters.AddWithValue("?", Convert.ToInt32(txtEmployeeId.Text));
               OleDbDataReader myReader = command.ExecuteReader();
                   while (myReader.Read())
                       Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
                   // always call Close when done reading.
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

1 solution

Rate this: bad
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:[^]
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 |
Web02 | 2.8.170915.1 | Last Updated 3 Aug 2012
Copyright © CodeProject, 1999-2017
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