How to refresh Bindingsource?

Mateusz Mistecki

17y42.8kLINQ

When I a do some changes in my table in database, and I want refresh bindingsource I use this code:

 housemateBindingSource.DataSource = from h in dc.Housemates
                                     select h;

This work. But for me most useful is this code:

 housemateBindingSource.DataSource = dc.Housemates;

but it dosen't work. I don't know why. Enobody help me?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jon Bellamy17y ago
Accepted answer
I'm not sure if this answers your question but I wanted to do the same thing and spent a week pulling my hair out before coming across the following which helped me ce.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, invoices); //ce is your datacontext / source, invoices is your bindingsource ICollectionView view = CollectionViewSource.GetDefaultView(lvInvoices.DataContext); //This was a listview being refreshed view.Refresh(); Hope it makes sense or helps - Jon
0
Igor Shtanko16y ago
And finally one more working solution.

This solution works fine and do not require recreating DataContext.

1. You need to reset internal Table cache.
for this you need change private property cachedList of Table using reflection.

You can use following utility code:

        public static class LinqDataTableExtension
        {
            public static void ResetTableCache(this ITable table)
            {
                table.InternalSetNonPublicFieldValue("cachedList", null);
            }

            public static void ResetTableCache(this IListSource source)
            {
                source.InternalSetNonPublicFieldValue("cachedList", null);
            }

            public static void InternalSetNonPublicFieldValue(this object entity, string propertyName, object value)
            {
                if (entity == null)
                    throw new ArgumentNullException("entity");
                if(string.IsNullOrEmpty(propertyName))
                    throw new ArgumentNullException("propertyName");

                var type = entity.GetType();
                var prop = type.GetField(propertyName, BindingFlags.NonPublic | BindingFlags.Instance);
                if (prop != null)
                    prop.SetValue(entity, value);
    // add any exception code here if property was not found :)
            }
        }

using something like:

       var dSource = Db.GetTable(...)
       dSource.ResetTableCache();

2. You need to reset your BindingSource using something like:

   _BindingSource.DataSource = new List