السلام عليكم
هذه الرسالى تظهر عند الضغط على البوتن
inviled operation the connection is closed
ما معنى هذه الرسالة وما هو المطلوب بالظبط
والكود هو:
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim con As New OracleConnection("Server=orcl;user id=scott;password=tiger;Data Source=orcl")
Dim da As New OracleDataAdapter("select * From Blobtable", con)
Dim MyCB As OracleCommand = New OracleCommand()
Dim ds As New System.Data.DataSet
MyCB.CommandType = Data.CommandType.Text
con.Open()
Dim oraReader As OracleDataReader = MyCB.ExecuteReader()
If oraReader.Read() Then
Response.BinaryWrite(CType(oraReader("Blobdata"), Byte()))
End If
da.Fill(ds, "Blobtable")
Response.Buffer = True
Response.ContentType = "application/pdf"
MyCB = Nothing
ds = Nothing
da = Nothing
oraReader.Close()
con.Close()
con = Nothing
End Sub
