How do I insert my radio button information into a sql database?

Viewed 12

I want to insert the information of my radiobutton in my sql database, but I get a syntax error

Dim sql As String = "Insert into T_etudiants (etu_da, pro_no, etu_nom, etu_prenom,   
etu_sexe, etu_adresse, etu_ville, etu_province, etu_telephone, etu_codepostal) values 
(@da, @no, @nom, @prenom @sexe, @add, @ville, @province, @tel, @cp)"
        Dim comAjout As New SqlCommand(sql, CN)
        Dim gender As Char
        If rbtnmasc.Checked Then
            gender = "M"
        ElseIf rbtnfem.Checked Then
            gender = "F"
        ElseIf rbtnchaise.Checked Then
            gender = "C"
        End If
comAjout.Parameters.AddWithValue("@sexe", gender)

Incorrect Syntax

0 Answers
Related