Error - 'There is already an open DataReader ... RSS

• • Reply
  

  aspDev3

  Member

  564 Points

  125 Posts

  Error - 'There is already an open DataReader ...

  Aug 28, 2003 03:33 AM|LINK

  There is already an open DataReader associated with this Connection which must be closed first Dim myCMD As SqlCommand = New SqlCommand("Select * from ZZZ", objConn) Dim myReader As SqlDataReader = myCMD.ExecuteReader() response.write(myReader.GetName(0) & vbTab & myReader.GetName(1) & vbCrLf & "
  ") Do While myReader.Read() response.write(myReader.GetString(0) & vbTab & myReader.GetString(1) & vbCrLf & "
  ") Dim myRecord As SqlCommand = New SqlCommand("Select * from ZZZ2 where fielname = '" & myReader.GetString(0) & "'", objConn) Dim myReader2 As SqlDataReader = myRecord.ExecuteReader() Do While myReader2.Read() response.write(myReader2.GetString(0) & vbTab & myReader2.GetString(1) & vbCrLf & "
  ") Loop Loop
• • Reply
  

  n1ckP

  Member

  650 Points

  130 Posts

  Re: Error - 'There is already an open DataReader ...

  Aug 28, 2003 01:17 PM|LINK

  you hear the nice compiler :) you can't have two open datareaders using the same open connection. either store the contents of the first in an array and close it, or use different connections.
  "Can't sleep, clowns will eat me... can't sleep clowns will eat me, can't sleep clowns will eat me"
  
  
  
  
  
  Nick Patterson
  
  
  Systems Architect