Home Forums C# Programming sql query problem

Tagged: ,

Viewing 0 reply threads
  • Author
    • #1927

      This is an asp.net web page source code in C#. on the Button1_Click event it searches the data base and returns the records fetched. We create the query on the basis of drop down list box ‘SearchType’ and the query text from the text box ‘Q’. Now when it creates the query that query doesnt return any record. for example for slected index 1 and Q=”x” it shows no result from the data base which have the following table and records.

      query it generates is: select * from book where name like '*x*' OR description like '*x*'; but when i run this query in MS access database it returns the two records. Why is it so, any one have an idea. thanks

      • This topic was modified 1 year, 5 months ago by M. Saqib.

Viewing 0 reply threads
  • The forum ‘C# Programming’ is closed to new topics and replies.