0

i update my code with this code:

<code>sql = "UPDATE tableelements SET myelement= '" + textBox1.Text + "' WHERE id = '" + TextBox4 + "'";
command = new SQLiteCommand(sql, connectiondb);
command.ExecuteNonQuery();</code>

when i executed he's work perfectely without any problem but when i try it again i get an error who say: 

SQLite.SQLiteEXception(0x80004005): Database is locked

:( i dont know what ill do :(

help please

thedarkside
  • 11
  • 1
  • 7

1 Answers1

0

I am having the same issue. The community has been providing answers and I think the last one may help both of us. I am going to try and confirm it tonight. It involves 'using' blocks and the disposal of objects with unmanaged resources. Please look here and see if it helps you. my post

Community
  • 1
  • 1
Keith Kolbo
  • 15
  • 1
  • 5