Need feedback from someone already collecting boolean data using controller.vb

GetNull(ModuleNameInfo.Checkbox.ToString)) does not work.  Either does:   .Checkbox.Checked.ToString      .Boolean    .bit   .Checkbox

How would boolean value be coded within controller.vb?


Is having:   @Checkbox bit    &    [Checkbox] [bit] NULL    the correct setting for booleans within SQLSTOREDPROCEDURES?


Looking for what is causing this error. Seems to reference the controller.vb file, but want to ensure the stored procedures are written correctly for boolean values too.



-machina12

Michael,

The boolean values are being stored as true/false.
Within sql queries 0=false, and 1=true.

I can store when using sql query no problem.
It is when trying to use it within the FormView (for dynamic users inputs, (not hardcoded))
So I have the checkbox within the FormView, just like textboxes.
I want to collect value if user has clicked checkbox.

Therefore, it runs straight to the controller.vb/info.vb
My code is hanging up at the controller.vb stage, but not sure why.

Everything that is presently collecting data in form view is a textbox, and is using controller method:   GetNull(ModuleNameInfo.Textbox.ToString)

It is when I try to add the checkbox with the same method, that I get the errors.  

What should code look like within controller.vb & info.vb for Boolean acceptance?



-machina12

Running that code still throws this error:  error BC30456: 'Checked' is not a member of 'Boolean'.

Tried with parenthesis and without.
GetNull(ModuleNameInfo.Equip.ToString), (ModuleNameInfo.Checkbox.Checked))
&
GetNull(ModuleNameInfo.Equip.ToString), ModuleNameInfo.Checkbox.Checked)


Setup Boolean within info:
_Checkbox As Boolean
' <summary>
' Gets and sets the Checkbox Value
' </summary>
Public Property Checkbox() As Boolean
Get
Return _Checkbox
End Get
Set(ByVal value As Boolean)
_Checkbox = value
End Set
End Property

Private

What else could I be missing?


-machina12