Dynamically Binding Data to ComboBox in Windows Store Apps using Sqlite Database

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);

     }

  }

}