Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NULL field or not?

Status
Not open for further replies.

jennyek2000

Programmer
Sep 2, 2003
43
GB
Hi..

I keep coming back here to as questions, but now I need to know how do I find out if a particular field is NULL or not. I have this code, but theres a syntax error under DBNULL:

Dim mycurrentrow As DataRowView = CType(Me.BindingContext(mydataset, "jobs").Current, DataRowView)
If mycurrentrow.Item("JobStart") = DBNull Then
'CODE TO CARRY OUT IF NULL
End If

Thanks all,

Jenny
 
Jenny

try this

Code:
if isdbnull(mycurrentrow.item("jobstart"))
  'Code to trap Null
end if


WTrueman
...if it works dont mess with it
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top