Bind datagrid to SQL query using a CURSOR

Discussion in 'ASP .Net' started by Niclas, Jun 23, 2006.

  1. Niclas

    Niclas Guest

    Hi,

    I am using a SQL query that uses a CURSOR to loop and executes a SELECT
    statement in each loop. When I bind a datagrid to this stored procedure
    through a datareader as data source, I only get the first SELECT statement
    in the grid.

    Is there a known workaround to this ?

    Niclas
     
    Niclas, Jun 23, 2006
    #1
    1. Advertising

  2. Post some snippet code
    Patrick

    "Niclas" <> wrote in message
    news:%...
    > Hi,
    >
    > I am using a SQL query that uses a CURSOR to loop and executes a SELECT
    > statement in each loop. When I bind a datagrid to this stored procedure
    > through a datareader as data source, I only get the first SELECT statement
    > in the grid.
    >
    > Is there a known workaround to this ?
    >
    > Niclas
    >
     
    Patrick.O.Ige, Jun 24, 2006
    #2
    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. =?Utf-8?B?VG9tYXMgS2VwaWM=?=

    Changing DEFAULT cursor to WAIT cursor in ASP

    =?Utf-8?B?VG9tYXMgS2VwaWM=?=, Apr 5, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    2,378
    Bruce Barker
    Apr 5, 2005
  2. mr2_93
    Replies:
    1
    Views:
    3,675
    mr2_93
    Oct 2, 2005
  3. Anonymous
    Replies:
    0
    Views:
    1,548
    Anonymous
    Oct 13, 2005
  4. invy
    Replies:
    4
    Views:
    422
    CBFalconer
    Dec 28, 2006
  5. dmaziuk
    Replies:
    3
    Views:
    630
    Chris Gonnerman
    Jan 25, 2011
Loading...

Share This Page