if (comboBox1.Enabled == true && textBox5.Text != "")
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data Source= c:\users\mert\" + @"documents\visual studio 2010\Projects\PayrollCS\WindowsFormsApplication7\P ayrollDB.accdb";
con.Open();
OleDbCommand cmdole1 = new OleDbCommand("SELECT SalaryHead_ID FROM SalaryHead WHERE SalaryHead = '" + comboBox1.Text +"' " , con);
int salaryheadid = (int)cmdole1.ExecuteScalar();
OleDbCommand cmdole = new OleDbCommand("INSERT INTO [GroupContains](SalaryGroup_ID,SalaryHead_ID) Values ('"+textBox5.Text +"' , '"+ salaryheadid.ToString()+"') ", con);
cmdole.ExecuteNonQuery();
try
{
OleDbCommand cmdole2 = new OleDbCommand("INSERT INTO [SalaryCardHead](SalaryHead_ID,SalaryGroupID,Value) Values ('"+salaryheadid.ToString()+"','"+textBox5.Text+"' , '"+ textBox4.Text+"') ", con);
cmdole2.ExecuteNonQuery();
}
catch (OleDbException err)
{
MessageBox.Show(err.ToString());
}
this is my code. I am getting this error on "cmdole2" query.
error text is:
---------------------------
---------------------------
System.Data.OleDb.OleDbException (0x80040E14): Syntax error in INSERT INTO statement.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at WindowsFormsApplication7.SalaryGroup.SalaryGroup.t oolStripButton8_Click(Object sender, EventArgs e) in C:\Users\MERT\documents\visual studio 2010\Projects\PayrollCS\WindowsFormsApplication7\S alaryGroup\SalaryGroup.cs:line 306
---------------------------
OK
---------------------------