.NET Listview Refresh

Question

I have the following code, which basically takes values from a database and populates a listview.

using (IDataReader reader = cmd.ExecuteReader())
{                    
    lvwMyList.Items.Clear();
    while (reader.Read())
    {
        ListViewItem lvi = lvwMyList.Items.Add(reader["Value1"].ToString());
        lvi.SubItems.Add(reader["Value2"].ToString());                    
    }
}

The problem that I have is that this is repeatedly executed at short intervals (every second) and results in the items in the listview continually disappearing and re-appearing. Is there some way to stop the listview from refreshing until it’s done with the updates? Something like below:

using (IDataReader reader = cmd.ExecuteReader())
{                    
    lvwMyList.Items.Freeze(); // Stop the listview updating
    lvwMyList.Items.Clear();
    while (reader.Read())
    {
        ListViewItem lvi = lvwMyList.Items.Add(reader["Value1"].ToString());
        lvi.SubItems.Add(reader["Value2"].ToString());                    
    }
    lvwMyList.Items.UnFreeze(); // Refresh the listview
}

Answer 1

lvwMyList.BeginUpdate();
//bla bla bla
lvwMyList.EndUpdate();

Answer 2

This is a 'known' probably with the ListView (actually the underlying Win32 class).

A better approach would be to use a DataGridView, make it look like a ListView (not hard), and then use a BindingList as a datasource.

Answer 3

You can also try setting the visible or enabled properties to false during the update and see if you like those results any better. Of course, reset the values to true when the update is done.

Another approach is to create a panel to overlay the listbox. Set it's left, right, height, and width properties the same as your listbox and set it's visible property to true during the update, false after you're done.