Refreshing GridView with database in WPF

[Maarten]

Hello Telerik team,

I am using your radGirdView for viewing some of my records in my database.
When I add a record in my database, the gridview does not refresh.

I am new to WPF and it is just a simple basic program.

Thanks in advance!
Maarten

public void refreshList()
        {
            MySqlConnection conn = new MySqlConnection(connString);
            personList.Clear();
            using (conn)
            {
                String sql = "SELECT * FROM personeel ORDER BY Naam;";
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                conn.Open();
                MySqlDataReader reader = cmd.ExecuteReader();
                StringBuilder htmlStr = new StringBuilder("");

                while (reader.Read())
                {
                    String Naam = htmlStr.Append(reader["Naam"]).ToString();
                    htmlStr.Clear();
                    String Voornaam = htmlStr.Append(reader["Voornaam"]).ToString();
                    htmlStr.Clear();
                    String Gsm = htmlStr.Append("0" + reader["GSM"]).ToString();
                    htmlStr.Clear();

                    personList.Add(new Person(Voornaam, Naam, Gsm));
                }
                conn.Close();
            }
            //gridView1 = new Telerik.Windows.Controls.RadGridView();

            gridView1.ItemsSource = personList;

            //CollectionViewSource.GetDefaultView(gridView1.ItemsSource).Refresh();

        }

[Siingh]

Since you are using database to bind records i would suggest you to rebind again with same example, so you put that code in one routine and call this routine again after grid operation, if you are using visualization then it will be very quick to load also.


in you XAML make sure you are using like this

DataMemberBinding="{Binding [Naam], Mode=TwoWay}"

this will help you to achieve that.


Kind Regards:

[Maarten]

Dear Siingh,

Thank you so much for your reply!

But the only thing I get when i try to make my columns myself I only get this:

<telerik:RadGridView x:Name="gridView1" Grid.Row="2" Width="295" Margin="4,1,0,4"
                             AutoGenerateColumns="False" ItemsSource="{Binding}"
                             RowIndicatorVisibility="Collapsed" IsFilteringAllowed="False"
                             AllowDrop="False" CanUserFreezeColumns="False" CanUserReorderColumns="False"
                             CanUserInsertRows="False" ShowGroupPanel="False" ShowColumnFooters="True"
                             AreRowDetailsFrozen="True" IsReadOnly="True"
                             Control.MouseDoubleClick="ListView_MouseDoubleClick" DataMember="{Binding Naam, Mode=TwoWay}">
            <telerik:GridViewColumn.RadGridView></telerik:GridViewColumn.RadGridView>

        </telerik:RadGridView>

This gives an error. There is no DataMemberBinding in the list of intellisense.

Thanks in advance!
Maarten

[Maarten]

Sorry i've been stupid, it's ok now for making my columns!

[Maarten]

I did it like you said Siingh, but it still doesn't refresh.

Any other ideas?

Thanks in advance!

Maarten

[Siingh]

Hi See this is what i used when i need to refresh the grid.

Dim dtTable As New DataTable()
           dtTable.Clear()
           boores = objSync.RawTimeSheet_GetAll(dtTable, expobj)
           If boores = False Then
               ShowError(expobj)
           End If
           GridDaily.ItemsSource = dtTable
           GridDaily.Rebind()

use GridView.Rebind() to rebind the item source from datatable or datasource.

Try this let me know if this helps you.

[Maarten]

Sorry, this does not help me.
It just won't refresh.

Edit: when I link the refreshList() to a button, it will work but i want it to refresh automatically when i add someone to the list.