public static Cliente fb_ProcuraDados(int id) { using (FbConnection conexaoFireBird = AcessoFB.getInstancia().getConexao()) { try { conexaoFireBird.Open(); string mSQL = "Select * from Clientes Where id = " + id; FbCommand cmd = new FbCommand(mSQL, conexaoFireBird); FbDataReader dr = cmd.ExecuteReader(); Cliente cliente = new Cliente(); while (dr.Read()) { cliente.ID = Convert.ToInt32(dr[0]); cliente.Nome = dr[1].ToString(); } return(cliente); } catch (FbException fbex) { throw fbex; } finally { conexaoFireBird.Close(); } } }
private void btnSalvar_Click(object sender, EventArgs e) { Cliente cliente = new Cliente(); cliente.ID = Convert.ToInt32(txtCodigo.Text); cliente.Nome = txtNome.Text; try { AcessoFB.fb_InserirDados(cliente); MessageBox.Show("Cliente inserido com sucesso !", "Inserir", MessageBoxButtons.OK); } catch (Exception ex) { MessageBox.Show(ex.Message, "Erro", MessageBoxButtons.OK); } }
public static void fb_ExcluirDados(int id) { using (FbConnection conexaoFireBird = AcessoFB.getInstancia().getConexao()) { try { conexaoFireBird.Open(); string mSQL = "DELETE from Clientes Where id= " + id; FbCommand cmd = new FbCommand(mSQL, conexaoFireBird); cmd.ExecuteNonQuery(); } catch (FbException fbex) { throw fbex; } finally { conexaoFireBird.Close(); } } }
public static void fb_AlterarDados(Cliente cliente) { using (FbConnection conexaoFireBird = AcessoFB.getInstancia().getConexao()) { try { conexaoFireBird.Open(); string mSQL = "Update Clientes set nome= '" + cliente.Nome + "'" + " Where id= " + cliente.ID; FbCommand cmd = new FbCommand(mSQL, conexaoFireBird); cmd.ExecuteNonQuery(); } catch (FbException fbex) { throw fbex; } finally { conexaoFireBird.Close(); } } }
public static void fb_InserirDados(Cliente cliente) { using (FbConnection conexaoFireBird = AcessoFB.getInstancia().getConexao()) { try { conexaoFireBird.Open(); string mSQL = "INSERT into " + '\u0022' + "clientes" + '\u0022' + " Values (" + cliente.ID + ",'" + cliente.Nome + "')"; FbCommand cmd = new FbCommand(mSQL, conexaoFireBird); cmd.ExecuteNonQuery(); } catch (FbException fbex) { throw fbex; } finally { conexaoFireBird.Close(); } } }
public static DataTable fb_GetDados() { using (FbConnection conexaoFireBird = AcessoFB.getInstancia().getConexao()) { try { conexaoFireBird.Open(); string mSQL = "Select * from Clientes"; FbCommand cmd = new FbCommand(mSQL, conexaoFireBird); FbDataAdapter da = new FbDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } catch (FbException fbex) { throw fbex; } finally { conexaoFireBird.Close(); } } }