Posts

Showing posts from December, 2011

Solution - There is already an open DataReader associated with this Command which must be closed first.

Image
OleDB Error There is already an open DataReader associated with this Command which must be closed first. OleDB Error : There is already an open DataReader associated with this Command Problem There is already an open DataReader associated with this Command which must be closed first. Cause Having more than 1 dataReader result set working at the same time . Solution In my solution example, I work with Sql Server 2000 and VB.Net 2005  The VB. Net Example Project can be downloaded at the end of this post It contains (Sql Server 2000 DataBase - VB.Net Project) The example shows how to : Navigate (First Record - Next Record) using ADO Net 2.0 Online-Mode using SqlClient DataReader ... Sql Database Name : Market Sql Database Table : Market.Info Server Name : evry1falls (in order to see the example correctly, you'll have to Import the Database 'Market' into your sql server 2000 Enterprise Manager) Photo1 : Applica