Insert Statement Problem in MS Access

Question

0.00/5 (No votes)

See more:

Hi
I have problem is that. I want to insert data on MS Access Table but it gives Syntax error in INSERT INTO statement.

my code is this

C#

int pcid = int.Parse(drpProduct.SelectedValue);
            string qury = "Insert into Product_Information(PCId,ImagePath,Names,Code) values(" + pcid + ",'" + uploadPath + "','" + txtImageName.Text + "','" + txtImageCode.Text + "') ";
           
            OleDbCommand oleDbCommand = new OleDbCommand(qury, oleDbConnection);           
            if (oleDbConnection.State != ConnectionState.Open)
                oleDbConnection.Open();
            int i = oleDbCommand.ExecuteNonQuery();
            if (i > 0)
            {
                txtImageCode.Text = txtImageName.Text = string.Empty;
            }

Posted 12-Sep-13 23:48pm

Dharmendra-18

Add a Solution

Comments

Thomas ktg 13-Sep-13 5:53am

Did you check manually executing the insert statement with values?

BulletVictim 13-Sep-13 5:55am

Try writing your insert statement like this:
"Insert into [Product_Information]([PCId],[ImagePath],[Names],[Code]) values('" + pcid + "','" + uploadPath + "','" + txtImageName.Text + "','" + txtImageCode.Text + "') ";

I know the [ ] are not required, but I have seen it solve this issue before.

Dharmendra-18 13-Sep-13 6:00am

thanks it work, but I have question Why we write this type before it all query works but only this through exception....

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Sep-13 10:32am

I have tried to explain the problem. If you like it, then please accept and up-vote.

Thanks,
Tadit

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Sep-13 10:25am

Please add this as an answer. :)

BulletVictim 13-Sep-13 6:05am

Honestly I don't know why exactly this happens. Seen it Happen while I was still doing my studies and from there on when I use Access writing it like this has become standard practice for me and never really gave it much thought as to why it happens.

Dharmendra-18 13-Sep-13 6:08am

ok I search it. If I found better answer I will reply you...

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Sep-13 10:33am

I have tried to explain the problem. If you like it, then please up-vote.

Thanks,
Tadit

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-09-13T04:31:00

Solution 3

@BulletVictim is correct.

This issue happens when you mention any reserved keyword of a particular Database.

Refer - Access 2007 reserved words and symbols[^].
Here all the keywords are listed.
From your query, "Names" is also present in the list.

So, when you use it, it will refer to the keyword and not the column of Table.
To resolve this, we wrap it inside the Square Brackets, so that it will not refer to the default keyword.

Posted 13-Sep-13 4:31am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

BulletVictim 16-Sep-13 4:18am

Thank you. I have asked around the office as well but since we don't really work with access databases no one could think of a reason why this would happen. But what you said makes sense.
Thanks Tadit

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 16-Sep-13 5:14am

Hi BulletVictim,

Most Welcome. My Pleasure...

Please up-vote, if it helped you. :)

Thanks,
Tadit