I am using a sqldatasource as my source for my gridview.
when i use the selectcommand it works for
SelectCommand =
"Select Name, DOB, CLIENTID From FiscalResult Where ((Name) Like 'DAMRAURYAN')"it returns everyone named DAMRAURYAN
but when i use
SelectCommand =
"Select Name, DOB, CLIENTID From FiscalResult Where ((Name) Like 'DAMRAU*')"It returns nothing?? can you not use this * command???
I believe to accomplish what you're trying to do you'd use %, not *.
But more importantly - you shouldn't be embedding data-access like that directly in the UI - at least if you're trying to adhere to CSLA...
Copyright (c) Marimer LLC