Hi Jon, Most people seem to use Frank Krueger's SQLite-Net binding as opposed to System.Data because it's a bit simpler for most people.
As luck would have it, I'm working on trying to make a very easy to use / generic (literally!) MonoTouch library for displaying data from a sqlite database in a UITableViewController. I was planning about blogging about it this weekend when I had worked out some of the remaining kinks and such, but I can point you at it and the source code for my own personal app that uses it (I want to write a simpler showcase app before I blog this weekend). The SQLiteTableViewController library is at https://github.com/jstedfast/MonoTouch.SQLite You can see how I'm using it at https://github.com/jstedfast/FlightLog/blob/master/FlightLog/Flights/FlightViewController.cs It's a bit on the "advanced" side since it allows adding/deleting/editing logbook entries, but maybe that'll be helpful to you :-) In the simple case, you could just subclass SQLiteTableViewController<T> and get away with just implementing the following method: *protected override UITableViewCell GetCell (UITableView tableView, NSIndexPath path, T item)* So... a very simple TableViewController might look like this: // This represents an element in your sqlite database table named "Task" public class Task { [PrimaryKey][AutoIncrement] public int TaskId { get; set; } public string ToDo { get; set; } } public class TaskViewController : SQLiteViewController<Task> { static NSString key = new NSString ("TaskCellKey"); public TaskViewController () : base (sqlitedb, 16) { } protected override UITableViewCell GetCell (UITableView tableView, NSIndexPath path, Task task) { var cell = tableView.DequeueReusableCell (key); if (cell == null) cell = new UITableViewCell (UITableViewCellStyle.Plain, key); cell.TextLabel.Text = "Task"; cell.DetailTextLabel.Text = task.ToDo; return cell; } } The SQLiteTableViewController would then handle all of the searching logic for you... Hope that helps, Jeff On Fri, Mar 16, 2012 at 12:52 PM, JonW <[email protected]> wrote: > Hi there. I've been playing with MonoTouch on a Mac for a few days and > whilst > I'm getting there with several things (web services, customising the view > controllers etc) I am having real issues with SQLite. First off, there are > several types of data consumption via SQLite referred to in samples and on > other websites (SQLite-Net, Vici, MonoTouch.Data etc) - which is the > simplest method? Basically, my app will contain UITableViews and text boxes > and I want to be able to create my database (unless it already exists), > create tables (unless they already exist) and populate them on button > click, > bind UITableViews to queries (like I would bind GridViews in .Net), update > and delete from them by Id. Any suggestions of a good, fully working > example > of how to do this? I'm pulling my hair out here! > > Another example I need is how to bind UITableViews to the output from my > consumed .Net web services. > > Thank you for any help :-) > > Jon > > -- > View this message in context: > http://monotouch.2284126.n4.nabble.com/SQLite-iOS-binding-to-UITableView-tp4478704p4478704.html > Sent from the MonoTouch mailing list archive at Nabble.com. > _______________________________________________ > MonoTouch mailing list > [email protected] > http://lists.ximian.com/mailman/listinfo/monotouch >
_______________________________________________ MonoTouch mailing list [email protected] http://lists.ximian.com/mailman/listinfo/monotouch
