>>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