I'm trying to delete multiple rows from a Microsoft Access table in C#

See more:

MS-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