Two Datareaders??
I need some direction
I have a huge Sql2k db and I need to get information from several tables. I created the stored proc's to get the info I need.
I have a datareader that runs the Sp with a Parameter
I then need to call another sp_w/parameter while looping through the first reader.
ex:
dr=cmd.ExecuteReader
while dr.read()
PatientID= dr.getstring(0)
Patient(PatientID)
next
Private Sub Patient(byVal PatientID)
execute another reader
while dr.read()
do some stuff
next
end sub
------
What is the Best way to do this, two Datareaders just wont work in the same connection.
|