Error - Insert data into Access database in c#

Question

Pls, am having an error code when inserting data into Access database. It keeps saying there's sytanx error in my INSERT INTO statement. Can any one help me to solve this. Here is the code

try {  
            OleDbConnection connection = new OleDbConnection(@"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C:\Users\DELL\Documents\EmployeesData.accdb;  
            Persist Security Info = false;");  
            connection.Open();  
            OleDbCommand cmd = new OleDbCommand("insert into EmployeeInfo (UserName, Password) values('" + UserText.Text + "', '" + PassText.Text + "')", connection);  
            cmd.ExecuteNonQuery();  
            MessageBox.Show("Inserted");  
        }  
        catch (Exception ex)  
        {  
            MessageBox.Show("Failed" + ex.ToString());  
        }

You could do worse than asking Little Bobby Tables for some advice... — Toby Speight
– Toby Speight, Commented Jul 11, 2016 at 9:59

Sachu · Accepted Answer · 2016-07-11 09:50:17Z

3

Password is a keyword in MSACCESS so u need to enclosed in [] bracket

 OleDbCommand cmd = new OleDbCommand("insert into EmployeeInfo ([UserName], [Password])
 values('" + UserText.Text + "', '" + PassText.Text + "')", connection);

Note: always use parameterized queries to avoid SQL Injection

answered Jul 11, 2016 at 9:50

Sachu

7,7549 gold badges59 silver badges101 bronze badges

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

2 Comments

Oyetoke Tobi Over a year ago

Not working the error code says "Index or primary key cannot contain a Null value"

Sachu Over a year ago

@OyetokeTobiEmmanuel in your table there is a primary key and you are not passing value for it.. thats why its giving this erro

Collectives™ on Stack Overflow

Error - Insert data into Access database in c#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related