INSERT INTO statement for Access in ASP.NET

Question

I am developing a website.

My connection string in web.config is as below:

"add name="MyDbConn1" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\QWIN 2000Q\Database\qwin_5501q.mdb;""

I already retrieve several times from that database using that connection string. They are working.

But When I insert into a table, error pop ups that "syntax error in INSERT INTO statement".

The below is my codes for insert into statement.

command2.Parameters.AddWithValue("@Name", txtUser.Text);
command2.Parameters.AddWithValue("@Password", txtPwd.Text);
command2.Parameters.AddWithValue("@Role", ddlAccess.SelectedItem.ToString());
string abc = "Insert into Report_User (Name, Password, Role) VALUES (@Name,@Password,@Role);";

When I run that statement in the Microsoft Access, there is no error.

Anyone?

Is there any folder sharing permission or some sort??

Try doing an insert without parameters first. One of your parameters is probably invalid. so try string abc = "Insert into Report_User (Name, Password, Role) VALUES ('testName','testPassword,'testRole');"; — David
– David, Commented Dec 3, 2010 at 8:27

abatishchev · Accepted Answer · 2010-12-03 08:37:02Z

3

Replace SQL paramter names a la @Name with OleDB-specific parameter placeholder ?

Insert into Report_User (Name, Password, Role) VALUES (?, ?, ?);

change command2.Parameters.Add(..) accordingly.

edited Dec 3, 2010 at 8:37

abatishchev

101k88 gold badges304 silver badges443 bronze badges

answered Dec 3, 2010 at 8:28

k3b

14.8k7 gold badges56 silver badges88 bronze badges

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

1 Comment

william Over a year ago

Actually it is the "Password". I change to "Pwd" then it is OK.

Collectives™ on Stack Overflow

INSERT INTO statement for Access in ASP.NET

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related