Re: Output & return parameters using SQLHelper from DAAB

From: JStemper (JStemper_at_discussions.microsoft.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 06:09:03 -0800

The SQLHelper class is part of the Data Access Application Block. The
assumption is that they are adde properly. I haven't torn apart the DAAB code
yet to see if there is a problem there.

John

"Val Mazur" wrote:

> Hi,
>
> Like for me code looks fine, but what happens with these parameters inside
> of the SqlHelper class? Did you add them into the parameters collection of
> the command, which executes them?
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "JStemper" <JStemper@discussions.microsoft.com> wrote in message
> news:ABA00DB5-D818-4E65-82EE-2340A26ECB74@microsoft.com...
> > I'm having trouble getting the following code to return an output value
> > and
> > the return value from a stored proc. When the stored proc is run from
> > Query
> > Analyzer it returns both the output parameter and the return value. But
> > when
> > I use DAAB 2.x the values are both set to 0 which are not the correct
> > values.
> >
> > TIA John
> >
> >
> > _C# code _________________________________________________________
> > SqlParameter paramEventLocationId = new SqlParameter
> > ("@intEventLocationId",
> > SqlDbType.Int );
> > SqlParameter paramNewPaymentId = new SqlParameter ("@intNewPaymentID",
> > SqlDbType.Int, 4 );
> > SqlParameter paramReturn = new SqlParameter ("@intError", SqlDbType.Int );
> >
> > paramReturn.Direction = ParameterDirection.ReturnValue;
> > paramNewPaymentId.Direction = ParameterDirection.Output;
> >
> > paramEventLocationId.Value = 361;
> >
> > try
> > {
> > SqlHelper.ExecuteScalar(
> > CONN_STRING,
> > spName,
> > paramEventLocationId,
> > paramNewPaymentId
> > );
> > }
> > catch (Exception ex)
> > {
> > ExceptionManager.Publish(ex);
> > }
> > int temp = Convert.ToInt32(paramReturn.Value);
> > int lOrderNumber= Convert.ToInt16(paramNewPaymentId.Value);
> >
> > _____End Code ____________________________________________
> >
>
>
>