I'm trying to speed up a datagridview search that I'm using.

First I populates two different datagridviews (dgvVerktyg and dgvSökArtikelnummer) with a normal OleDbConnection
Then I do a search throuh both datagridviews to find a matching pair and add the reult to another datagridview (dgvResultat)

The problem is that the search takes about 60 sec to complete and it's to long for my clients

Is there any faster and easier way to do this?

<code>
For e As Integer = 0 To dgvSökArtikelnummer.Rows.Count - 1
If Not IsDBNull(dgvSökArtikelnummer.Item(1, e).Value) = True Then
'MsgBox(dgvSökArtikelnummer.Item(1, e).Value)

For a As Integer = 0 To dgvVerktyg.Rows.Count - 1
If Not IsDBNull(dgvVerktyg.Item(0, a).Value) = True Then
If Trim(dgvVerktyg.Item(0, a).Value).ToUpper = Trim(dgvSökArtikelnummer.Item(0, e).Value).ToUpper Then
dgvResultat.Rows.Add(dgvSökArtikelnummer.Item(0, e).Value, _
dgvVerktyg.Item(0, a).Value _
)

End If
End If

Next

End If
Next
</code>