Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
On http://firebirdsql.org/index.php?op=filesid=netprovider you'll find all you need! By the way... my fbconnection.connection string property has no ... button , but I don't use this visual component, I have declared in my db class and build the connection string ... I think this is the most used scenario! Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Meftah Tayeb Sent: Tuesday, September 16, 2008 11:58 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data hi Paul, please, send to me the URL to download the latest version of Firebird ADO.Net Data Provider And DDEX Provider For Visual Studio 2005 i have firebird DDEX provider V2.0. i folo the read me file, using the machine.config file but i get the SAM Error any help my friends ? thanks for your suggestions! --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
--- Mercea Paul [EMAIL PROTECTED] wrote:
On http://firebirdsql.org/index.php?op=filesid=netprovider you'll
find all
you need!
By the way... my fbconnection.connection string property has no ...
button ,
but I don't use this visual component, I have declared in my db class
and
build the connection string ... I think this is the most used
scenario!
Regards,
Paul
I agree that this is the best method. I am posting code from one of my
applications to demonstrate how this can be implemented in C#:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using FirebirdSql.Data.FirebirdClient;
namespace MED
{
class DataLayer
{
private string connStr;
private FbConnection fbc;
public DataLayer()
{
connStr = Dialect=3; ServerType=1; User=SYSDBA;
Password=masterkey; Database=c:\\temp\\MED\\database\\MEDDB.FDB;
fbc = new FbConnection(connStr);
fbc.Open();
}
public DataSet getPatientList(string patLastName)
{
FbCommand cmd = new FbCommand(MDPTNT01_SEL_L, fbc);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@PLASTNAME, patLastName);
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter(cmd);
da.Fill(ds);
return ds;
}
public DataSet getPatientDetails(string patNo)
{
FbCommand cmd = new FbCommand(MDPTNT01_SEL, fbc);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@PATNO, patNo);
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter(cmd);
da.Fill(ds);
return ds;
}
}
}
To use it, the following code:
dataLayer = new DataLayer();
DataSet ds = dataLayer.getPatientDetails(patNo);
Regards,
Steve Faleiro
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
Hi Steve,
Good sample!
I'm asking my self if is not a good to have a sample project on FB.Net
provide page!
Maybe this is a new topic...
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Steve Faleiro
Sent: Wednesday, September 17, 2008 9:56 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
--- Mercea Paul [EMAIL PROTECTED] wrote:
On http://firebirdsql.org/index.php?op=filesid=netprovider you'll
find all
you need!
By the way... my fbconnection.connection string property has no ...
button ,
but I don't use this visual component, I have declared in my db class
and
build the connection string ... I think this is the most used
scenario!
Regards,
Paul
I agree that this is the best method. I am posting code from one of my
applications to demonstrate how this can be implemented in C#:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using FirebirdSql.Data.FirebirdClient;
namespace MED
{
class DataLayer
{
private string connStr;
private FbConnection fbc;
public DataLayer()
{
connStr = Dialect=3; ServerType=1; User=SYSDBA;
Password=masterkey; Database=c:\\temp\\MED\\database\\MEDDB.FDB;
fbc = new FbConnection(connStr);
fbc.Open();
}
public DataSet getPatientList(string patLastName)
{
FbCommand cmd = new FbCommand(MDPTNT01_SEL_L, fbc);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@PLASTNAME, patLastName);
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter(cmd);
da.Fill(ds);
return ds;
}
public DataSet getPatientDetails(string patNo)
{
FbCommand cmd = new FbCommand(MDPTNT01_SEL, fbc);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(@PATNO, patNo);
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter(cmd);
da.Fill(ds);
return ds;
}
}
}
To use it, the following code:
dataLayer = new DataLayer();
DataSet ds = dataLayer.getPatientDetails(patNo);
Regards,
Steve Faleiro
---
--
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
On Wed, Sep 17, 2008 at 9:44 AM, Mercea Paul [EMAIL PROTECTED] wrote:
I'm asking my self if is not a good to have a sample project on FB.Net
provide page!
Maybe this is a new topic...
I have no problem with it. Everybody interested can provide some ideas
and/or code.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
hi POL, please send to me the URL to download the latest version of ADO.Net 2.0 Data Provider for Firebird and the Firebird DDEX Provider for Visual Studio 2005 i have firebird DDEX Provider for visual studio 2005 (V2.0). i folo the Readme step, but i get the sam problem any help please ? thanks my friends - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
