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
    Jonathan Wood, Sep 17, 2008
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Scott Lander

    Re: unexpected results

    Scott Lander, Jul 7, 2003, in forum: Perl
    Replies:
    0
    Views:
    1,731
    Scott Lander
    Jul 7, 2003
  2. Nick
    Replies:
    0
    Views:
    459
  3. VB Programmer
    Replies:
    1
    Views:
    3,894
    Vijay
    Apr 9, 2006
  4. VB Programmer
    Replies:
    1
    Views:
    14,688
    Nanda Lella[MSFT]
    Aug 17, 2006
  5. jobs
    Replies:
    0
    Views:
    861
Loading...

Share This Page