Setting DataGridViewRow.Visible = false at run time

Setting DataGridViewRow.Visible = false at run time

• SacCourt

  I've uncovered the following problem with the solution above. In the DataBindingComplete event I was trying to make the row invisible.
  
  cm.SuspendBinding();
  for (int i = grdLineItems.Rows.Count - 1; i >= 0; i--)
  {
  if (Convert.ToBoolean(grdLineItems.Rows.Cells["IgnorePricing"].Value))
  grdLineItems.Rows.Visible = false;
  }
  }
  cm.ResumeBinding();
  
  
  The problem: If I add a row and then edit a cell, the CellValidated event is ignored. The order of events are:
  
  CellValidating
  DataBindingComplete
  CellValidated
  
  Does anyone know WHY the CellValidated event would NOT get fired when this occurs
  
  For me, this is bad because I have to hide rows, edit values, etc. with this grid.
  
  Stuart
  
  

• ossent

  Thank-you!!!

  I used your sample code for a search feature in my application. Setting the rows to invisible hides the rows which are not suitable. When the user clicks 'reset' my code is as follows:

  Dim cm As CurrencyManager

  cm = CType(BindingContext(dgvOperators.DataSource), CurrencyManager)

  cm.ResumeBinding()

  cm.Refresh()

  txtSearch.Text = ""

  Cheers,

  Luc

  
  

• Pau Wilson

  The code worked flawlessly... Thanks mate!!

  
  

• somersault

  thanks a million...that one has been buggin me for a couple days now.

  Cheers

  
  

• Tom Kane

  That means that the row you are trying to make invisible is currently being edited. End all edits before you try to make the row invisible.
  
  

• Kirk Haselden

  try again!!! You need to free up the currency manager something like this...

  if (DGV.Rows.Count > 0){

  CurrencyManager cm = (CurrencyManager)BindingContext[DGV.DataSource];

  int rowCount = cm.Count;

  for (int row = 0; row < rowCount; ++row)

  {

  DataGridViewRow dgvr = DGV.Rows[row];

  if (dgvr.Cells[0].Tag.ToString() != "Within 6 months")

  {

  cm.SuspendBinding();//<-----Money Shot!!!!

  dgvr.Visible = false;

  }

  }

  }

  
  

• manuli

  Hi,

  I am getting the same error although the code is a bit different but I am trying to do the same thing. Does anyone has an idea when and why this error occurs and how to fix it

  Thanks,

  Kunal

  
  
• Setting DataGridViewRow.Visible = false at run time