Loading

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

Shaik Amair

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

1 Comment

Join the conversation! Your thoughts help the community grow.

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

}