Solution - There is already an open DataReader associated with this Command which must be closed first.
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 SqlServer2000 and VB.Net 2005 The Example Project can be downloaded at the end of this post : It contains (SqlServer2000 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 sqlserver2000 Enterprise Manager) Photo1 : Application Final Design
Photo2 : Table Structure Photo3 : Codes Photo4 : Codes Photo5 : Codes Now if you run the project and tried to navigate using (First) or (Next) you…