how to invisible a row of Datagridview ?

Question

hi
i want to hide one or more row of datagridview that bind to dataset, but the following error shown me :

Row associated with the currency manager's position cannot be made invisible

 

how to solve this problem ?

Answer 1

As I understand it this is because the currently selected cell/row must be visible, I got around it by simply setting the currently selected cell to null before hiding the row:

Code Snippet

dataGridView1.CurrentCell = null;

dataGridView1.Rows[row].Visible = false;

Hope that helps.

*Edit* whoops, the currency manager problem is slightly more complicated than that:
Since you are bound to a dataset all you have to do is suspend the binding on all the rows in the currency manager before setting them to invisible:

Code Snippet

CurrencyManager currencyManager1 = (CurrencyManager)BindingContect[dataGridView1.DataSource];

currencyManager1.SuspendBinding();
dataGridView1.Rows[row].Visible = false;

Answer 2

In VB.NET it goes like this:

 

Code Snippet

Me.DataGridView.CurrentCell = Nothing

Me.DataGridView.Rows(index).Visible = False

 

 

 

This worked for me perfectly with a databound grid.

The only problem with this is that if the user wishes to sort the grid, it refreshes and makes all the rows visible again.

Answer 3

You can put the

Me.DataGridView.Rows(index).Visible = False

condition in DataGridView_MouseUp event

Answer 4

thanks alot vic!

Answer 5

"Row associated with the currency manager's position cannot be made invisible."

In VB.NET it goes like this:

 

Code Snippet

Me.DataGridView.CurrentCell = Nothing

Me.DataGridView.Rows(index).Visible = False

 

 

Yes, this is the method I used also.

You will see in other forums, like here:

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.windowsforms/topic25641.aspx

and here

http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=51563

that people recommend messing with the binding, but that just causes more problems, so I'd avoid that! I tried to reply on those threads when I found the solution, but I guess they are archived.

Glad the right answer is here.

Answer 6

Thanks it works...

Answer 7

that did not work for me. I got an index out of range error. This is what I did

                int iRowIndex = this.uiActionDates.SelectedRows[0].Index;
                this.uiActionDates.CurrentCell = null;
                this.uiActionDates.Rows[iRowIndex].Visible = false;

---

Luis Fleitas

Answer 8

wrong thread...

Answer 9

Tank you!!! Worked perfectly.

Answer 10

Thank you!!

It helped.

Answer 11

thank you

Answer 12

As I understand it this is because the currently selected cell/row must be visible, I got around it by simply setting the currently selected cell to null before hiding the row:

Code Snippet

dataGridView1.CurrentCell = null;

dataGridView1.Rows[row].Visible = false;

Hope that helps.

*Edit* whoops, the currency manager problem is slightly more complicated than that:
Since you are bound to a dataset all you have to do is suspend the binding on all the rows in the currency manager before setting them to invisible:

Code Snippet

CurrencyManager currencyManager1 = (CurrencyManager)BindingContect[dataGridView1.DataSource];

currencyManager1.SuspendBinding();
dataGridView1.Rows[row].Visible = false;

// Wanted to add the resume statement to make it complete. Thank You for the solution, this works perfect!

currencyManager1.ResumeBinding();

Answer 13

it works for me

cheers

Answer 14

It works fine,

but very slow, 10,000 rows(Visible or Invisble) takes 1 mint of time

Please

Thanks