Wpf Listview not populating with sqlite

Question

I am trying to populate a listview from sqlite database. My code is

using (SQLiteConnection connection = new SQLiteConnection(@"Data Source=c:\MyProjects\SqliteTest\TestData.db"))
        {
            connection.Open();
            SQLiteDataAdapter ad = new SQLiteDataAdapter();
            SQLiteCommand cmd = new SQLiteCommand();
            String str = "SELECT Name,Email FROM tblInfo";
            cmd.CommandText = str;
            ad.SelectCommand = cmd;
            cmd.Connection = connection;
            DataSet ds = new DataSet();
            ad.Fill(ds);
            myList.DataContext = ds.Tables[0].DefaultView;
            connection.Close();
        }

and the xaml code is like

<Grid>
    <ListView x:Name="myList" 
              Height="100" 
              HorizontalAlignment="Left" 
              Margin="10,10,0,0" 
              VerticalAlignment="Top"
              Width="300">
        <ListView.View>
            <GridView>
                <GridViewColumn Width="100" Header="Name"  DisplayMemberBinding="{Binding Path=Name}"></GridViewColumn>
                <GridViewColumn Width="100" Header="Email" DisplayMemberBinding="{Binding Path=Email}"></GridViewColumn>
            </GridView>
        </ListView.View>
    </ListView>
</Grid>

There is no error but list is empty.

Phil · Accepted Answer · 2012-04-24 07:29:02Z

1

You're setting the DataContext of the control to your DataSet. You either need to set the ListView's ItemSource to the DataSet, or bind the ItemSource to the DataContext, e.g.

<ListView ItemsSource={Binding}  ... />

answered Apr 24, 2012 at 7:29

Phil

43.2k9 gold badges102 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

blindmeis · Accepted Answer · 2012-04-24 08:00:01Z

1

Phil is right, but you can also change

 myList.DataContext = ds.Tables[0].DefaultView;

to

 myList.ItemsSource= ds.Tables[0].DefaultView;

answered Apr 24, 2012 at 8:00

blindmeis

22.5k7 gold badges59 silver badges81 bronze badges

Comments

weeyoung · Accepted Answer · 2012-04-24 05:46:09Z

-1

Dataset does not have interfaces INotifyCollectionChanged and INotifyPropertyChanged. so the UI does not know that the dataset has been populated.

If the dataset is changed once, you could bind (initialize) only after dataset is populated.

else, you could create a collection and implement the interfaces.

answered Apr 24, 2012 at 5:46

weeyoung

1725 bronze badges

Collectives™ on Stack Overflow

Wpf Listview not populating with sqlite

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related