Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameters (VFPOLEDB)
Message
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
01442771
Message ID:
01442772
Views:
50
>Hi, I am having trouble establishing select parameters in a query in VB asp.net.
>Here is what I have so far but looking for the right way to do it.
>
> VDataSourceG.SelectParameters.Clear()
> VDataSourceG.SelectParameters.Add("mnoun", TypeCode.String)
> VDataSourceG.SelectCommand = "SELECT l_nbr,cust_name,noun,
> office from FY2010 WHERE NOUN like ?mnoun"
>
>But I get errors, anything obviously wrong?

Funny, so it was you in ASP.NET forums? :) I haven't figured this out.

Are you saying it doesn't work?
VDataSourceG.SelectParameters("mnoun").Value = "%Something%" ' we may need this line too
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform