>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