[RESOLVED] [2005] rw.Item("var") DBNull.Value

How do I check to see if rw.Item("Type") is Null and if it is skip it?

Code:

---

  Public Sub GetCodeType(ByVal Code As String)
        Dim rw As DataRow

        Me.DsCodeTypes1.Clear()
        Me.sdaCodeTypes.Fill(DsCodeTypes1)

        Dim TypeNumber As Integer = CInt(Mid(Code, 8, 5))

        For Each rw In Me.DsCodeTypes1.Tables("BarCode").Rows

            If Trim(rw.Item("BarCode_Unique")) = TypeNumber Then

                CodeType = rw.Item("Type")

---

Code:

---

IF Not rw.IsDBNull("Type") Then
  Do what ever here
End If

---

ISDBNull is not a member of System.Data.DataRow

Code:

---

If Not IsDBNull(rw.Item("type")) Then

---

Yeah thanks fellas. I can't wait till I'm smart enough to help others. ha