Hello,

I have a stored procedure with an input parameter param1 and an output
parameter "param2". When testing the procedure in SQL Query Analyzer, it
selects param2 as a varchar. The procedure is therefore working fine.

But how can I get the value in VB.NET? 
Console.WriteLine(myReader("param2")) prints nothing.
Any ideas?

My SP:

CREATE Procedure mySP
        @param1 as varchar(1000),
        @param2 as varchar(1000) OUTPUT
AS
BEGIN
... som code here ...
select @param2 as param2
END
GO

Helge



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to