Subject Re: [firebird-support] connect to FB using visual basic 2010
Author Ismael L. Donis Garcia
In Visual C# 2005 (I think that in 2010 it be similar), adding reference to FirebirdClient - ADO.NET 2.6.5 Data Provider
adding in the code of the form: using FirebirdSql.Data.FirebirdClient;
adding a DataGridView in the form with name data
later on the event Form_Load adding:
string connectionString =
"User=SYSDBA;" +
"Password=masterkey;" +
"Database=D:\data\Tests.fdb;" +
"DataSource=localhost;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=NONE;" +
"Role=;" +
"Connection lifetime=15;" +
"Pooling=true;" +
"MinPoolSize=0;" +
"MaxPoolSize=50;" +
"Packet Size=8192;" +
"ServerType=0";
FbConnection conexion = new FbConnection(connectionString);
try
{
// Open two connections.
conexion.Open();
DataTable dt = new DataTable();
FbDataAdapter da = new FbDataAdapter("SELECT * FROM PERSONAS", conexion);
da.Fill(dt);
data.DataSource = dt;
conexion.Close();}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
conexion.Dispose();
}


Best Regards
=========
|| ISMAEL ||
=========
----- Original Message -----
From: zacwingfield
To: firebird-support@yahoogroups.com
Sent: Wednesday, December 07, 2011 1:02 PM
Subject: [firebird-support] connect to FB using visual basic 2010



hi, can anyone point me to a good tuitorial on how to connect to firebird from VB 2010

many thanks
zac





[Non-text portions of this message have been removed]