Support My Blog
Download Free Games

ListBox & DB Interactions


ESET Smart Security - Save 25%

Hi,

Been some time. Was busy setting-up a new office in Kuala Lumpur. In between activities, I spared some time in transforming our previous project. Move over Text Files, here comes SQLite database.

The SQLite DB file is located in MyDocs (XP/P8/ME) or Documents (Vista) hosted in the folder named as MyResourceFolder. The folder and DB file will be created automatically when launching this App.

Mini Address Book with SQLite DB

Mini Address Book with SQLite DB

Some minor changes were made to the interface. I’ve also added more details but the functions remain the same:
1. Add New Entry
2. Delete Entries
3. Edit Entries
4. Search Entries
5. Group Entries
6. Rename Groups
7. Delete Groups
8. Share Items between Groups
9. Make a New Group from Search Results
10. Validate All Entries

Mini Address Book with SQLite

Mini Address Book with SQLite

Since this Project uses SQLite, we have removed previous concerns. We can now
1. Update Entries shared by several Groups all at once
2. Search every row in the DB directly without any help from ListBox.

Mini Address Book with SQLite

Mini Address Book with SQLite

For each item ( every DB row ), you might only see 4 data on the interface. In actual fact, this project is prepared for more than 10 data per item. This includes the usual suspects like Address, Zip Code, Street Name, Country, Birthday, Description, Notation and etc. I encourage readers to try embed more entries at the interface. This is the way to learn.

Mini Address Book with SQLite

Mini Address Book with SQLite

If you add Dermot’s Pop3 Plugin, you’re making an almost full-featured Email App. To learn more about SQlite DB on AMS, please view TJ Tigger’s Video.

Please Login or Register to download this file.

In the next topic on Mini Address Book, I plan to add 2 more features:
1. Photo for each Name
2. Calendaring.

We’ll see how it goes. If there is a request, I will make create another example just for the Search Function. Please use the comment in the Blog.

And please, leave your comments in this blog.

  • Share/Save/Bookmark

8 comments to ListBox & DB Interactions

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>