How do I delete data from datagridview1 that shows up in datagridview2 in C#

Question

1.00/5 (1 vote)

See more:

Im trying to compare two datagridviews to see if they have the same data(barcode) and if they do delete it from the first datagridview.

What I have tried:

private void button7_Click(object sender, EventArgs e)
{
    for (int i = 0; i < RemakesGv.Rows.Count; i++)
    {
        var row1 = RemakesGv.Rows[i].Cells;
        var row2 = RzrBack2Gv.Rows[i].Cells;

        for (int j = 0; j < row1.Count; j++)
        {
            if (!row1[j].ToString().Equals(row2[j].Value.ToString()))
            {

                RzrBack2Gv.Rows[i].Cells.RemoveAt(j);
            }
        }
    }

Posted 27-Apr-22 3:45am

Member 14804208

Updated 29-Apr-22 4:37am

v2

Add a Solution

Comments

[no name] 27-Apr-22 11:41am

You need a "reject event handler"; and only you know the how, when, what, where and why that triggers it.

Member 14804208 2-May-22 9:40am

How would that look?

Richard MacCutchan 29-Apr-22 7:52am

What is the question?

Member 14804208 2-May-22 9:38am

It doesnt work. I was looking for a working example of how to do this. I am new to programming. Thanks

Richard MacCutchan 2-May-22 10:08am

What doesn't work? Please ensure that you provide full details of your problem.

Member 14804208 2-May-22 13:26pm

Exception unhandled.
Colletion aready belongs to a datagridview control. This operation is no longer valid.

Richard MacCutchan 2-May-22 14:49pm

You cannot delete a single cell from a DataGridView Row. You can only delete the complete row.

Member 14804208 2-May-22 13:29pm

last line at RzrBack2Gv.Rows[i].Cells.RemoveAt(j);

Member 14804208 2-May-22 13:45pm

RemakesGv RzrBackGv
234776 345677
234765 345798
234778 234779
234779 345662
233456 345768

234779 is in RemakesGv so I would want to delete it from RzrBackGv. I would like it to happen without ever hitting a button. Use a timer?

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)

CHill60 · Answer 1 · 2022-04-29T04:37:00

When deleting from collections by index, don't start at the front and work through to the end.
Start at the end and work backwards to the front.

Imagine you have 4 rows of data

Row # Data
1     Data Row 1
2     Data Row 2
3     Data Row 3
4     Data Row 4

Say you want to delete rows number 4 and 1. Start at the top and delete the first row and see what happens

Row # Data
1     Data Row 2
2     Data Row 3
3     Data Row 4

I.e. what was row number 2 is now row number 1 ... and there is no longer a row number 4

If you do it the other way around ... start at the end and delete row number 4

Row # Data
1     Data Row 1
2     Data Row 2
3     Data Row 3

Rows 1,2 and 3 "stay" where they were and can still be referenced by their original row numbers

EDIT after OP comment
Instead of using a loop counter that looks like this

C#

for (int j = 0; j < row1.Count; j++)

you would use a loop that looks more like this (warning - untested code)

C#

for (int j = row1.Count - 1; j >=0; j--)

Things to note:
1. The "start" of the loop is the number of rows minus 1 - because the row counter starts at zero.
2. The loop termination (j >= 0 must include 0
3. instead of counting j upwards (j++) you decrement j (count down) with j==