Visual C# 2010 Express
Provedor usado : FireBirdClient namespace utilizado : FirebirdSql.Data.FirebirdClient; Incluir a referência ao provedor FireBirdSQLData.FireBirdClient private void button 1 _Click(object sender, EventArgs e) { string strConn = @"DataSource=localhost; Database=C:\dados\ BancoDados .FDB; UserId=SYSDBA; Pwd=masterkey"; FbConnection fbConn = new FbConnection(strConn); FbCommand fbCmd = new FbCommand("Select * from NomeTabela ",fbConn); try { fbConn.Open(); FbDataAdapter fbDa = new FbDataAdapter(fbCmd); DataTable dtEmployee = new DataTable(); fbDa.Fill(dtEmployee); gdvDadosFireBird.DataSource = dtEmployee; } catch (FbException fbex) { MessageBox.Show("Erro ao acessar o FireBird " + fbex.Message,"Erro"); } finally { fbConn.Close(); } }
Comentários
Postar um comentário