private void bt_salvar_Click(object sender, EventArgs e) { Pecas peca = new Pecas(); peca.IdPeca = Convert.ToInt32(tbCodigo.Text); peca.Peca = tbPeca.Text; peca.Obs = tbObs.Text; try { Pecas.Cadastrar(peca); MessageBox.Show("Cadastro efetuado com sucesso!", "Cadastro", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } catch (Exception ex) { MessageBox.Show("Erro ao cadastrar dados da Peça : " + ex.Message, "Erro"); } }
public static void Cadastrar(Pecas peca) { using (FbConnection connection = DaoBanco.GetInstancia().getConexao()) { try { connection.Open(); string mSQL = "INSERT INTO Pecas Values (" + peca.IdPeca + ",'" + peca.Peca + "','" + peca.Obs + "')"; FbCommand cmd = new FbCommand(mSQL, connection); cmd.ExecuteNonQuery(); } catch (FbException fbex) { throw fbex; } finally { connection.Close(); } } }