Análise de sistemas

foreach (FbParameter p in prmParametro) { cmd.Parameters.Add(p); } try { con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = strSQL.ToString(); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { if ((cmd != null)) { cmd.Dispose(); } if (con.State != ConnectionState.Closed) { con.Close(); con.Dispose(); } } } }
}

Agora é só pressionar F5 e realizar os testes. Até a próxima Professor Emerson Ricardo Flores InitializeComponent(); } private void button2_Click(object sender, EventArgs e) { string strconn =
"User=SYSDBA;Password=masterkey;Database=C:\UNOPAR\DADOS.FDB;D
ataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Conne ction lifetime=0;Connection timeout=15;Pooling=True;Packet
Size=8192;Server Type=0"; FbConnection conn = new FbConnection(strconn); FbCommand cmd = new FbCommand("select * from amigos",conn); FbDataAdapter DA = new FbDataAdapter(cmd); DataSet DS = new DataSet(); conn.Open(); DA.Fill(DS, "amigos"); dataGridView1.DataSource = DS; dataGridView1.DataMember = "amigos"; conn.Close(); } }
}

A programação para adicionar um campo no banco de dados. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using FirebirdSql.Data.FirebirdClient; namespace aula01
{
public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string strSQL = ""; string s =
"User=SYSDBA;Password=masterkey;Database=C:\UNOPAR\DADOS.FDB;DataSou