KB IssueWhen trying to use a closed recordset, this error will appear: "Invalid attempt to call MetaData when reader is closed."

Issue Details

When closing a datareader or dataset, you cannot use the recordset unless you create a Global Variable to use instead.

Recreate Issue

Using the following code will reproduce the error.

[ASP.NET - VB Reader Object]

CFFCS | CarrzSynEdit: | ASP.NET (VB/C#)

If rs1.Read() Then
    dim theRecord as Integer = rs1("AlbumArtistID")
    End If
    rs1.Close()
'============Then use this down the page.========
getAlbumID.Parameters.Add(New SqlParameter("@ID", rs1("ID")))

Resolve Issue

If you are going to close your Reader / Dataset and intend to make a call to the record, you will need to create a Global Variable.

[ASP.NET - VB Reader Object with a Global Variable]

CFFCS | CarrzSynEdit: | ASP.NET (VB/C#)

Public Class GlobalVariables
     Public Shared theRecord As Integer
End Class
               If rs1.Read() Then
                   GlobalVariables.theRecord = rs1("AlbumArtistID")
               End If
               rs1.Close()