Using vbNull to insert NULL into a sql server database table

Question

I need to insert text MALE or FEMALE into a table depending upon the user's input.

I used to following code to insert but the code inserts value 1 if none (Male/Female) selected.

query = "INSERT INTO student_profile_table(gender) VALUES(@gender)"
cmd = New SqlCommand(query, con)

If rbtmale.Checked = True Then
   cmd.Parameters.AddWithValue("@gender", "Male")
ElseIf rbtfemale.Checked = True Then
   cmd.Parameters.AddWithValue("@gender", "Female")
Else
   cmd.Parameters.AddWithValue("@gender", vbNull)
End If

con.Open()
cmd.ExecuteNonQuery()
con.Close()

Need some suggestions/corrections

Brad Rem · Accepted Answer · 2013-08-12 14:09:24Z

9

I believe you want System.DbNull.Value instead of vbNull.

System.DbNull.Value is the constant that SQL Server understands as null.

vbNull is intended to indicate if a Variant type is null.

edited Aug 12, 2013 at 14:09

answered Aug 12, 2013 at 13:56

Brad Rem

6,0262 gold badges27 silver badges50 bronze badges

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

Comments

masteryeng · Accepted Answer · 2016-12-13 08:53:37Z

0

I've search in the net but I got no answer. What I did is I've used a blank image (totally white image) stored as default picture if no picture will be saved. Hoping this will help.

answered Dec 13, 2016 at 8:53

masteryeng

1

Comments

Davideveloper · Accepted Answer · 2020-03-04 19:58:51Z

0

I solved it this way to make set with NULL value.

 If yourVariable Is Nothing Then
    comm.Parameters.AddWithValue("@detalleDesc", DBNull.Value)
Else
    comm.Parameters.AddWithValue("@detalleDesc", yourVariable )
End If

Regards

answered Mar 4, 2020 at 19:58

Davideveloper

395 bronze badges

Collectives™ on Stack Overflow

Using vbNull to insert NULL into a sql server database table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related