Unexpected SQLDataSource Results

J

Jonathan Wood

I have a grid view bound to a SqlDataSource control. The grid view is empty
(shows my empty-data template) when I expect it to have rows.

I set a breakpoint in the data source control's Selecting method and
examined the select command along with the three parameters that I've
specified. If I copy the command to an editor and replace the named
parameters with the values, and paste the result into a SQL query, I do in
fact see the rows I expect.

The only "fudging" I had to do was surround the Guid argument with single
quotes. And then it works fine.

Is there any way I can look to see exactly what query is being created so I
can try and determine what is wrong? I get no errors.

Thanks for any thoughts.

Jonathan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,009
Latest member
GidgetGamb

Latest Threads

Top