How to ask for a field if it

[Mischamel]

Hoi,

I

 

[sizer]

try with this code

If myPAMRow("TicketID") = System.DBNull.Value Then
...
...
End If

 

[Mischamel]

Good idea, thanks. But replace = with is

 

[Mischamel]

But it still isn

 

[sizer]

post some code where you delcare myPAMRow...

 

[Mischamel]

Dim myARSRow, myCQRow, myPAMRow As DataRow

 

[Mischamel]

and ... myPAMRow = Dataset11_PAMFilter.PAM.FindByTicketID(ARSID)

 

[sizer]

try with:

Dim myARSRow As New DataRow
Dim myCQRow As New DataRow
Dim myPAMRow As New DataRow

 

[sizer]

sorry that doesnt work

 

[sizer]

i think that you must add new row before you do anything
with row
more info at http://msdn.microsoft.com/library/d...ref/html/frlrfSystemDataDataRowClassTopic.asp

 

[MHWright]

try this code

if IsDbNull(datarow.item()) then
do something here
end if

 

[Mischamel]

Still got the same error, if I use MHWright

 

[sizer]

before checking if your row isNull you must do :

myRow = myDataSet.Tables(number/name of table ).NewRow()

because your row doesnt "know" where to look ( which table,dataset..... )

 

[Mischamel]

I thought it would because of the allocation above / following :
myPAMRow = Dataset11_PAMFilter.PAM.FindByTicketID(ARSID)

... and if the ARSID wouldn

 

[sizer]

if you want to check is your row is Nothing try with:

If myPAMRow Is Nothing Then
....
....
End If