Hi,
I am trying to create a list of contract No that are not in the contract table given an excel row column.
However if record does not exist it throws an error
Any help in resolving this issue would be much appreciated.
Regards
For Each dr As DataRow In newContractDt.Rows
With arContract
.Init()
.Browse("FMTCONTNO = " & dr.Item(3).ToString, True)
If Not .Fetch(0) Then
'Else
Dim row As DataRow = tcardDettable.NewRow()
row("SEQ") = dr.Item(0)
row("LINENO") = dr.Item(1)
row("TIMECARDNO") = dr.Item(2)
row("FMTCONTNO") = dr.Item(3)
row("PROJECT") = dr.Item(4)
row("CATEGORY") = dr.Item(5)
tcardDettable.Rows.Add(row)
End If
End With
Next dr