问使用Access数据库在C#中更新

EN

private void btnAlterar_Click(object sender, EventArgs e)
{    
    try
    {
        string strincon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\flavi\Desktop\Pet&Shop.2\PetShop\TelaAbertura\bin\Debug\DatabasePS.mdb;Persist Security Info=True";

        OleDbConnection con = new OleDbConnection(strincon);
        con.Open();

        String comando = "UPDATE Funcionario SET Nome= '" + txtNome.Text + "' , Login= '" + txtLogin.Text + "' , Senha= '" + txtSenha.Text + "', Email= '" + txtEmail.Text + "' , Cargo= '" + txtCargo.Text + "' WHERE Codigo =" + codigo;

        OleDbCommand cmd = new OleDbCommand(comando, con);

        cmd.ExecuteNonQuery();

        MessageBox.Show("Dados Alterados Com Sucesso!");

        txtCargo.Clear();
        txtEmail.Clear();
        txtLogin.Clear();
        txtNome.Clear();
        txtSenha.Clear();

        con.Close();
    }
    catch (Exception erro)
    {
         MessageBox.Show(erro.Message);
    }
}