Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting value of OUTPUT param in .net
Message
From
25/05/2012 13:20:39
 
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
C# 2.0
Miscellaneous
Thread ID:
01544303
Message ID:
01544413
Views:
26
>>>>
>>>>Given your previous post I guess you no longer need it but, in pseudo-code:
SqlCommand command = new SqlCommand();
>>>>            //Congfigure command
>>>>            SqlParameter param = new SqlParameter(Parameters[2, 0], Parameters[2, 1]);
>>>>            param.Direction = ParameterDirection.InputOutput;
>>>>            //etc
>>>>            command.Parameters.Add(param);
>>>>            //Add other params , execute....
>>>>            var v =  command.Parameters["@Param3"].Value;
>>>
>>>Can you think of why when I am trying to apply the above code, C# compiler complaints that 'object does not contain a definition for 'Value'". This is on the very last line where Parameters value is retrieved. And when I entry the open bracket key, right after the 'Parameters' Intellisense shows that object List parameter is int Index. What am I missing?
>>
>>Can you show the code you're trying?
>
>I think the difference is in how I create Parameters collection (as following):
>
>
>IDbDataParameter param = oCommand.CreateParameter();
>
>
>and the way Viv created them:
>
>
>SqlParameter param = new SqlParameter(Parameters[2, 0], Parameters[2, 1]);
>
Not sure why that wouldn't work. Assuming the command is DBCommand where does your code differ from this:
          System.Data.Common.DbCommand command = new SqlCommand();
            System.Data.IDbDataParameter p = command.CreateParameter();
            p.ParameterName = "@Param3";
            p.Direction = ParameterDirection.InputOutput;
            p.Value = cVal3;
            //etc...
            command.Parameters.Add(p);
            var v = command.Parameters["@Param3"].Value;
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform