FilterExpression via code doesn't work...

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Bobby Edward

    FilterExpression via code doesn't work...

    I'm trying to filter an objectdatasourc e based on words in a textbox.
    Here's how I'm doing it...

    With odsProjects
    .FilterParamete rs.Clear()
    .FilterExpressi on = "ProjectTit le LIKE %{0}%"
    Dim p As New System.Web.UI.W ebControls.Para meter("ProjectT itle",
    Data.DbType.Str ing, txtKeywords.Tex t)
    .FilterParamete rs.Add(p)
    .DataBind()
    End With

    This doesn't work.

    In fact I get the following error. Can you assist me??? Thanks...

    Syntax error: Missing operand before 'Mod' operator.
    Description: An unhandled exception occurred during the execution of the
    current web request. Please review the stack trace for more information
    about the error and where it originated in the code.

    Exception Details: System.Data.Syn taxErrorExcepti on: Syntax error: Missing
    operand before 'Mod' operator.


Working...