Syntax error when Insert to Access using OleDb

Question

I do not have a lot of experience in vb.net, but I am trying to use OleDB to insert a record with String,string,Yes/no(studentname, number, gender). However when I insert it , there's a exception raised stating that I have invalid syntax for the "insert into" query. I could not spot the error.

Test case:

txtName.Text = "asdasdasd"
txtPhone.Text = "123456789"
rGender.Checked = True

Here's the code:

    cmd = New OleDbCommand()
    With cmd
        .Connection = cn
        .CommandText = "INSERT INTO [Student] (StudentName, Number, Gender) VALUES(@Name,@Number,@Gender)"
        .CommandType = CommandType.Text
        .Parameters.AddWithValue("@Name", txtName.Text)
        .Parameters.AddWithValue("@Number", txtPhone.Text)
        .Parameters.AddWithValue("@Gender", rGender.Checked)
    End With

KV Prajapati · Accepted Answer · 2011-10-02 10:29:12Z

2

Number is reserved word,

INSERT INTO [Student] ([StudentName], [Number], [Gender]) VALUES(@Name,@Number,@Gender)

answered Oct 2, 2011 at 10:29

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

1 Comment

user201897 Over a year ago

THis works after long time to search a solution for "has a syntax problem"

Anuraj · Accepted Answer · 2011-10-02 10:31:15Z

1

Seems like the Problem with field name "Number", its a keyword in MSAccess - http://support.microsoft.com/kb/286335.

answered Oct 2, 2011 at 10:31

Anuraj

19.6k7 gold badges61 silver badges84 bronze badges

1 Comment

DucDigital Over a year ago

I did not remember that there was a list of reserve keyword. I just work with access for 2 or 3 times before so thank you very much Anuraj

Collectives™ on Stack Overflow

Syntax error when Insert to Access using OleDb

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related