I haven't used the Picker much, but I would suggest trying to get it to
work first with some static data. Then once you understand how it works,
try plugging in "live" data from the db.
On Fri, Jul 6, 2012 at 3:00 AM, proindigo <pro_ind...@live.com> wrote:
> OK I have fixed the issue. Had to add an event to the
> PickerDataSourceClass.
> The error has disappeared. But I am not getting the items in my picker
> control. It is completely blank. This is how I have gone about the problem.
> Please go through the code listings below to have an understanding of my
> approach. Maybe you will be able to spot some logical mistakes.
>
> Here they are:-->
>
> PickerFacilityTemplate.cs
> ----------------------------------
> using System;
>
> namespace ASTONAPP
> {
> public class PickerFacilityTemplate
> {
> public PickerFacilityTemplate ()
> {
> }
>
> public int AssessmentID{get; set;}
> public int FacilityID{get; set;}
> public string FacilityName{get; set;}
> }
> }
>
>
> PickerFacilityTemplateGroup.cs
> ----------------------------------------
> using System;
> using System.Collections;
> using System.Collections.Generic;
> using System.Data;
> using System.IO;
> using MonoTouch.UIKit;
> namespace ASTONAPP
> {
> public class PickerFacilityTemplateGroup
> {
> public PickerFacilityTemplateGroup ()
> {
> }
>
> public List<PickerFacilityTemplate> Items
> {
> get { return this._items; }
> set { this._items = value; }
> }
> protected List<PickerFacilityTemplate> _items=new
> List<PickerFacilityTemplate>();
> }
> }
>
> PickerDataModelSource.cs
> ----------------------------------------------
> using System;
> using System.Collections;
> using MonoTouch.UIKit;
> using System.Configuration;
> using System.IO;
> using System.Collections.Generic;
> using Mono.Data.Sqlite;
> using System.Data;
> using System.Data.Common;
> namespace ASTONAPP
> {
> public class PickerDataModelSource: UIPickerViewModel
> {
> public PickerDataModelSource ()
> {
> }
>
> public PickerDataModelSource
> (List<PickerFacilityTemplateGroup> lst)
> {
> this.Items=lst;
> }
>
> public event EventHandler<EventArgs> ValueChanged;
>
> public List<PickerFacilityTemplateGroup> Items ;
>
>
> List<PickerFacilityTemplate> _items = new
> List<PickerFacilityTemplate>();
>
> public PickerFacilityTemplate SelectedItem
> {
> get
> {
> //return this._items[this._selectedIndex];
> return this._items[1];
> }
> }
> public int _selectedIndex = 0;
>
> public override int GetRowsInComponent (UIPickerView
> picker, int
> component)
> {
> return this._items.Count;
> }
>
> public override string GetTitle (UIPickerView picker, int
> row, int
> component)
> {
> List<string> titles=new List<string>();
> foreach(PickerFacilityTemplate pftp in _items)
> {
> //return
> this._items[row].FacilityName.ToString ();
> titles.Add (pftp.FacilityName.ToString ());
> }
> return titles.ToString ();
>
> }
> public override int GetComponentCount (UIPickerView picker)
> {
> return 1;
> }
>
> public override void Selected(UIPickerView picker, int
> row, int component)
> {
> this._selectedIndex = row;
> if (this.ValueChanged != null)
> {
> this.ValueChanged (this, new EventArgs ());
> }
> }
>
> }
> }
>
>
>
> The function in my DBHandler where I am fetching the items from database
>
> -------------------------------------------------------------------------------------------
> public List<PickerFacilityTemplate> FetchFacility()
> {
> DataSet ds = new DataSet ();
> string sql = "select * from ClientFacility order
> by FacilityName";
> this.CreateDBConnection ();
> SqliteDataAdapter sda = new SqliteDataAdapter
> (sql, sconn);
> sda.Fill (ds);
> List<PickerFacilityTemplate> objfcl=new
> List<PickerFacilityTemplate>();
> for(int i=0; i<ds.Tables[0].Rows.Count; i++)
> {
> PickerFacilityTemplate pft=new
> PickerFacilityTemplate();
>
>
> pft.AssessmentID=Convert.ToInt32(ds.Tables[0].Rows[i]["AssessmentID"].ToString
> ());
>
>
> pft.FacilityID=Convert.ToInt32(ds.Tables[0].Rows[i]["FacilityID"].ToString
> ());
>
> pft.FacilityName=ds.Tables[0].Rows[i]["FacilityName"].ToString
> ();
> objfcl.Add (pft);
> }
> this.CloseDBConnection ();
> return objfcl.ToList ();
> }
>
> The function where I am calling the above function
> -----------------------------------------------------------------
> public void PopulatePickerItems()
> {
> List<PickerFacilityTemplateGroup> pickerItems =
> new
> List<PickerFacilityTemplateGroup> ();
> PickerFacilityTemplateGroup pGroup;
> pGroup=new PickerFacilityTemplateGroup();
> List<PickerFacilityTemplate> pft=new
> List<PickerFacilityTemplate>();
> objdbh=new DBHandler();
> pft=objdbh.FetchFacility ();
> foreach(PickerFacilityTemplate pkft in pft)
> {
> pGroup.Items.Add (new
> PickerFacilityTemplate()
> {
>
> AssessmentID=Convert.ToInt32(pkft.AssessmentID.ToString ()),
>
> FacilityID=Convert.ToInt32(pkft.FacilityID.ToString ()),
>
> FacilityName=pkft.FacilityName.ToString ()
>
> });
> }
> pickerItems.Add (pGroup);
> this._pickerSource = new PickerDataModelSource
> (pickerItems);
> }
>
>
> And finally
> ---------------------------------------------------
> this.PopulatePickerItems ();
> this.Picker.Source=this._pickerSource;
>
>
> So where could the problem lie?
>
> Can you spot something?
>
> Thanks.
>
> --
> View this message in context:
> http://monotouch.2284126.n4.nabble.com/Implementing-UIPickerView-with-data-from-Database-tp4655796p4655798.html
> Sent from the MonoTouch mailing list archive at Nabble.com.
> _______________________________________________
> MonoTouch mailing list
> MonoTouch@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/monotouch
>
_______________________________________________
MonoTouch mailing list
MonoTouch@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/monotouch
