INSERT INTO statement not working!

Question

1.00/5 (1 vote)

See more:

Hi,

I program a little website using access as a database system and ASP.NET VB as a programming language.
My problem is when executing Insert function which insert a new user into access file an error occurred which telling me that INSERT INTO statement is invalid when executing ExecuteNonQuery().

this is the code please tell me if the statement is wrong and what is the correct because I'm quit sure that it's correct:

VB

Connection.Open()
Dim SQL As String = String.Format("INSERT INTO Users(UserName,password,Authonticaion) VALUES('{0}','{1}','{2}')", UserName, password, Authontication)
Command.CommandText = SQL
Command.CommandType = CommandType.Text
Command.Connection = Connection
Command.ExecuteNonQuery()
Connection.Close()

Note: This website for my friend and my friend want this website works only on access file. So, I can't use another database system.

Posted 17-Mar-13 8:52am

Rasool Ahmed

Add a Solution

Comments

Maciej Los 17-Mar-13 15:08pm

What's not working?
What kind of error?

[no name] 17-Mar-13 17:14pm

try [password] as your column name. I believe, but not sure, that password is reserved in access.

Mike Meinz 17-Mar-13 18:02pm

When there is more than couple of simultaneous users, Microsoft Access is a poor choice for a web site DBMS. SQL SERVER EXPRESS would be a far better choice.

[no name] 17-Mar-13 20:12pm

And add a space between "Users" and "(" and "VALUES" and the "("

[no name] 17-Mar-13 23:29pm

The error occurred again. I have checked all columns and spaces and spelling all that is fine. But why VS tells me "Syntax error in INSERT INTO statement.".??????????
DAMN IT

Sergey Alexandrovich Kryukov 24-Mar-13 23:18pm

Please stop posting non-answers as "solution". It can give you abuse reports which eventually may lead to cancellation of your CodeProject membership. And the fact you even self-accepted on formally is just outrageous, a sure way for a ban. I hope you won't do it after this warning.

Comment on any posts, reply to available comments, or use "Improve question" (above).
Also, keep in mind that members only get notifications on the post sent in reply to there posts.
—SA

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)

Manfred Rudolf Bihy · Answer 1 · 2013-03-17T09:05:00

Solution 1

Hmm, so you have MS Access installed on your server?
If the former is true then please do tell us what exception is being raised and have you tried the constructed SQL in a query?

Regards,

— Manfred

Posted 17-Mar-13 9:05am

Manfred Rudolf Bihy

Comments

[no name] 17-Mar-13 15:17pm

This is the error exception: "Syntax error in INSERT INTO statement."

Maciej Los 17-Mar-13 16:18pm

Check what is in UserName, password, Authontication variables.

Maciej Los 17-Mar-13 17:05pm

As you see, i have used "Reply" to OP comment. So, i'm asking OP ;)

Manfred Rudolf Bihy 17-Mar-13 17:05pm

My bad :)

Mike Meinz 17-Mar-13 17:58pm

You have Authentication spelled wrong. Could that be the issue?

[no name] 17-Mar-13 23:21pm

Yes Authentication is spelled wrong (my bad) but Authentication is spelled wrong in database too.

Mike Meinz 17-Mar-13 18:00pm

Use the Visual Studio interactive debugger and please tell us what is in the SQL variable after the DIM SQL statement. This will make it easier to solve your problem.