asp.net + access 2003
-
when i run a query like Select id, documenttitle, filepath from testdocuments where documenttitle like + "*" + filename + "*" + "' "; then it does not fetch rows. IF in access database i run same query it fetches rows. I could not figure it out what can be the cause. Can anyone please let me know . Thanks.
-
when i run a query like Select id, documenttitle, filepath from testdocuments where documenttitle like + "*" + filename + "*" + "' "; then it does not fetch rows. IF in access database i run same query it fetches rows. I could not figure it out what can be the cause. Can anyone please let me know . Thanks.
hi ritu4321, I think you need to check your database connectivity and SQL statement's execution. If everything is fine then please check your query contains '*' instead of '%' string command = "Select id, documenttitle, filepath from testdocuments where documenttitle like '%" + filename + "%'"; Hope this will help you. Thanks & Regards Dilip Kumar Vishwakarma
Programmer .Net Consulting