Convert SQL Server BIT datatype to boolean VB.NET

Question

I'm a little rusty on my VB.NET especially when converting to SQL. I thought I had a simple task of hiding 2 buttons unless a checkbox is checked. The checkbox is bound to a SQL Server column with a bit data type.

My code is as follows:

Private Sub CaseVehicleCollisionCheckBox1_CheckedChanged(sender As Object, e As EventArgs) Handles CaseVehicleCollisionCheckBox1.CheckedChanged
    Dim collision As System.Data.SqlTypes.SqlBinary
    collision = CaseVehicleCollisionCheckBox1

    If collision = True Then
        btnVehicle1.Visible = True
        btnVehicle2.Visible = True
    ElseIf collision = False Then
        btnVehicle1.Visible = False
        btnVehicle2.Visible = False
    End If

End Sub

I keep getting the error

Value of type 'System.Windows.Forms.CheckBox' cannot be converted to 'System.Data.SqlTypes.SqlBinary'

when trying to assign the checkbox to the variable.

I get the same error when trying to use System.Data.SqlTypes.SqlBoolean

Once you're using Boolean rather than SqlBinary, also note that there's no need for the If statement. Just say btnVehicle1.Visible = collision and btnVehicle2.Visible = collision. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Apr 15, 2013 at 7:23

Jeremy Thompson · Accepted Answer · 2013-04-15 04:33:56Z

2

The problem is you are casting a CheckBox control to a SQLBinary datatype and that isn't going to work.

I presume CaseVehicleCollisionCheckBox1 is the name of the CheckBox. You need to use the CheckBoxes Checked property, eg:

Dim collision As Boolean
collision = CaseVehicleCollisionCheckBox1.Checked

answered Apr 15, 2013 at 4:33

Jeremy Thompson

66.3k38 gold badges225 silver badges344 bronze badges

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

1 Comment

Jeremy Thompson Over a year ago

@jstacy00 your welcome, there's a tickbox next to each answer, ticking it gives you a couple of points and saves people from spending time troubleshooting this by letting them know its working. Cheers!

Paul Anderson · Accepted Answer · 2013-04-15 04:40:59Z

0

Use SqlBoolean instead of sqlBinary. sqlBinary is the sql equivalent of an array of bytes.

answered Apr 15, 2013 at 4:40

Paul Anderson

1,1803 gold badges11 silver badges22 bronze badges

Collectives™ on Stack Overflow

Convert SQL Server BIT datatype to boolean VB.NET

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related