M
Mr. B
I got this bit of Code from a book (ADO.net). I changed the appropriate info
to match my situation. But when I run things, I get an error:
--> Input string was not in a correct format
This happens on the fourth line (starting with rowEdit)
dim strUserID as String = "FEU001"
' Check for NULL or Zero (0) Values and Reject Then
Dim rowEdit As DataRow
rowEdit = DsEditData.Tables("tblTimeEntry").Rows.Find(strUserID)
If rowEdit.IsNull("UserHrs") Then
MsgBox("Null Value Found")
Else
MsgBox("Value OK")
End If
I've no highlighted errors... any everything looks okay. What I'm trying to
do is to trap NULLS and Zero values in a Column (the above is my testing of
the Code). So far no luck.
Any idea?
Regards,
Bruce
to match my situation. But when I run things, I get an error:
--> Input string was not in a correct format
This happens on the fourth line (starting with rowEdit)
dim strUserID as String = "FEU001"
' Check for NULL or Zero (0) Values and Reject Then
Dim rowEdit As DataRow
rowEdit = DsEditData.Tables("tblTimeEntry").Rows.Find(strUserID)
If rowEdit.IsNull("UserHrs") Then
MsgBox("Null Value Found")
Else
MsgBox("Value OK")
End If
I've no highlighted errors... any everything looks okay. What I'm trying to
do is to trap NULLS and Zero values in a Column (the above is my testing of
the Code). So far no luck.
Any idea?
Regards,
Bruce