There is already an open DataReader associated with this Command which must be closed first.
Hi there,I get this error line 34.If I close datareader on line28 dr.close --> I can not go on read the data at while (dr.read()) scopeWhat should I do ? 1 2 SqlDataReader dr = nul; 3 sqlcommand cmd = nul; 4 protected void Page_Load(object sender, EventArgs e) 5 { 6 //COMMAND ITEMS CMD,CONN ETC 7 8 conn.Open(); 9 dr = cmd.ExecuteReader(); 10 while (dr.Read()) 11 { 12 I READ THE DATA 13 MYFUNCTION RUN HERE 14 } 15 16 dr.close(); 17 ...

There is already an open DataReader associated with this Command which must be closed first.
Hi, Could you please help me with the following issue?  1 SqlConnection thisConnection = new SqlConnection(@"Network Library=*******;Data Source=*******;database=******;User id=*****;Password=****");2 thisConnection.Open();3 SqlCommand thisCommand = thisConnection.CreateCommand();4 5 SqlCommand thisCommand2 = thisConnection.CreateCommand();6 thisCommand2.CommandText = "SELECT DISTINCT username FROM Employment";7 SqlDataReader thisReader2 = thisCommand2.E...

There is already an open DataReader associated with this Command which must be closed first.
System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. System.InvalidOperationException:   I need to insert in one table based on another table results so I made this, but I have that error on the executenonquery line. If I close the datareader I wont be able to insert the rows,    SqlCommand cmdConsultarEvaluadores = new SqlCommand("select * from TGSC_EVALUADORESXCICLOEMPRESA where nmciclo=@NmCiclo and nmempresa=@NmEmpresa and nmcargoevaluando=@NmCargoEvaluando", conn);    ...

There is already an open DataReader associated with this Command which must be closed first.
This doesn't seem to be a true statement based on my code, as I far as I can tell.  So, what needs to change in my code? Partial Class AddCall    Inherits System.Web.UI.Page    Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged        DropDownList2.SelectedIndex = 0    End Sub    Protected Sub DropDownList2_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Drop...

There is already an open DataReader associated with this Command which must be closed first. #2
I'm running a recordset against another, but is displaying the error: There is already an open DataReader associated with this Command which must be closed first. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.Source Error: Line 77: sqlCmd2 = New SqlCommand("select modulos...

There is already an open DataReader associated with this Command which must be closed first. #2
 Greetings!I'm experiencing this problem. Any suggestions? Here's the code below...  1 Dim Mycmd As SqlCommand 2 Mycmd = New SqlCommand("WEB_CT_select_CountryListNotNull", myConnection) 3 Mycmd.CommandType = CommandType.StoredProcedure 4 5 Dim myReader As SqlDataReader 6 7 myReader = Mycmd.ExecuteReader() 8 9 While myReader.Read() 10 'Response.Write("country code " & myReader(0).ToString() & " - ")...

There is already an open DataReader associated with this Command which must be closed first. #2
I have the below code and when I run it I get the error stated in the title, I have Dim dsEmail As DataSet on top in the class.   Dim sqlCon As New SqlConnection Dim sqlCmd As New SqlCommand Dim sqlDA As New SqlDataAdapter '* Configure and open connection sqlCon.ConnectionString = My.Settings.ConnectionString sqlCon.Open() '* Configure command object sqlCmd.CommandText = "EmailToSend" sqlCmd.CommandType = CommandType.StoredProcedure sqlCmd.Connection = sqlCon ...

Already an opened DataReader associated with this command exists, must close it first
Hello I have a page asp.net that does a query to database directly.using (SqlConnection con = new SqlConnection(ObtenerCadenaConx(bd))) { con.Open();SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader r = cmd.ExecuteReader(); ** } This works fine except sometimes this produces the error "Already an opened DataReader associated with this command exists, must close it first" in the line **.But after some minutes, already works fine. Why will it be produced? Thanks for your attention. Regards. C Use this behavior;  SqlDataReader r = cmd.ExecuteReader...

There is already an open DataReader associated with this Command which must be closed first. #3
Hi I am getting the following error message "There is already an open DataReader associated with this Command which must be closed first."when the code below hits the line:sqltrans.commit() it throws the exception above.I am running VS2005, .NET 2.0 against a SQL Server 2000 database.This code worked fine on .NET 1.1 but since the conversion it no longer works.I would prefer not to use MARS multiple active record sets and I don't believe SQL Server 2000 supports it regardless.This error occured multiple times in other parts of this web app and I was able to fix them, this one d...

There is already an open DataReader associated with this Command which must be closed first. #4
 hi,i  m geting an error "There is already an open DataReader associated with this Command which must be closed first."but when im working whith MS access im not geting this error ,but in sql server2005 produce this errror ,..... plz hlp me out of this when you use datareader you have to close it after finished using it and before close the connection by using close() method ex. dr.Close() this should solve your problemRegards...Nassar, RamiMy Blog || E-Mail Don't forget to click "Mark as Answer" on the post that helped you.This credits that membe...

There is already an open DataReader associated with this Command which must be closed first. #2
hi guys, i have a code liek this dim rs as data.sqlclient.sqldatareader rs = objcmd.executereader while rs.has rows  dim objcmd2 as new sqlclient.sqlcommand("call storedprocedure,connection") objcmd2.parameters.addwithavlue("",rs.item()) objcmd2.executenonquery end while   the syntax so far is ok but everytime when i run it has this error message There is already an open DataReader associated with this Command which must be closed first. why is that guys? if any one knows please help me. thank you Try this: http://dotnetslackers.com/Community/blogs/...

How to fix this error? (There is already an open DataReader associated with this Command which must be closed first.)
This is my code:1 If Session("ctr") = False Then 2 3 Connect() 4 5 SQL = "SELECT * FROM counter" 6 SQL = SQL & " WHERE ipaddress='" & Request.ServerVariables("REMOTE_ADDR") & "'" 7 dbRead() 8 9 If dbReader.HasRows = True Then 10 11 dbReader.Read() 12 hits = dbReader("hits") 13 hits = hits + 1 14 ...

Run-time exception thrown : System.InvalidOperationException
I don't understand why i am getting this error. i got MARS enabled in the connection string. i have a single connection object and a single datareader, using visual studio 2005  Dim showString As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True;Connection TimeOut=60;MultipleActiveResultSets=True;" Dim myDataReader2 As SqlDataReadereId = Long.Parse(Me.Request("id"))Dim get_Single = "some sql query here"             ...