Parameterized query with % wildcard character is working from query builder but not from 2005 RRS feed

  • Question

  • Hi

    I am writing a windows Form Application in Visual 2005 I have created a query in query builder

    SELECT     [Roll Number], Class, Section, [Student Name], [Fathers Name], Status
    FROM         [Students Info]
    WHERE     ([Roll Number] LIKE '%' + @Rollno + '%')


    query is working fine in query builder but when I provide parameter value from a textbox then it returns nothing.

    Me.Students_InfoTableAdapter.Fill(Me.StudentBasicSearch.Students_Info, Svalue.Text)


    Let me know whats wrong with my code. Please help me.



    Thursday, June 28, 2007 5:34 AM

All replies

  • Hi Zafar Ansari,
      I am moving this thread from Visual Basic Express Edition forum to the .NET Framework Data Access and Storage forum, since the issue is related to .net Data Access. There are more .net Data Access experts in the .NET Framework Data Access and Storage forum.
    Thanks for your understanding!
    Monday, July 2, 2007 3:03 AM