Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling VFP Stored Procedure ?
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00712424
Message ID:
00712456
Views:
21
Remove the parameters lines and changing the commandobject line to the following:
System.Data.OleDb.OleDbCommand oCmd = new OleDbCommand("PutResult('aaa','bbb')",oConn);
>Thanks. Then how does a value get assigned to the parameter?
>
>When I did this:
>
>oCmd.Parameters[0].Value="aaaa";
>oCmd.Parameters[1].Value="aaaa";
>
>I got the message "feature not available".
>
>And when I did this:
>
>oCmd.Parameters.Add(new OleDbParameter("cInputID",OleDbType.Char,60,"cInputID").Value="aaa");
>oCmd.Parameters.Add(new OleDbParameter("cInputResult",OleDbType.Char,4096,"cInputResult").Value="bbb");
>
>I got the message "An unhandled exception of type 'System.InvalidCastException' occurred in system.data.dll
>
>Additional information: The OleDbParameterCollection only accepts non-null OleDbParameter type objects, not String objects."
>
>?
-----------------------------------------

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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform