C# does not open the sqlite3 file

Question

I've created a SQLite3 Database by Datagrid and dragged and dropped it into the solution folder. It does not connect and it shows the following error. please, one very simple solution, I am new in OOP. Below is the screenshot.

thanks for your help.

Check that file is present by this path for your program. Cause when you start your program it usually starts in different folder, then the root folder of your project. Also please see this — Guru Stron
– Guru Stron, Commented May 25, 2020 at 17:46
hey many thanks for your reply! the file (Dokan.sqlite3) is the solution folder, as you see in the picture. but if you could be more specific with your explanation, it would really great. — Johny
– Johny, Commented May 25, 2020 at 17:53
Your code is executed from other path(when you run your code via IDE), not from the root of your solution. So "./Database/Dokan.sqlite3 will mean something like "%solution_dir%/bin/debug/Database/Dokan.sqlite3" See Tam's answer. — Guru Stron
– Guru Stron, Commented May 25, 2020 at 17:55
Please edit your question to convert images into text, and use a code block for any code you have. Readers can then search the text or run the code to reproduce your issue. — Black cat
– Black cat, Commented May 22 at 6:53

Tam Bui · Accepted Answer · 2020-05-25 17:52:39Z

2

Looks like your "./Database/Dokan.sqlite3" file was not copied to your binary output folder, therefore when your code executed, it couldn't find any db called "./Database/Dokan.sqlite3".

Example: If your binary output folder is in c:\blahblah\bin\Debug, then you need to copy your "./Database/Dokan.sqlite3" file from your project into that directory so that "c:\blahblah\bin\Debug\Database\Dokan.sqlite3" exists. Then when your CollectionTest.exe runs from c:\blahblah\bin\Debug, it will find the db file.

answered May 25, 2020 at 17:52

Tam Bui

3,0882 gold badges21 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Johny Over a year ago

I've marked it as answer, if I did it correctly. now I am trying to print the datas correctly. I hope, I can write clear codes.

Tam Bui Over a year ago

You're doing fine, Johny. Remember, "a smooth sea never made a skilled sailor"! :)

Johny Over a year ago

thanks, I found it but I need a lot more practice to become profi like you :)))), have a wonderful rest day!

Collectives™ on Stack Overflow

C# does not open the sqlite3 file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related