Deleting only for the first time (not the second time once)

Israel

Hi!

I wrote these to delete one row from database. Curiously, after to delete one and if I need to delete another I receive this message and don't want to delete another without restart my program. After to restart then Its can delete.

Error Message: The connection was not closed. The connection's current state is open

String strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\LunaFoods\LunaFoods\App_Data\office.mdb;Persist Security Info=False";
string query = "delete from cadastramento where nprocesso='" + lblnProcessoCadastramento.Text + "';";
OleDbConnection conDatabase = new OleDbConnection(strConnection);
OleDbCommand cmdDatabase = new OleDbCommand(query, conn);
OleDbDataReader myReader;
try
{
conn.Open();
myReader = cmdDatabase.ExecuteReader();
MessageBox.Show("Dados excluidos com exito. Obrigado!");
while (myReader.Read())
{
}

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Israel9y ago
See what I do. Still the same:
I open and close connection later.

String strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\LunaFoods\LunaFoods\App_Data\office.mdb;Persist Security Info=False";
string query = "delete from cadastramento where nprocesso='" + lblnProcessoCadastramento.Text + "';";
OleDbConnection conDatabase = new OleDbConnection(strConnection);
OleDbCommand cmdDatabase = new OleDbCommand(query, conn);
OleDbDataReader myReader;

try
{
conn.Open();
myReader = cmdDatabase.ExecuteReader();
MessageBox.Show("Dados excluidos com exito. Obrigado!");
while (myReader.Read())
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
Tapan Patel9y ago
You are getting an error due to opened connection which you are not closing in your code.

add below code after your try catch block to close the connection.
finally
{
conn.Close();
}
Harshal Thakre9y ago
after execution pl. close ur connection first

Way first:-

try { conn.Open(); myReader = cmdDatabase.ExecuteReader(); MessageBox.Show("Dados excluidos com exito. Obrigado!"); while (myReader.Read()) { } } catch (Exception ex) { MessageBox.Show(ex.Message); }

finally {
conn.close();
}
second way:-

try {
if(conn.State==ConnectionState.Closed)
{
conn.Open();
}

myReader = cmdDatabase.ExecuteReader();
MessageBox.Show("Dados excluidos com exito. Obrigado!");
while (myReader.Read()) { } } catch (Exception ex) { MessageBox.Show(ex.Message); }