troubleshooting Question

Why do I get: "There is already an open datareader associated with this command which must be closed first"

Avatar of Butler Bros
Butler BrosFlag for United States of America asked on
.NET ProgrammingMicrosoft SQL Server
8 Comments1 Solution22 ViewsLast Modified:
I'm getting: "There is already an open datareader associated with this command which must be closed first"

Hi, I've got  a TabControl, with several TabPages, with RadGridViews in them.

I pretty much let the GUI do most of the wiring up of the grids & data..

Everything seems to be working except, I'm getting the Subject's message when I Add a new Row.

As soon as the row is added, I get the icon on the row, and that message.(I'm testing by using the  "ItemNumberChanges" tab)

The row adds just fine, and I can update it, & delete it as well.

The Add  function(by using the built-in "Click here to add a new row" fires off:

    Private Sub RadGridView_ItemNumberChanges_UserAddedRow(sender As Object, e As Telerik.WinControls.UI.GridViewRowEventArgs) Handles RadGridView_ItemNumberChanges.UserAddedRow
    End Sub

Open in new window

From there, it goes to the:  ReportServerDataSet_Item_No_Changes.vb, and to:

Public Overloads Overridable Function Update(ByVal dataSet As ReportServerDataSet_Item_No_Changes) As Integer
            Return Me.Adapter.Update(dataSet, "cribcrawl_Item_No_Changes")
        End Function

Open in new window

Butler Bros
IT Dept

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros