sql - incorrect syntax near 's' vb.net -
i'm getting error incorrect syntax near 's'
. error appears after inputting data in sql doesn't appear when same characters input error appears. error lined in executenonquery
conn = new sqlconnection(constr) conn.open() comm = new sqlcommand("insert admins(firstname, lastname, birthday, contact, email, address, username, password, securityq1, securityq2, securityi1, securityi2, securitya1, securitya2, type) values ('" & bunifumetrotextbox1.text & "','" & bunifumetrotextbox2.text & "','" & bunifudatepicker1.value & "','" & bunifumetrotextbox3.text & "','" & bunifumetrotextbox8.text & "','" & bunifumetrotextbox9.text & "','" & bunifumetrotextbox4.text & "','" & bunifumetrotextbox5.text & "','" & bunifudropdown1.selectedvalue & "','" & bunifudropdown2.selectedvalue & "','" & bunifudropdown1.selectedindex & "','" & bunifudropdown2.selectedindex & "','" & bunifumetrotextbox6.text & "','" & bunifumetrotextbox7.text & "','" & admintype & "')", conn) affector = comm.executenonquery conn.close()
Comments
Post a Comment