How to refresh Bindingsource?

Question

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?

Jon Bellamy · 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

Igor Shtanko · Answer

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 (); _BindingSource.DataSource = dSource; // hack - refresh binding list 3. Enjoy :)

Mateusz Mistecki · Answer

Thank you guys for your answers. Using currency manager doesn't what I want in this case Niladri Biswas . Jon Bellamy yuor solution works great.

Niladri Biswas · Answer

You need to use currency manager. Here is a sample Step 1: Make a class called person //Person Class public class Person { private string _Name; private int _Age; public string Name { get { return _Name; } set { _Name = value; } } public int Age { get { return _Age; } set { _Age = value; } } } Step 2: //Declaration Of Person List Class System.Collections.Generic.List employees; Step 3: Insert some records to the datagrid whose source is the List Person k = new Person(); k.Name = txtName.Text; k.Age = Convert.ToInt32(txtAge.Text); employees.Add(k);//insert operation CurrencyManager cm = (CurrencyManager)this.BindingContext[employees]; cm.Refresh(); dgView.DataSource = employees; For more details about CurrencyManager, visit this link a) http://www.vkinfotek.com/sdatabinding.html b)http://en.csharp-online.net/DataViews_and_Data_Binding—CurrencyManager_and_BindingContext hope this helps Please vote