How to solve database is locked error in sqlite

Hi All
I saw many website to see how we can solve "database is locked" error.
This error can come because :
1. Connection is not closed
2. Connection is not disposed properly
3. Command is not disposed
4. Sqlite database reader is not closed or disposed.

In my case i was getting some value from one table on loading of page/winform
And then trying to update same table if any changes is made by user.

Please comment below if anyone need code for this.

Thanks