Windows Store App writing sqlite query into the listview's textblocks

Question

i am developing windows store application. I am using sqlite database and i want to put the result of select query into listview. My listview has grids, and textboxes inside these grids. But however i cannot target these textboxes in c# when i gave name to them. Here is the code sample from project: First sqlite query:

private void Page_Loaded(object sender, RoutedEventArgs e)
{
    string DBPath = string.Empty;
    DBPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "mydb.s3db");

    using (var db= new SQLite.SQLiteConnection(DBPath))
    {
        var query= db.Table();
        var result= query.ToList();

        foreach( var x in result )
        {
            company frm= new company();
            //addition to listview...
        }
    }

}

Everything works perfectly above except typing into listview. I have tested it with textblocks outside the listview.

and xaml:

Sorry for the long post, i wanted to give detailed information about the program then maybe you can see what went wrong. I would appreciate any help/feedback on this.

My regards...

Kenneth · Accepted Answer

You need to use databinding with the ListView.

First bind your collection to the ListView like this:

private void Page_Loaded(object sender, RoutedEventArgs e)
{
   ** snip **    
    using (var db= new SQLite.SQLiteConnection(DBPath))
    {
        var query= db.Table();
        lv.ItemsSource = query.ToList();
    }
}

After that you can bind inside the datatemplate to the properties on your object. Let's suppose your company-class is defined like this:

public class Company
{
    public string Name{get; set;}
}

Then you can do this inside your ItemTemplate:

When rendering each item, it will look at the current instance (of type company), extract the Name-property and put it as the value of the TextBlock.

Windows Store App writing sqlite query into the listview's textblocks

Answers (1)

Related Questions

Windows Store App writing sqlite query into the listview&#39;s textblocks

Answers (1)

Related Questions

Windows Store App writing sqlite query into the listview's textblocks