>Not quite there yet. I have:
>VDataSourceG.SelectParameters.Add("mcust", TypeCode.String)
>VDataSourceG.SelectParameters.Add("mnoun", TypeCode.String)
>VDataSourceG.SelectCommand = "SELECT l_nbr,cust_name,noun,office,price,status from FY2010 WHERE cust_name like '%'+?+'%' and noun like'%'+ ?+'%'"
>but it's not returning any records.
>
>

Read the blog carefully

Cmd.Parameters.Add(new OleDbParameter("?startChar", "D"));
Cmd.Parameters.Add(new OleDbParameter("?endChar", "M"));

and sorry - I'm going to close the extra forums now - need to concetrate on studying for an hour.


>>>http://www.west-wind.com/WebLog/posts/660586.aspx
>>
>>Thanks a lot - very clear.

Also, as I was saying, use LIKE ? and LIKE ? and put % inside the value of the parameter.