SqlDataSource doesn't seem to be using select parameter....
Posted on 2007-10-07
I have an SqlDataSource I am adding a Select Parameter to, the select statement works in the mysql console, if I had to make a guess, it seems like the parameter value isn't being passed correctly. I have googled, and I have tried every combo I can think of escape and operator characters. Any ideas are greatly appreciated.
workString2 = workString2 + " and workqueuedescription like @search;";
SqlDataSource2.SelectParameters.Add("search","%" + search + "%");
SqlDataSource2.SelectParameters["search"].DefaultValue = "'%" + search + "%'";
SqlDataSource2.SelectCommand = workString2;