A ResetBindings on a BindingSource of a Grid also resets ComboBox
- by Tetsuo
Hi there,
I have a DataGridView with a BindingSource of products. This products have an enum (Producer).
For the most text fields (to edit the product) below the DataGridView I have a method RefreshProduct which does a ResetBindings in the end to refresh the DataGridView. There is a ComboBox (cboProducer), too.
If I run over the _orderBs.ResetBindings(false) it will reset my cboProducer outside the DataGridView, too. Could you please help me to avoid this?
Here follows some code; maybe it is then better to understand.
public partial class SelectProducts : UserControl
{
private AutoCompleteStringCollection _productCollection;
private ProductBL _productBL;
private OrderBL _orderBL;
private SortableBindingList<ProductBE> _listProducts;
private ProductBE _selectedProduct;
private OrderBE _order;
BindingSource _orderBs = new BindingSource();
public SelectProducts()
{
InitializeComponent();
if (_productBL == null)
_productBL = new ProductBL();
if (_orderBL == null)
_orderBL = new OrderBL();
if (_productCollection == null)
_productCollection = new AutoCompleteStringCollection();
if (_order == null)
_order = new OrderBE();
if (_listProducts == null)
{
_listProducts = _order.ProductList;
_orderBs.DataSource = _order;
grdOrder.DataSource = _orderBs;
grdOrder.DataMember = "ProductList";
}
}
private void cmdGetProduct_Click(object sender, EventArgs e)
{
ProductBE product = _productBL.Load(txtProductNumber.Text);
_listProducts.Add(product);
_orderBs.ResetBindings(false);
}
private void grdOrder_SelectionChanged(object sender, EventArgs e)
{
if (grdOrder.SelectedRows.Count > 0)
{
_selectedProduct = (ProductBE)((DataGridView)(sender)).CurrentRow.DataBoundItem;
if (_selectedProduct != null)
{
txtArticleNumber.Text = _selectedProduct.Article;
txtPrice.Text = _selectedProduct.Price.ToString("C");
txtProducerNew.Text = _selectedProduct.ProducerText;
cboProducer.DataSource = Enum.GetValues(typeof(Producer));
cboProducer.SelectedItem = _selectedProduct.Producer;
}
}
}
private void txtProducerNew_Leave(object sender, EventArgs e)
{
string property = CommonMethods.GetPropertyName(() => new ProductBE().ProducerText);
RefreshProduct(((TextBoxBase)sender).Text, property);
}
private void RefreshProduct(object value, string property)
{
if (_selectedProduct != null)
{
double valueOfDouble;
if (double.TryParse(value.ToString(), out valueOfDouble))
{
value = valueOfDouble;
}
Type type = _selectedProduct.GetType();
PropertyInfo info = type.GetProperty(property);
if (info.PropertyType.BaseType == typeof(Enum))
{
value = Enum.Parse(info.PropertyType, value.ToString());
}
try
{
Convert.ChangeType(value, info.PropertyType, new CultureInfo("de-DE"));
info.SetValue(_selectedProduct, value, null);
}
catch (Exception ex)
{
throw new WrongFormatException("\"" + value.ToString() + "\" is not a valid value.", ex);
}
var produktFromList = _listProducts.Single(p => p.Position == _selectedProduct.Position);
info.SetValue(produktFromList, value, null);
_orderBs.ResetBindings(false);
}
}
private void cboProducer_SelectedIndexChanged(object sender, EventArgs e)
{
var selectedIndex = ((ComboBox)(sender)).SelectedIndex;
switch ((Producer)selectedIndex)
{
case Producer.ABC:
txtProducerNew.Text = Constants.ABC;
break;
case Producer.DEF:
txtProducerNew.Text = Constants.DEF;
break;
case Producer.GHI:
txtProducerNew.Text = Constants.GHI;
break;
case Producer.Another:
txtProducerNew.Text = String.Empty;
break;
default:
break;
}
string property = CommonMethods.GetPropertyName(() => new ProductBE().Producer);
RefreshProduct(selectedIndex, property);
}
}
