c# - Populating a UIPickerView with data from Sqlite DataBase in IPhone App -- -


i have sqlite database table 'bikeinfo' 

[bikeid, bikename]

now want pickerview populated names of bikes database. in .net easy. being complete beginner in monotouch, have got no clue how approach problem. did googling , found out have create kind of custom class extending uipickerviewmodel class , override various methods. that's it. not find sample code, tutorial or anything. have been battling 3 days now. totally confused. far have written function fetching data table , returning list of class objects[that have written containing properties bikename , bikeid]. maybe looking in wrong places. need done ever way.

any kind of tutorial, or sample code in c# dealing target-specific scenario helpful me.

the next objective show alert message showing corresponding bike id when user touches 1 particular item. think have define selected event in custom class. have picked internet.

thanks.

this have done far. have created class containing properties bikeid , bikename.

namespace astonapp { public class pickerfacilitytemplate { public pickerfacilitytemplate () { } public int bikeid{get; set;} public string bikename{get; set;} } }

after have written function in database handler class returns list of class objects of above class type. 

public list<pickerfacilitytemplate> fetchfacility() { dataset ds = new dataset (); string sql = "select * bikeinfo order bikename"; 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.bikeid=convert.toint32(ds.tables[0].rows[i]["bikeid"].tostring()); pft.bikename=ds.tables[0].rows[i]["bikename"].tostring (); objfcl.add (pft); } this.closedbconnection (); return objfcl.tolist (); } public class pickerdatamodelsource: uipickerviewmodel { public pickerdatamodelsource () { } public pickerdatamodelsource (list<pickerfacilitytemplate> lst) { this.items=lst; } public event eventhandler<eventargs> valuechanged; public list<pickerfacilitytemplate> items; list<pickerfacilitytemplate> _items = new list<pickerfacilitytemplate>(); public pickerfacilitytemplate selecteditem { { return this._items[this._selectedindex]; } } 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) { return items[row].bikename.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 ()); } } }

now in class file of screen have pickerview, have written,

pickerdatamodelsource _pickersource;

and in viewdidload method:

this.picker.source=this._pickersource; this.picker.model=this._pickersource;

but when run application, pickerview blank. missing something? error in logic?

thanks.

one example of how use picker in "kitchen sink" sample - https://github.com/xamarin/monotouch-samples/tree/master/monocatalog-monodevelop - in https://github.com/xamarin/monotouch-samples/blob/master/monocatalog-monodevelop/pickerviewcontroller.xib.cs

in general, find repo essential lots of mt dev tasks.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more