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

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

Missing semicolon (;) C#

3 solutions

Solution 2

Solution 4

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us