Results 1 to 3 of 3

Thread: SqlDataReader

  1. Jun 13th, 2005, 05:12 AM #1
    sara_22
    sara_22 is offline

    Thread Starter
    Junior Member
    Join Date
    Feb 2005
    Posts
    21

    SqlDataReader

    i have SqlDataReader variable in one page which
    retrive results from database and i want to dispaly results in another page
    i tried using application object but the following error appears
    Invalid attempt to read when no data is present
    Reply With Quote Reply With Quote
  2. Jun 13th, 2005, 05:52 AM #2
    Nikhil Aggarwal
    Nikhil Aggarwal is offline
    Member Nikhil Aggarwal's Avatar
    Join Date
    Jun 2005
    Location
    New Delhi, India
    Posts
    36

    Re: SqlDataReader

    Try using a DataSet instead. SQLDataReader's need an open connection to work correctly. In all probablity when you Redirect to the second page, the reference to the connection is killed and hence it doesnt work.
    Nikhil Aggarwal
    Reply With Quote Reply With Quote
  3. Jun 13th, 2005, 07:12 AM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: SqlDataReader

    Why not re-retrieve the data in the second page?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width