Unexpected SQLDataSource Results

Discussion in 'ASP .Net' started by Jonathan Wood, Sep 17, 2008.

  1. 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 Wood, Sep 17, 2008
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.