Datagridview

OuTCasT

I have 2 datagridviews on my form.
DGview1 gets its rows from a .xls form
and
DGview2 gets its rows from the SQL database

Now i need to loop through DGview1 and remove the rows that are equal to the rows that are in DGview2

Expand|Select|Wrap|Line Numbers

 dim row as datagridviewrow

for each row in datagridview1.rows

next

could anyone help me out ?

smartchap

I have not worked much on Datagridviews. But first of all read all the filled rows in DGview1 and store it as, say, RDGView1. then read filled rows in DGview2 and store it in, say, RDGView2. Now use two For loops, first for RDGView1 & inner one for DGView2. After first loop statement store all column data in a variable like DDGView1 for each row one by one and in inner loop save data of all columns for row in , say, DDGView2. It may be like this

Expand|Select|Wrap|Line Numbers

 
RDGView1=No. of filled rows in DGView1

RDGView2=No. of filled rows in DGView2

For i = 1 to RDGView1

     DDGView1=data of first col of row i + data of second col of i row + ...+data of last col of row i (of DGView1)

     For j = 1 TO RDGView2

         DDGView2=data of first col of row i + data of second col of i row + ...+data of last col of row i (of DGView2)

         IF DDGView2=DDGView1 then

            here delete row j of DGView2

         End If

     Next

Next

I think I tried to make a logic to be used.

OuTCasT

Expand|Select|Wrap|Line Numbers

 Try

            'remove all the unsubscribed entries from the upload grid

            Dim val3 As String = Nothing

            Dim val4 As String = Nothing
 
            'loop through DG1

            For Each row As DataGridViewRow In DataGridview1.Rows
 
                'Check datagridview 1 and get Value

                If Not (row.IsNewRow) Then val3 = DataGridview1.Rows(row.Index).Cells(0).Value.ToString
 
                'Loop through DG2

                For Each row1 As DataGridViewRow In DataGridView2.Rows
 
                    'Check DG2 and get Value

                    If Not (row1.IsNewRow) Then val4 = DataGridView2.Rows(row1.Index).Cells(0).Value.ToString
 
                    'Compare values and remove from DG1

                    If val3 = val4 Then

                        ' Remove the duplicate from the upload grid

                        If Not (row1.IsNewRow) Then DataGridview1.Rows.Remove(DataGridview1.Rows(row.Index))

                    End If

                Next

            Next

            PleaseWait.Close()

        Catch ex As Exception
 
        End Try

If i do it this way it only loops through DG1 once and removes the correct item and then its stops looping through

smartchap

After deleting / removing a row total no. of rows in that grid will change, i.e. will be 1 less than previous. So take care of this and after removing a row recalculate total no. of rows in that grid. I think it will help u.

Datagridview

re: Datagridview

re: Datagridview

re: Datagridview

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/about