I'm trying to figure out how I can get around an error I get when multiple users are accessing different my site. I'm getting an error:
there is already an open datareader associated with this
connection which must be closed first
It's not the same query everytime but I recently triggered it on this statement:
Dim adapterSavedState As New SQLDataAdapter("SELECT SavedStateContactView, SavedStatePropertyView, SavedStateTransView, SavedStateCompanyView FROM WebusersProfiles WHERE ContactID = '" & Session("ContactID") & "'", myConnection)
Dim dtSavedState As New DataTable()
adapterSavedState.Fill(dtSavedState)
Dim rowSavedState As DataRow
For Each rowSavedState In dtSavedState.Rows
If Request.QueryString("View") = "Contact" Then
SavedState = rowSavedState("SavedStateContactView").ToString()
Else If Request.QueryString("View") = "Property" Then
SavedState = rowSavedState("SavedStatePropertyView").ToString()
Else If Request.QueryString("View") = "Trans" Then
SavedState = rowSavedState("SavedStateTransView").ToString()
Else If Request.QueryString("View") = "Company" Then
SavedState = rowSavedState("SavedStateCompanyView").ToString()
End If
Next rowSavedState
I define my connection in my basepage
Public Dim MyConnection As SqlConnection
Public Shared Dim strSite As String = "dev"
Protected Overrides Sub OnLoad(ByVal e As System.EventArgs)
myConnection = New SqlConnection("server=xxxx;database=xxxxx;User ID=xxxxx;Password=xxxxx;")
Where is my issue and how can I overcome it? This is a .net 1.1 site so MARS I know is not available...
View Complete Post