-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: Mahesh ChandraMouli
Message 3 in Discussion


Hi 
Srini,
 
You 
need to close the Datreader... it can't work in Framework1.0 also check ur code 
again on 1.0... 
This 
is how the datareaders architecture works!
 

in the code 

 
  While 
(reader1.Read())
 ....Some 
code
    reader1.close 
should be added here
   
while(reader2.read())
      
 ....Some code
  end 
while
reader2.close()
end while
reader1.close()
 
 
Regards 
Mahesh 
ChandraMouli 
Global Microsoft Business Unit 
Wipro Technologies 

Bangalore 

  
  -----Original Message-----
From: BDOTNET 
  [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 14, 2003 
  11:41 AM
To: [EMAIL PROTECTED]
Subject: Data 
  Reader Problem


  
    
      
      New Message on BDOTNET
    
      

  Data 
    Reader Problem


    
      
      
        Reply

        
          
            
            
               
              Recommend 
              Message 1 in 
                Discussion 
      
        
          
            
            
              From: Srini Rao 
            
              

                hi,
                     I am facing problem with 
                datareader,the error i am getting is  "There is already an open 
                DataReader associated with this Connection which must be closed 
                first."
                 
                in the code 
                
                 
                  While 
                (reader1.Read())
                 ....Some 
                code
                   
                while(reader2.read())
                       ....Some 
                code
                  end 
                while
                reader2.close()
                end 
                while
                reader1.close()
                 
                i 
                am using two different SQLCommand objects and two different 
                readers.the same piece of code working fine dotnetframe work 
                1.0/VS.net ,now i have upgraded to dotnetframework 1.1/VS2003 
                and i changes the data source from Oracle to SQL Server 
                
                 
                If 
                any body face similar kind of problem let me 
                know.
                 
                thanks
                -Srini
                 
View other groups in this 
    category. 



-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to