Checkbox insert to database from VB.NET

Question

I want to insert a checkbox value into a SQL Server database but it does not work. May I know how to insert that value into a SQL Server database?

This is my code:

Dim serUpdate As string

Try sConn.Open
    If checkbox.Checked = True Then
       serUpdate = "INSERT INTO xxxx(checkbox) VALUES ('Y')"
End If

sCmd.CommandText = serUpdate
sCmd.ExecuteNonQuery()

Catch ex As Exception
    Response.write(ex)

Finally

    sConn.Close()

End Try

What does "not work" mean? Does it error? Does it give unexpected behaviour? Becomes sentient? Help us help you. — Thom A
– Thom A ♦, Commented May 14, 2021 at 8:19
Boolean values are represented by an integer usually where 0 = false and <> 0 true — G3nt_M3caj
– G3nt_M3caj, Commented May 14, 2021 at 8:20
I would, personally, use a bit in SQL Server for a boolean, @G3nt_M3caj . — Thom A
– Thom A ♦, Commented May 14, 2021 at 8:22
@Larnu SQL Server BIT data type is an integer data type that can take a value of 0, 1, or NULL isn't it? :) — G3nt_M3caj
– G3nt_M3caj, Commented May 14, 2021 at 8:25
No, @G3nt_M3caj , it is not. It does not behave the same as a int. — Thom A
– Thom A ♦, Commented May 14, 2021 at 8:27

jmcilhinney · Accepted Answer · 2021-05-14 13:59:19Z

3

Using connection As New SqlConnection("connection string here"),
      command As New SqlCommand("INSERT INTO MyTable (MyBitColumn) VALUES (@MyBitColumn)", connection)
    command.Parameters.Add("@MyBitColumn", SqlDbType.Bit).Value = myCheckBox.Checked
    connection.Open()
    command.ExecuteNonQuery()
End Using

Done!

answered May 14, 2021 at 13:59

jmcilhinney

54.9k5 gold badges30 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

Checkbox insert to database from VB.NET

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related