Inserting auto number in MS Access using C# asp.net

Question

I am trying to automatically insert numbers in my MS Access db .

Currently i have a db that looks like:

| id | username | password | name | email |

where id is auto incremented.

And I have this code:

cmd.Parameters.AddWithValue("@userName", tbUname.Text.Trim());
cmd.Parameters.AddWithValue("@password", tbPass.Text.Trim());
cmd.Parameters.AddWithValue("@Name", tbName.Text.Trim());
cmd.Parameters.AddWithValue("@Email", tbEmail.Text.Trim());
string sql = "insert into users " +
            "values('',@userName, @password, @Name, @Email)";

I have tried doing this:

INSERT INTO users (username,password,name,email) VALUES (@userName,@password, @Name, @Email)

the error i get when u run this query is :

System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Default2.btsignup_Click(Object sender, EventArgs e)

But it doesn't work. I need it so that whenever a new user registers, a number is assigned to them.

Can some one help me out?

its just an example please answer the question being asked :) — Craftx398
– Craftx398, Commented Apr 25, 2017 at 15:30
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandl ...thats the error when i try using the second commad — Craftx398
– Craftx398, Commented Apr 25, 2017 at 15:32
Can you edit your question to show the full stack trace. The above comment is cut off — Alex
– Alex, Commented Apr 25, 2017 at 15:37

Alex · Accepted Answer · 2017-04-25 15:49:43Z

1

I'm gonna take a punt that password is a reserved field name within MS Access

try

cmd.Parameters.AddWithValue("@userName", tbUname.Text.Trim());
cmd.Parameters.AddWithValue("@password", tbPass.Text.Trim());
cmd.Parameters.AddWithValue("@Name", tbName.Text.Trim());
cmd.Parameters.AddWithValue("@Email", tbEmail.Text.Trim());
string sql = "INSERT INTO users (username,[password],name,email) VALUES (@userName,@password, @Name, @Email)";

note the [ ] around password

edited Apr 25, 2017 at 15:49

answered Apr 25, 2017 at 15:43

Alex

38.6k55 gold badges217 silver badges340 bronze badges

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

3 Comments

Alex Over a year ago

@MikeMcCaughan see his question - he did actually try specifying the column names: INSERT INTO users (username,password,name,email) VALUES (@userName,@password, @Name, @Email) - problem was the 'naked' password column name

T.S. Over a year ago

Why not [ ] for every field?

Alex Over a year ago

Why not indeed. Go on, splash out, stick [ ] around every column :)

Collectives™ on Stack Overflow

Inserting auto number in MS Access using C# asp.net

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related