I am trying to populate Picker with data from List that contains SQLite data.
I am doing it the same way I was doing in normal UWP project. However I get path to my Model class instead of Model value requested.
List<Rango> DB_RangoList = new List<Rango>();
DatabaseHelper db_helper = new DatabaseHelper();
DB_RangoList = db_helper.GetAllRangoData();
if(DB_RangoList != null)
{
foreach (var RangoNo in DB_RangoList)
{
RangoPicker.Items.Add(RangoNo.ToString());
}
}
And my db_helper looks like this:
public List<Rango> GetAllRangoData()
{
return (from data in sqliteconnection.Table<Rango>()
select data).ToList();
}
Model is like this:
[Table("Rango")]
public class Rango
{
[PrimaryKey, AutoIncrement]
public int Id { get; set; }
public string RangoNo { get; set; }
}
What is wrong in my approach?
The scope of your RangoNo
var in the foreach
would suggest that the code would read RangoPicker.Items.Add(RangoNo.RangoNo.ToString());