Getting error in sql query

Hi,

that is because id is an integer and you can compare it to a string. You have to concatenate

oleDbCmd.CommandText = "delete from contacts where id=" +a;

Mark it as answer if it helps you.