Syntax error in insert into statement

See more:

C#

ASP.NET

I am getting a "syntax error in insert into statement" an OleDbException when i am trying the below code...

What I have tried:

protected void Button2_Click(object sender, EventArgs e)
{
string date = Convert.ToDateTime(Label10.Text).ToShortDateString();
long imei = Convert.ToInt64(TextBox3.Text);
int price = Convert.ToInt32(Label13.Text);
int discount = Convert.ToInt32(DropDownList1.SelectedValue);
int totalamt = Convert.ToInt32(Label19.Text);

string constr = "provider= microsoft.jet.oledb.4.0;data source=|datadirectory|mobishop.mdb";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
string sql = "insert into bill(fname, lname, date, IMEIno, coname, mname, color, price, discount, totalamt) values ('" + TextBox1.Text + "', '" + TextBox2.Text + "', '" + Label10.Text + "', '" + TextBox3.Text + "', '" + Label11.Text + "', '" + Label12.Text + "', '" + Label20.Text + "','" + Label13.Text + "','" + DropDownList1.SelectedValue + "', '" + Label19.Text + "')";
OleDbCommand cmd = new OleDbCommand(sql, con);
/*cmd.Parameters.AddWithValue("@fname", TextBox1.Text);
cmd.Parameters.AddWithValue("@lname", TextBox2.Text);
cmd.Parameters.AddWithValue("@date", date);
cmd.Parameters.AddWithValue("@IMEIno", imei);
cmd.Parameters.AddWithValue("@coname", Label11.Text);
cmd.Parameters.AddWithValue("@mname", Label12.Text);
cmd.Parameters.AddWithValue("@color", Label20.Text);
cmd.Parameters.AddWithValue("@price", price);
cmd.Parameters.AddWithValue("@discount", discount);
cmd.Parameters.AddWithValue("@totalamt", totalamt);*/
cmd.ExecuteNonQuery();

string sql2 = "delete * from model where IMEIno='" + TextBox3.Text + "'";
OleDbCommand cmd2 = new OleDbCommand(sql2, con);
cmd2.ExecuteNonQuery();
}