Conversion from type "DBNill" to type "Integer" is not valid

Tiong Diu King — Sat, 11 Sep 2010 07:23:04 GMT

Hi all,

My BO get value cannot convert the null value to integer and show the error as image attached.
I did tried to change the get's coding in BO property as coding below and it's work. If i rebuild partial for that BO, it's coding back to original.
I'm license strataframe user and i got the framework coding. Please advice me how do i change the Generate BO code in strataframe framework.

   ''' <summary>
    ''' iPrdPeriodN_FK
    ''' </summary>
    <Browsable(False), _
     BusinessFieldDisplayInEditor(), _
     Description("iPrdPeriodN_FK"), _
     DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _
    Public Property [iPrdPeriodN_FK]() As System.Int32
        Get
            'Return CType(Me.CurrentRow.Item("iPrdPeriodN_FK"), System.Int32)
                        If Convert.IsDBNull(Me.CurrentRow.Item("iPrdPeriodN_FK")) Then
                Return 0
            Else
                Return CType(Me.CurrentRow.Item("iPrdPeriodN_FK"), System.Int32)
            End If

        End Get
        Set(ByVal value As System.Int32)
            Me.CurrentRow.Item("iPrdPeriodN_FK") = value
        End Set
    End Property

Please advice and thanks

RE: Conversion from type "DBNill" to type "Integer" is not valid

Ivan George Borges — Sat, 11 Sep 2010 07:23:04 GMT

You are welcome, Tiong. ;)

RE: Conversion from type "DBNill" to type "Integer" is not valid

Tiong Diu King — Sat, 11 Sep 2010 07:05:16 GMT

Hi all,

Mr. Ivan did solved my question at http://forum.strataframe.net/Topic28265.aspx?Update=1
Thanks Ivan

StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Conversion from type "DBNill" to type "Integer" is not valid

Conversion from type "DBNill" to type "Integer" is not valid

RE: Conversion from type "DBNill" to type "Integer" is not valid

RE: Conversion from type "DBNill" to type "Integer" is not valid