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
Microsoft SQL Server.NET Programming
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
        Cribcrawl_Item_No_ChangesTableAdapter.Update(Me.ReportServerDataSet_Item_No_Changes)
    End Sub

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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
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