How to connect vb.net to access database

Question

The code won't run
https://code.sololearn.com/cCV5cqifP12H/?ref=app

Answer 1

I haven't been working with vb.net much but I think you have a full stop in the Values instead of comma. Could you please check?

Also, maybe you should bind parameters something like:
objcmd.Parameters.AddWithValue("?", @IdNo)

What kind of error are you getting?

Answer 2

Oki, but here in your code the first one is a full stop :

Dim strSql As String = "INSERT INTO Census([IdNo],[FirstName], [MiddleName], [Surname], [Password]) VALUES(?.?,?,?,?)"

Have you tried anything else?

Answer 3

No it's a comma
I can't send you an image

Answer 4

yeah
I have created a connection between the database and vb

Answer 5

Hi