Missing semicolon (;) C#

Question

2.77/5 (4 votes)

See more:

I'm getting error when i try to insert data into a access database..
missing semicolon (;) at the end of sql statement..
anyone can help me?
p.s i try to put the semicolon at the end but same error again..
the insert command is here :

C#

oleDbDataAdapter1.InsertCommand.CommandText =
               "insert into magazina(sasia) values ('" + sasia_totale + "') where emri = '" + listBox1.SelectedItem + "'";
            oleDbDataAdapter1.InsertCommand.ExecuteNonQuery();

Posted 22-Sep-13 4:56am

Emin Kokalari(EAK)

Updated 22-Sep-13 12:18pm

v2

Add a Solution

Comments

[no name] 22-Sep-13 10:57am

"insert into magazina(sasia) values ('" + sasia_totale + "') where emri = '" + listBox1.SelectedItem + "'";

Emin Kokalari(EAK) 22-Sep-13 18:15pm

the end of statement is : where emri = '"+listBox1.SelectedItem+"'";
i made mistake in writing statement... sorry for this, but my problem still exist !..

[no name] 22-Sep-13 19:04pm

Probably because whatever database you are using might not support an INSERT statement with a WHERE clause.

Emin Kokalari(EAK) 23-Sep-13 5:48am

im using access database

3 solutions

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)

OriginalGriff · Answer 1 · 2013-09-22T05:08:00

Solution 2

Too many double quotes!
Change:

C#

oleDbDataAdapter1.InsertCommand.CommandText =
               "insert into magazina(sasia) values ('" + sasia_totale + "') where emri = '" + listBox1.SelectedItem + '"";

To:

C#

oleDbDataAdapter1.InsertCommand.CommandText =
               "insert into magazina(sasia) values ('" + sasia_totale + "') where emri = '" + listBox1.SelectedItem + "'";

Posted 22-Sep-13 5:08am

OriginalGriff

v2

Comments

Emin Kokalari(EAK) 22-Sep-13 18:18pm

The problem still exist bro...

Dave Kreskowiak 22-Sep-13 22:49pm

A WHERE clause with an INSERT query?? I don't know of a single DB engine that supports that! ;)

Dave Kreskowiak · Answer 2 · 2013-09-22T16:48:00

You cannot use a WHERE clause with an INSERT statement.

I think you need to change this query to an UPDATE statement.

Also, you should probably Google for "SQL Injection Attack" to find out why using string concatentation to build your SQL statement is a horrible idea and what you can do to fix it. Another Google search would be "C# SQL parameterized query".

Sampath Lokuge · Answer 3 · 2013-09-22T05:07:00

Solution 1

Try below one :

SQL

oleDbDataAdapter1.InsertCommand.CommandText =
               "insert into magazina(sasia) values ('" + sasia_totale + "')
                where emri = '" + listBox1.SelectedItem + "'";

I hope this will help to you.

Posted 22-Sep-13 5:07am

Sampath Lokuge

Comments

Emin Kokalari(EAK) 22-Sep-13 18:19pm

this statement its not correct...

Missing semicolon (;) C#

3 solutions

Solution 2

Solution 4

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us