Unexpected SQLDataSource Results


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.