>>>>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
>>
>>Hi, my buddy orig started that profile and uses it from time to time, that's him, better looking.
>>But if you try that syntax, it's illegal.
>
>I think Sergey nailed it, but now it's not clear how to set multiple parameters?
Set them in the order they will be used