ignore this thread, moderator please delete
I HAD A COMMA MISSING
:o i get this error
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
i believe there is a better way to write this insert, if anyone knows please let me know. i think there is equal number of argumants also, error confuses me.
Dim sqlInsertuser As New SqlCommand("INSERT INTO tb_user(c_orig_addr,c_user_fname,c_user_sname,c_username_login,c_user_password,c_user_house,c_user_s treet,c_user_town,c_user_postcode,c_user_tel_alt,c_user_email) VALUES('" & txt_mobile.Text & "','" & txt_fname.Text & "''" & txt_sname.Text & "','" & txt_username.Text & "','" & txt_password.Text & "','" & txt_house.Text & "','" & txt_street.Text & "','" & txt_town.Text & "','" & txt_post.Text & "','" & txt_tel.Text & "','" & txt_email.Text & "');", oSQLConn)
'sqlInsertuser.Connection.Open()
sqlInsertuser.ExecuteNonQuery()
oSQLConn.Close()