How to read data from SQLite database?

I decided to use SQLite as it allows to store database into a single file. I think I have managed to do a database with SQLite Database Browser.

How can I read that data in a C/C++ program?