Missing operator in SQL

Question

Hello

When I compile my this part of my code the Microsoft visual studio give Eror : (System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'people where Id=1'.')

This is my code:

private void button3_Click(object sender, EventArgs e)

        {

            cmd.CommandText = "Delete people where Id=" + int.Parse(textBox5.Text) + ",Name='" + textBox1.Text + "',Last_name='" + textBox2.Text + "',Data='" + textBox2.Text + "', Code_Ozviat=" + int.Parse(textBox4.Text);

            cmd.CommandType = CommandType.Text;

            cmd.ExecuteNonQuery();

            cmd.CommandText = "select * from people";

            cmd.CommandType = CommandType.Text;

            cmd.ExecuteNonQuery();

            DataTable tb = new DataTable();

            OleDbDataAdapter dap = new OleDbDataAdapter(cmd);

            dap.Fill(tb);

            dataGridView1.DataSource = tb;

            }

what can I do for resolve this eror?

Answer 1

Your SQL statement has several errors.  Try this:

cmd.CommandText = "Delete FROM people where Id=" + int.Parse(textBox5.Text) + " AND Name='" + textBox1.Text + "' AND Last_name='" + textBox2.Text + "' AND Data='" + textBox2.Text + "' AND Code_Ozviat="

• int.Parse(textBox4.Text);

Answer 2

For Access the syntax is: "delete * from ..."

https://msdn.microsoft.com/en-us/library/bb177896(v=office.12).aspx