For further clarification:

I'm using an InfoObject which has several properties all corresponding to fields in the SQL Table.  One of those fields is a boolean.  I create an instance of the InfoObject in my code and assigns values to the various properties.  The boolean property in question (call it InfoOjbect.BooleanProperty) is not assigned anything.  I then call my StoredProcedure passing the InfoObject to it (using the DotNetNuke DAL architecture) and the final result is the Table's boolean column is populated with a 0 and not a NULL.  If I explicitly define the InfoObject.BooleanProperty = null.nullboolean before passing it to the Stored Procedure, the same thing happens.  How do I pass a null to the SQL database for a boolean field?  I've tried making InfoObject.BooleanProperty = dbnull.value but it won't let me do this saying "dbnull cannot be converted to a boolean."  Do I have to explicitly create my InfoObject properties to allow for a null to be assigned to it?

Any help would be greatly appreciated.  I'm using the DotNetNuke DAL architecture passing my InfoObject through a dataprovider to the sqldataprovider which calls the SQL Stored Procedure to add the new record to the Table.

Thanks in advance for any help.

---

I'm too poor for anything other than the community version

it sounds like you're using it correctly, I'm not sure what you're missing. The typical process would be

create your info object, add a private variable for your boolean,make sure you set your null boolean value in the constructor and then add a property for it, that you then use in your controller e.g.

in the *Info class

Class SomeInfoClass

private _myoptionalfield as boolean

public sub new()

_myoptionalfield=Null.NullBoolean

end sub

Public Property MyOptionalField() As Boolean
            Get
                Return _myoptionalfield
            End Get
            Set(ByVal Value As Boolean)
                _myoptionalfield= Value
            End Set
        End Property

end class

and then in the *controller

Class SomeControllerClass

 Public Sub WriteMyValues(ByVal objSomeInfoClass As SomeInfoClass)
            DataProvider.Instance.WriteMyValues(objScheduleHistoryItem.MyOptionalField)

        End Sub

End class

Cathal

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US