在girdview实现删除操作,这些个语法有错误吗?
public void Delete(string code)
         {
             using (OleDbCommand delete = new OleDbCommand())
             {
                 delete.CommandText = "delete into country(code) values ('" + code + "')";
                 delete.Connection = this.GetConnection();
                 try
                 {
                     delete.Connection.Open();
                     delete.ExecuteNonQuery();
                 }
                 finally
                 {
                     delete.Connection.Close();
                 }
             }
         }
         private void ButtonDelete(object sender, EventArgs e)
         {
             country ct = new country();
             ct.Delete(this.textBox1.Text.Trim());  
             this.dataGridView1.DataSource = ct.GetCountry().Tables[0];  
         }
------解决方案--------------------delete from 表名 where 字段名="条件";