INSERT query syntax error in ASP.NET C# with Access

Question

I am trying to insert data into an Access database with C#. The error I receive is

Insert Into Statement syntax error

The code is

textBox5.Text = ins; //string value
string into = "INSERT INTO customersales(c-invoiceNo,c-invoiceDate, c-discount, c-rant,c-paid, c-due) values ('" +textBox5.Text.ToString() + "'," + dateTimePicker1.Text + "," + diccombo.Text.Trim() + "," + GRANTTXT.Text + "," + TXTPAID.Text + ","+ txtdue.Text + ")";
 con.Open();
 cmd = new OleDbCommand(into, con);
 cmd.ExecuteNonQuery();
 con.Close();

Table name : customersales

columnname :

id (autonumber)
c-invoiceNo (text)
c-invoiceDate  (date/time)
c-discount (currency)
c-grant (currency)
c-paid (currency)
c-due (currency)

Copy and paste the value of into into a query window in MS Access. Does it work? — Jane S
– Jane S, Commented Jun 20, 2014 at 9:33

Gord Thompson · Accepted Answer · 2014-06-20 12:54:50Z

1

You should be using a parameterized query, like this

string into = 
        "INSERT INTO [customersales] ([c-invoiceNo], [c-invoiceDate], [c-discount], [c-grant], [c-paid], [c-due]) " +
        "VALUES (?,?,?,?,?,?)";
con.Open();
cmd = new OleDbCommand(into, con);
cmd.Parameters.AddWithValue("?", textBox5.Text);
cmd.Parameters.AddWithValue("?", dateTimePicker1.Value.Date);
cmd.Parameters.AddWithValue("?", diccombo.Text);
cmd.Parameters.AddWithValue("?", GRANTTXT.Text);
cmd.Parameters.AddWithValue("?", TXTPAID.Text);
cmd.Parameters.AddWithValue("?", txtdue.Text);
cmd.ExecuteNonQuery();
con.Close();

edited Jun 20, 2014 at 12:54

answered Jun 20, 2014 at 9:52

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

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

2 Comments

user2834203 Over a year ago

this code is not working properly and same error occurred. please suggest again.

Gord Thompson Over a year ago

@user2834203 I have updated my answer. (Changed dateTimePicker1.Value to dateTimePicker1.Value.Date.)

gkrishy · Accepted Answer · 2014-06-20 12:45:04Z

0

Change your query in this way,

  string into = "INSERT INTO customersales(c-invoiceNo,c-invoiceDate, c-discount, c-grant,c-paid, c-due) values ('" +textBox5.Text.ToString() + "'," + dateTimePicker1.Text + "," + diccombo.Text.Trim() + "," + GRANTTXT.Text + "," + TXTPAID.Text + ","+ txtdue.Text + ")";

Before this, Check whether your autonumber's identity specification sets to true or not ?

edited Jun 20, 2014 at 12:45

answered Jun 20, 2014 at 9:34

gkrishy

7561 gold badge8 silver badges33 bronze badges

1 Comment

gkrishy Over a year ago

Check with my answer now. Change your syntax with my above line of code

Collectives™ on Stack Overflow

INSERT query syntax error in ASP.NET C# with Access

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related