Help with this code Please??
Can someone please help me with this?? I'm trying to check if a part already exists in the dataset. This will work if add a part say "6969"....then the next part I add is "6969"..that works fine...but if there is a part "6969"...then another "2002"....then I try and add "2002" again....it still adds it..and it shouldn't...so if anywhere in the dataset the part number is contained...dont add new record!!
Code:
Dim drCurrent as New Datarow
drCurrent = oldform9.mPartsNumber.NewRow()
drCurrent("PAR_NUMBER") = DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, 0)
If oldform9.mPartsNumber.Rows.Count < 1 Then
oldform9.mPartsNumber.Rows.Add(drCurrent)
Else
Dim thisItem As System.Data.DataRow
For Each thisItem In oldform9.PartsNumberData.Tables(0).Rows
If drCurrent("PAR_NUMBER") = oldform9.PartsNumberData.Tables(0).Rows.Item(0).Item(0).ToString() Then
MsgBox("equal")
Exit For
Else
MsgBox("not equal:")
oldform9.mPartsNumber.Rows.Add(drCurrent)
Exit For
End If
Next
End If
Thanks for the help in advance!!