Using OleDb cannot insert into database

Question

Additional information: Syntax error (missing operator) in query expression ''1'）'.

This is my code

Dim connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Database1.mdb;")
Dim command As New OleDbCommand("INSERT INTO Student_Enquiry (StudentID,Email,Receiver,Comment) VALUES('" + TextBox3.Text + "','" + TextBox1.Text + "','" + ComboBox1.Text + "', '" + TextBox4.Text + "'）", connection)

command.Connection.Open()
command.ExecuteNonQuery()
command.Connection.Close()

Gord Thompson · Accepted Answer · 2014-09-21 12:08:49Z

2

The issue is that the final closing parenthesis in the insert statement actually isn't a normal Right Parenthesis; it is a different character.

You used ） - "Fullwidth Right Parenthesis", U+FF09
instead of ) - "Right Parenthesis", U+0029, ASCII 0x29

Compare the the invalid and the valid: ） != )

Use this instead:

Dim command As New OleDbCommand("INSERT INTO Student_Enquiry (StudentID,Email,Receiver,Comment) VALUES('" + TextBox3.Text + "','" + TextBox1.Text + "','" + ComboBox1.Text + "', '" + TextBox4.Text + "')", connection)

Also, you really shouldn't inject values into the query but rather use parametrized queries to avoid issues with potential SQL injection etcetera. The documentation shows you how to do this.

edited Sep 21, 2014 at 12:08

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

answered Sep 21, 2014 at 11:30

jpw

45k6 gold badges71 silver badges90 bronze badges

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

8 Comments

jpw Over a year ago

@GordThompson Thanks for the edit, I was wondering what the invalid character actually was; it evaluated as ascii 41 in MSSQL just as a normal right parenthesis.

meili Over a year ago

Thanks for you all help me! ） != ) <<< like this error also can found it. PRO! I love you all !

meili Over a year ago

But one more question... how about the update code? Is it UPDATE Student_Enquiry something like this??

jpw Over a year ago

@meili Yes. The basic syntax for update is update your_table set your_column = new_value.

meili Over a year ago

@jpw currently my system need to if i edit my studentID then will update the studentID.... i'm just code : UPDATE Student_Information SET StudentID='"+Textbox1.text+"' WHERE StudentID = "" Am i correct?

|

Collectives™ on Stack Overflow

Using OleDb cannot insert into database

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related