Alvin wrote:

> Hi
>
> I have a stored proc with a varbinary OUTPUT param and I am trying to
> retrieve the value of this variable in the C# using SqlCommand and
> setting its parameters. However, I am not able to retrieve the value
> of varbinary variable in C# for some unknown reasons. I would really
> appreciate your help. Thanks
>
> Alvin
>
>
> Byte [] testBinary = new Byte[100];
> SqlParameter param1 = SqlCommand,Parameters.Add("@testBinary",
> SqlDBType.Binary, 100);
> param1.value = testBinary
> SqlCommand.CommandType = CommandType.StoredProcedure
> SqlCommand.Direction = ParameterDirection.Output
> SqlCommand.ExecureNonQuery()
> Console.Writeline("Output param is {0}",
> Convert.ToBase64(testBinary)); ====> Don't see the value from Stored
> Proc
>
> StoredProc
> CREATE PROCEDURE test
> testBinary (100) OUTPUT
> AS
> BEGIN
> select @testBinary = testbin from testTable
> END

"Frans Bouma [C# MVP]" wrote:

> Alvin wrote:
>
> > Hi
> >
> > I have a stored proc with a varbinary OUTPUT param and I am trying to
> > retrieve the value of this variable in the C# using SqlCommand and
> > setting its parameters. However, I am not able to retrieve the value
> > of varbinary variable in C# for some unknown reasons. I would really
> > appreciate your help. Thanks
> >
> > Alvin
> >
> >
> > Byte [] testBinary = new Byte[100];
> > SqlParameter param1 = SqlCommand,Parameters.Add("@testBinary",
> > SqlDBType.Binary, 100);
> > param1.value = testBinary
> > SqlCommand.CommandType = CommandType.StoredProcedure
> > SqlCommand.Direction = ParameterDirection.Output
> > SqlCommand.ExecureNonQuery()
> > Console.Writeline("Output param is {0}",
> > Convert.ToBase64(testBinary)); ====> Don't see the value from Stored
> > Proc
> >
> > StoredProc
> > CREATE PROCEDURE test
> > testBinary (100) OUTPUT
> > AS
> > BEGIN
> > select @testBinary = testbin from testTable
> > END
>
> Shouldn't you declare your parameter in the proc as 'varbinary(100)
> and the parameter in the C# code as SqlDBType.VarBinary ?
>
> FB
>
>
> --
> ------------------------------------------------------------------------
> Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
> My .NET blog: http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------