Check IsDBNull for BigInt 2

[ksbigfoot]

My Primary Key of my table is of type BigInt.
I load my data into a DataReader and then I call my function to see if the field is Null:

CheckDBNullBigInt(dr, 0)

Here is my function code:

Public Shared Function CheckDBNullInt(ByVal DataReader As IDataReader, ByVal iValue As Int32) As Int32

  If Not DataReader.IsDBNull(iValue) Then
     Return DataReader.GetInt32(iValue)
  End If

  Return 0
End Function

I keep getting the message: "Specified cast is not valid" on the line Return DataReader.GetInt32(iValue).
If I change it to return a Int64, I get the following message: "Option Strict On disallows implicit conversions from Long to Integer."

I am not sure how to pass back a BigInt?
Could someone point me in the right direction.

Thanks

 

[SiriusBlackOp]

Use Int64

Then either turn off Strict, or use DirectCast(iValue.ToString, Int64)

Senior Software Developer

http://www.scoutsft.com

 

[Mastakilla]

I would also use Int64 in that case (though I haven't taken the time to test it)

  Public Shared Function CheckDBNullInt(ByVal DataReader As IDataReader, ByVal iValue As Int32) As Int64

  If Not DataReader.IsDBNull(iValue) Then
     Return DataReader.GetInt64(iValue)
  End If

  Return converto.toInt64(0)
End Function

 

[ksbigfoot]

Thanks Mastakilla and SiriusBlackOp,
Star to you both. Thanks again Mastakilla, you code works perfectly.

ksbigfoot