Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting value of OUTPUT param in .net
Message
 
 
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
C# 2.0
Miscellaneous
Thread ID:
01544303
Message ID:
01544375
Views:
27
>>Hi,
>>
>>I need to get the value of OUTPUT parameter passed to a SQL Server stored procedure from a C# method. The pseudo code is as following:
>>
>>
>>// create array of parameters to pass to the stored proced
>>string[,] Parameters = new string[,] { { "@Param1", cVal1, "" }, { "@Param2", cVal2, "" }, 
>>{ "@Param3", cVal3, "" } };
>>
>>// call stored procedure:
>>MyDataAccessClass.ExecuteStoredProcedure("MyStoredProcedure", Parameters);
>>
>>
>>
>>Note that the stored procedure will have OUTPUT set to parameter @Param3.
>>
>>My question is, after I execute the procedure above, will the variable @Param3 have the value the procedure will set to? That is, can I, after the procedure do the following:
>>
>>
>>IF (@Param3 = 'SomeString)
>>{
>>    // code
>>}
>>
>>
>>My concern (question) is, can I (or should I) refer to the variable as @Param3 in the C# method?
>
>What's in MyDataAccessClass.ExecuteStoredProcedure() ?
>.

This is a class that parses parameters (Parameters) and calls a stored procedure (either VFP or SQL Server, depending on the global setting). However, when I created this class I didn't account for the fact that I may need to get some values from OUTPUT parameter. So I will have to modify/refactor this class. Meanwhile, I found that I don't really need the OUTPUT since I will be "dealing" with error via RAISERROR in SQL Server.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform