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. Advertisements

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. Nick
    Replies:
    0
    Views:
    556
  2. VB Programmer
    Replies:
    1
    Views:
    4,037
    Vijay
    Apr 9, 2006
  3. Dave
    Replies:
    1
    Views:
    423
    Leor Zolman
    Apr 8, 2004
  4. =?Utf-8?B?QXJ0?=

    Page inherting from .master - unexpected results

    =?Utf-8?B?QXJ0?=, May 26, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    446
    =?Utf-8?B?QXJ0?=
    May 26, 2006
  5. CK
    Replies:
    3
    Views:
    439
  6. Steven D'Aprano

    Unexpected timing results

    Steven D'Aprano, Feb 23, 2006, in forum: Python
    Replies:
    7
    Views:
    622
    Steven D'Aprano
    Feb 24, 2006
  7. VB Programmer
    Replies:
    1
    Views:
    14,852
    Nanda Lella[MSFT]
    Aug 17, 2006
  8. jobs
    Replies:
    0
    Views:
    946
Loading...