Posts

Showing posts from December 9, 2011

Author

Ahmed Samir

Evry1falls is my online name

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

Image
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…

Comment Via facebook