Create the table first:
public
string Country
{
public
string city
{
set;
get;
}
}
App.xaml.cs
Create the table :
db.createTable<country>();
Insert the default values in Table:
db.insert(new
Country{City="Hyderabad"});
db.insert(new
Country{city="Banglore"});
Xaml.cs
public
MainPage()
{
this.InitializeComponent();
DropList();
}
public
void DropLIst()
{
var Dbpath =
Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path,
"Smart.db3")
using (var db =new
SQLite.SQLiteConnection(Dbpath))
{
var query = db.Table<Country>();
var result =query.ToList();
foreach (var item in result)
{
Country obj =
new Country();
cba.Items.Add(item.city);
}
}
}