C# datagrid how to hide delete following row if cell value meet condition

Question

0.00/5 (No votes)

See more:

Hello guys,
How to hide or remove following row if cell value meet the condition. Exaple

Column1 Column2 Column3
A. 1 H
H. 7 g
L. 9 f
B. 3 a

If Column2 cell value = 7 then stop on that row..the following row will hide or deleted..

I've been searching this for whole day but no luck...hope you can help me guys.

BTW. C# .Net Desktop Application

What I have tried:

Btw. DataGrid is bound in data table...

Posted 3-Sep-22 6:35am

NSIS 2022

Updated 5-Sep-22 2:59am

Add a Solution

Comments

Richard MacCutchan 4-Sep-22 3:30am

You need to remove the row from the DataTable and then refresh the DataGrid.

Maciej Los 4-Sep-22 4:44am

Sounds like an answer.

Richard MacCutchan 4-Sep-22 7:21am

If you think a guess is an answer. :)

2 solutions

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)

Maciej Los · Answer 1 · 2022-09-04T08:32:00

First of all - you can fetch into a datatable object only the data you want to get, by filtering a database in a query:

SQL

SELECT ...
FROM ...
WHERE Column2 <> 7;

Second - you can filter datatable object:
DataTable.Select Method (System.Data) | Microsoft Docs[^]

Third - filter data by Linq:
Filtering with DataView (LINQ to DataSet) - ADO.NET | Microsoft Docs[^]

There's probably few other ways to achieve that.

George Swan · Answer 2 · 2022-09-05T02:59:00

I am not sure how you are binding your data table to the view, but here are a couple of suggestions that may be useful. If it is permissable to exclude the row where Column2 is equal to 7, you can use TakeWhile.

C#

IEnumerable<DataRow> query= dataTable.AsEnumerable().
                           TakeWhile(r => long.Parse(r["Column2"].ToString()) != 7); 
var myDataTable = query.CopyToDataTable();

If you need to include the row where Coulumn2 is equal to a given value, you could wite a method similar to this.

C#

public  IEnumerable<DataRow> GetUpTo(Func<long,bool>isFirstOf)
    {
       foreach(var row in dataTable.AsEnumerable())
       {
          yield return row;
          if (isFirstOf(long.Parse(row["Column2"].ToString()))) break;
       }

    }

You can call it like this

C#

var redactedDataTable = GetUpTo(x=>x==7).CopyToDataTable();

C# datagrid how to hide delete following row if cell value meet condition

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0