When iam trying to insert data into Access Database at that time iam showing OleDbException was unhandled actually picturebox5 and picturebox4 image not inserting
values are showing :
Syntax error (missing operator) in query expression
{"Syntax error (missing operator) in query expression '2','Atul','Wadala','24043410','collected','12/12/2015','2','12/01/2016','Active','500','50','2','100.00','550.00','@pictureBox6'."}
What I have tried:
insert code is
cmd = new OleDbCommand("insert into RegistrationForm(ClientCount,Name,Address,Contact,Documents,Money_Taking_Date,Muddat,Money_Return_date,Account_status,Taking_Amout,Interest_per_month,Pending_interest_month,Pending_interst_Amount,Total_Amount,Client_image,Document_image1,Document_image2) values(" + lblcount.Text + "','" + textBox20.Text + "','" + textBox21.Text + "','" + textBox19.Text + "','" + textBox18.Text + "','" + maskedTextBox1.Text.ToString() + "','" + textBox22.Text + "','" + maskedTextBox2.Text.ToString() + "','" + textBox23.Text + "','" + textBox17.Text + "','" + textBox16.Text + "','" + textBox15.Text + "','" + textBox13.Text + "','" + textBox14.Text + "','@pictureBox6,@pictureBox4,@pictureBox5)'", con);
conv_photo();
con.Open();
int n = cmd.ExecuteNonQuery();
con.Close();
if (n > 0)
{
MessageBox.Show("record inserted");
loaddata();
rno++;
}
else
MessageBox.Show("insertion failed");
loaddata method code is :
public void loaddata()
{
adapter = new OleDbDataAdapter("select * from RegistrationForm", con);
ds = new DataSet();
adapter.Fill(ds, "RegistrationForm");
ds.Tables[0].Constraints.Add("ClientCount", ds.Tables[0].Columns[0], true);
}