Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling sprocs with input/output parms
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
00868625
Message ID:
00868816
Vues:
15
Kendall,

Glad you got it working!!

>Hi Cathi,
>
>I was looking at Mr. Walther's ASP.Net reference and noticed that he was using the native SqlClient.ExecNonQuery to accomplish this, but also noticed that he was setting the size property of the parameter. So I thought I would try setting that property and it worked! As I was mentioning earlier, I thought that might be the culprit here. I added the following line to fix the problem.
>
>
param2.size = 100
>
>So I looked at the Dev Guide again. I think that the ExecSprocScalar method does support the output parameter as the sample code illustrates, but ???. Maybe Kevin can check in on this and confirm. At any rate, it's working and I'm happy about that!
>
>Thanks Cathi!
>
>>Hi Kendall,
>>
>>I did some testing on this without using MMF and confirmed that ExecuteScalar can not return output parameters. I will need to have Kevin respond to your question to see if he does something different in the class. I looked at his source code and it doesn't appear that he does.
>>
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform