Loop through two data grid view

Question

0.00/5 (No votes)

See more:

Hello,

i have two data grid views and in the first data grid view i have 3 column

ID SUBJECT RECEIVED

and second data grid view 8 columns

ID subject received date user etc

i want to check the subject line in the first data grid view with second data grid view's subject and say "matching" or " not matching in the "mark" column in second data grid view.

someone please help me with this double loop

What I have tried:

VB.NET

'Dim rowindex As String
        'Dim found As Boolean = False
        '' 
        'Dim i As Integer = 1

        'For Each row As DataGridViewRow In LiveinboxDataGridView.Rows
        '    For Each rowww As DataGridViewRow In ElapsedDataGridView.Rows
        '        Dim str As String
        '        str = TextBox1.Text
        '        Dim xxx As String = rowww.Cells.Item(10).Value

        '        MsgBox(xxx)
        '        MsgBox(row.Cells.Item(7).Value)
        '        If row.Cells.Item(7).Value = xxx Then
        '            ' rowindex = row.Index.ToString()
        '            found = True
        '            '  Dim actie As String = rowww.Cells("Received").Value.ToString()
        '            MsgBox("Found")
        '            '   Exit For
        '            'Exit For
        '        End If

        '    Next
        'Next
        'If Not found Then
        '    MsgBox("Item not found")
        'End If

Posted 12-Nov-16 20:36pm

Member 12430081

Updated 12-Nov-16 23:12pm

Add a Solution

Comments

[no name] 13-Nov-16 12:06pm

You would have to uncomment your code before it would actually do anything.

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)

OriginalGriff · Answer 1 · 2016-11-12T23:12:00

Solution 1

Start by simplifying that: Create a List Of String and populate it with the Subject values from the first DataGridView - that's a trivial For Each loop.
When you have that, you can use the Linq Contains method to check if the list contains each value: Enumerable.Contains(TSource) Method (IEnumerable(TSource), TSource) (System.Linq)[^] - it returns a Boolean which you can use to set the value of your Mark column directly.
That way, you don't need to nest the loops, and you process N1 + N2 loops, instead of N1 * N2

Posted 12-Nov-16 23:12pm

OriginalGriff

Comments

Member 12430081 13-Nov-16 13:11pm

Hi really appreciate your idea.. i never did it before.. can you post some link to any example..

OriginalGriff 13-Nov-16 13:32pm

You know how to do a for each loop on the rows, it's in your code.
And you can access the cell from the row - again in your code.
And you should know how to add an item to a list.
So which bit is giving you problems?