firebird-net-provider

RE: [Firebird-net-provider] .net 1.0 vs. 1.1

[Alan M. <al...@me...>]

Carlos why are you fixed on 1.0 when the update is free and easy to
install... is there some other technical reason why you want to stay =
with
1.0?
For anyone getting into .NET right now (and for some time now) MS doe=
s not
make it easy at all to acquire 1.0, it's 1.1 or no .NET
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Carlos Guzman Alvarez
> Sent: Sunday, 21 September 2003 11:06 PM
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] .net 1.0 vs. 1.1
>
>
> Hello:
>
> > as a .net-Newbie I have a question relating the use of the firebi=
rd
> > dataprovider.
> >
> > The Provider is written for .net 1.0. Is he working under 1.1 too=
 ??
>
> The provider can be used with both 1.0 and 1.1, but i have installe=
d
> .net framework 1.0 only at this moment i have released installation
> packages only for it, you can build the sources using .net framewor=
k 1.1
> and nant ( nant.sourceforge .net ) it's easy to do :)
>
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>

Re: [Firebird-net-provider] .net 1.0 vs. 1.1

[Carlos G. A. <car...@te...>]

Hello:

> Carlos why are you fixed on 1.0 when the update is free and easy to
> install... is there some other technical reason why you want to stay with
> 1.0?
> For anyone getting into .NET right now (and for some time now) MS does not
> make it easy at all to acquire 1.0, it's 1.1 or no .NET

Nothing special :), i can make all future installs using .NET 1.1 but i 
don't want to have both frameworks installed ( to avoid possible 
problems ;) ) this means i will not make more releases ( installation 
packages ) for .net 1.0, opinions are wellcome ??




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] .net 1.0 vs. 1.1

[Karl S. <web...@st...>]

car...@te... (Carlos Guzman Alvarez) wrote in
news:3F6...@te...: 

> 
> Nothing special :), i can make all future installs using .NET 1.1 but
> i don't want to have both frameworks installed ( to avoid possible 
> problems ;) ) this means i will not make more releases ( installation 
> packages ) for .net 1.0, opinions are wellcome ??
> 
> 
> 
> 

Well, I'm for .net 1.1 for the same reasons as Alan said.

KS

[Firebird-net-provider] Stored Procedure returns dataset...

[Mike N. <mi...@ta...>]

Hello

I have a stored procedure that returns a recordset. Works fine when I call
it from IBExpert, but when I call it from .NET I am only getting one row
returned.

I am not sure I am using the correct syntax to call a stored proc that
returns a recordset.

I'm displaying it in a grid, and my test code is below.  I'd appreciate it
if someone could point me in the right direction here.. I'm new to .NET and
only have a bit of firebird experience.


Regards


Mike

----

FbConnection myConnection = new FbConnection(connectionString);
myConnection.Open();
FbTransaction myTxn = myConnection.BeginTransaction();
FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
GET_ALLOTMENTS_FORMATTED(?,?,?)", myConnection, myTxn);

myCommand.CommandType = CommandType.StoredProcedure;

myCommand.Parameters.Add("@ROOM_ID", FbType.Integer, "ROOM_ID").Direction =
ParameterDirection.Input;

myCommand.Parameters.Add("@DATE_FROM", FbType.Date, "DATE_FROM").Direction =
ParameterDirection.Input;

myCommand.Parameters.Add("@DATE_TO", FbType.Date, "DATE_TO").Direction =
ParameterDirection.Input;


myCommand.Parameters[0].Value = 1;
myCommand.Parameters[1].Value = "1/1/2000";
myCommand.Parameters[2].Value = "1/1/2008";

FbDataReader myReader;
myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid1.DataSource = myReader;
DataGrid1.DataBind();
myReader.Dispose();

Re: [Firebird-net-provider] Stored Procedure returns dataset...

[Carlos G. A. <car...@te...>]

Hello:

> I have a stored procedure that returns a recordset. Works fine when I call
> it from IBExpert, but when I call it from .NET I am only getting one row
> returned.
> 
> I am not sure I am using the correct syntax to call a stored proc that
> returns a recordset.
> 
> I'm displaying it in a grid, and my test code is below.  I'd appreciate it
> if someone could point me in the right direction here.. I'm new to .NET and
> only have a bit of firebird experience.

Don't worry :), try:

FbCommand myCommand = new FbCommand("SELECT * FROM 
GET_ALLOTMENTS_FORMATTED(?,?,?)", myConnection, myTxn);

Or if you are using Firebird .NET Provider 1.5:

FbCommand myCommand = new FbCommand("GET_ALLOTMENTS_FORMATTED", 
myConnection, myTxn);


And a little advice :), ParameterDirection.Input is the default 
direction for new parameters, you can create input parameters as:

myCommand.Parameters.Add("@ROOM_ID", FbType.Integer, "ROOM_ID").Value = 1;

myCommand.Parameters.Add("@DATE_FROM", FbType.Date, "DATE_FROM").Value = 
"1/1/2000";

myCommand.Parameters.Add("@DATE_TO", FbType.Date, "DATE_TO").Value = 
"1/1/2008";


that i think it's more easy and readable but it's your choice :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Stored Procedure returns dataset...

[Mike N. <mi...@ta...>]

Thanks a lot Carlos,

Thanks for your help with this, much appreciated. And about the code
formatting - I'm new to .NET so any advice is welcome :)


<SNIP>

Don't worry :), try:

FbCommand myCommand = new FbCommand("SELECT * FROM
GET_ALLOTMENTS_FORMATTED(?,?,?)", myConnection, myTxn);

And a little advice :), ParameterDirection.Input is the default
direction for new parameters, you can create input parameters as:

<SNIP>