Why doesn't this line work?
SqlDataSource1.SelectCommand = "SELECT ID, WOD, Date FROM dbo.tblWOD WHERE WOD LIKE '%@searchPhrase%' ORDER BY ID DESC";
from code below...
string searchPhrase = "";
if (Session["SearchQuery"] != null)
{
searchPhrase = (string)Session["SearchQuery"];
lblKeyword.Text = searchPhrase;
if (searchPhrase != null)
{
Boolean answerCheck = Regex.IsMatch(searchPhrase, @"[,;']+");
if (answerCheck == false)
{
SqlDataSource1.SelectCommand = "SELECT ID, WOD, Date FROM dbo.tblWOD WHERE WOD LIKE '%@searchPhrase%' ORDER BY ID DESC";
SqlDataSource1.SelectParameters.Add(new QueryStringParameter("searchPhrase", "searchPhrase"));
}
else
{
SqlDataSource1.SelectCommand = "";
...
Go to the complete details ...