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=files&id=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=100&url=/ > _______________________________________________ > 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=100&url=/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
