Well I'm not using a datareader unless it is used internally to a SQLDataAdapter which it may very well be.
I do the following: daGetRunningParams.Fill(dsRunningParams) where daGetRunningParams is a DataAdapter that executes an SQL statement to get a table back. I had just assumed it used a datareader internal to that. Is that not the case? I have no datareaders explicitly declared anywhere. =Blain -----Original Message----- From: The DOTNET list will be retired 7/1/02 [mailto:[EMAIL PROTECTED]] On Behalf Of Greg Ward Sent: Wednesday, June 05, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Connection Question No, you said that the error was an open DataReader, not a DataSet. I'm assuming you use the DataReader to fetch the data and then load the data into the DataSet. If so then you need to do ... myDataReader.Close() > -----Original Message----- > From: The DOTNET list will be retired 7/1/02 > [mailto:[EMAIL PROTECTED]]On Behalf Of Blain Timberlake > Sent: Wednesday, June 05, 2002 9:04 AM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] Connection Question > > > So you mean when I do the declaration for the: > Dim dsRunningParams As DataSet = New DataSet() > ? You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
