Hide all rows that do not match label

Question

0.00/5 (No votes)

See more:

I want to hide all rows in datagrid which do not match the text in Access.text label, How would I accomplish this?

foreach (DataGridViewRow row in productionDGV.Rows)
{
    if (row.Cells[4].Value.ToString() == Access.Text)
    {
        row.Visible = true;
    }
    else if (row.Cells[4].Value.ToString() != Access.Text)
    {
        row.Visible = false;
    }
}

What I have tried:

foreach (DataGridViewRow row in productionDGV.Rows)
 {
     if (row.Cells[4].Value.ToString() == Access.Text)
     {
         row.Visible = true;
     }
     else if (row.Cells[4].Value.ToString() != Access.Text)
     {
         row.Visible = false;
     }

Posted 5-May-18 14:25pm

Member 13765884

Updated 5-May-18 19:49pm

Add a Solution

Comments

Krunal Rohit 6-May-18 1:46am

And you're output with this code is ?

KR

Member 13765884 6-May-18 4:11am

It returns with a full table including the data which should be hidden

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2018-05-05T19:51:00

Solution 2

In general you can set the row as invisible by setting the Visible property to true. However, you may need to suspend the binding while setting the property. Consider the following, replace the myDataTable with the actual object you use as the data source.

C#

BindingContext[myDataTable].SuspendBinding();
foreach (DataGridViewRow row in this.productionDGV.Rows) {
   if (row.Cells[4].Value.ToString() != Access.Text) {
      row.Visible = false;
   }
}
BindingContext[myDataTable].ResumeBinding();

Posted 5-May-18 19:51pm

Wendelius

Comments

Member 13765884 6-May-18 6:55am

Thank you. I've written it as ...

BindingContext[productionBindingSource].SuspendBinding();
foreach (DataGridViewRow row in this.productionDGV.Rows)
{
if (row.Cells[4].Value.ToString() != Access.Text)
{
row.Visible = false;
}
}
BindingContext[productionBindingSource].ResumeBinding();

But now, The grid is coming up empty. as the debugger isn't coming up with an error- can you help please?

Wendelius 6-May-18 7:22am

You're now comparing Cell 0 (= first column), is that the correct cell?

Member 13765884 6-May-18 7:25am

No, it is not correct. I was trying to try different things to see if the error could be something else. It is still actually cell 4 that I'm trying to compare

Wendelius 6-May-18 11:22am

So if you use Cells[4] which is the 5th column does it work as expected?

Member 13765884 6-May-18 11:48am

no, it doesn't. I've tried all rows.

Wendelius 6-May-18 13:53pm

Okay, since I don't have the program nor the data it's qui hard to say what exactly goes wrong.

Try placing a breakpoint on the comparison line and when the breakpoint is hit, check why the comparison isn't working. For example, are there additional spaces in either the cell or label value or perhaps something else that makes the strings different.