Exception "Operator '>' is not defined for the 'DBNull' and type integer"

Question

How to handle this exception

Operator '>' is not defined for the 'DBNull' and type integer.

I am handling DBNull like this in my code.

rsGrp.Rows(i).Item("Dr") = IIf(
    rsTemp.Rows(0).Item("Debit") Is Nothing Or 
    rsTemp.Rows(0).Item("Debit") Is DBNull.Value, 
        0, 
        rsTemp.Rows(0).Item("Debit"))

stackoverflow.com/a/29611932/1070452

Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp

2015-04-18 13:17:15 +00:00
Commented Apr 18, 2015 at 13:17 — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Apr 18, 2015 at 13:17

akhil kumar · Accepted Answer · 2015-04-18 07:13:45Z

1

Try using .ToString = "" to check for DBNull

rsGrp.Rows(i).Item("Dr") = IIf(rsTemp.Rows(0).Item("Debit").ToString= "", 0, rsTemp.Rows(0).Item("Debit"))

hope it Works

answered Apr 18, 2015 at 7:13

akhil kumar

1,6261 gold badge14 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amir khan Sadozai Over a year ago

It is not working ,Similer error were shown ,Operator '>' is not defined for the 'DBNull' and type integer @ akhil kumar

Rahul Tripathi · Accepted Answer · 2015-04-18 07:10:06Z

0

You have to do a DbNull-check before you read the value. Something like

If Not IsDbNull(r("debit")) Then

    //code
End If

answered Apr 18, 2015 at 7:10

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Collectives™ on Stack Overflow

Exception "Operator '>' is not defined for the 'DBNull' and type integer"

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related