R
Rick Csucsai
I am trying to get a handful of records returned via the following query
using a datareader and then binding it to a datagrid:
Select * from documents WHERE (title LIKE '*network*') Order By department,
headername, title;
It keeps returning 0 records. Note that if I take out the crieteria for the
LIKE clause, it returns just fine. If I copy and paste this into a query
within the database itself, if works fine! Why will asp.net not return the
records? I have tried formatting it in a million different ways. All of
which work directly in the database, buy none when I try to go through the
datareader.
Any suggestions? Known bugs? Anything?
using a datareader and then binding it to a datagrid:
Select * from documents WHERE (title LIKE '*network*') Order By department,
headername, title;
It keeps returning 0 records. Note that if I take out the crieteria for the
LIKE clause, it returns just fine. If I copy and paste this into a query
within the database itself, if works fine! Why will asp.net not return the
records? I have tried formatting it in a million different ways. All of
which work directly in the database, buy none when I try to go through the
datareader.
Any suggestions? Known bugs? Anything?