MonoTouch with SQLite "Corporate Phonebook"

UPDATE [3-May-12]: The latest code for this sample is now on github (CorporateDirectory). It contains the latest version of SQLite.cs and minor bugfixes. Firstly, let me begin by saying this sample totally relies on the contribution of Frank Krueger who posted the SQLClient.cs code to the MonoTouch mailing list

Here is the code. Consider it released into the public domain. If there's interest, I can start a Google code project or something.

Many thanks Frank! This is a VERY simple application using that library: it lists 'employees' from an SQLite database and allows you to call or email them:
*
* note: may not adhere to iPhone user interface guidelines!

The c# code itself can be downloaded (26Kb) or browsed below:

• Main.cs
• MainWindow.xib.designer.cs
• Employee.cs
• SQLiteClient.cs

This first sample only reads from SQLite on the iPhone - just a single database call

using (var db = new SQLiteClient.SQLiteConnection("phonebook")) {
   db.Open();
   var users = db.Query(
      "SELECT Firstname, Lastname, Work, Mobile, 
      Department, Email 
      FROM Phonebook ORDER BY Lastname"
   , 1000);
   listData = users.ToList();
}

which queries data that was set-up in the SQLite Database Browser and included with the application as a 'Content' file within the MonoTouch project.



It uses UITableViewDelegate, UITableViewDataSource and UIAlertViewDelegate implementations to populate the scrolling list and react to touch 'events'.

When you touch a row, we use the OpenUrl method discussed previously to trigger a call or email.

Future additions to this sample might include alphabetized sections, search function and a proper 'user page' rather than using UIAlertView. Perhaps some hierarchical navigation and an online 'updater' function as well?

p.s. yes, I shouldn't have used INTEGER for the telephone numbers in SQLite... they seem to be overflowing. I will convert them to TEXT in a future post..