Put this code in your page

               Dim oAttachment As New GetAttach
                Try
                    Me.Page.Response.Clear()
                    Me.Page.Response.ClearContent()
                    Me.Page.Response.ClearHeaders()
                    Response.ContentType = ""
                    Response.BinaryWrite(oAttachment.GetAttach())
                    Response.AddHeader("content-disposition", "attachment; filename=" + oAttachment.ATTACH\_NAME + "." + oAttachment.EXTENSION)
                    Me.Page.Response.End()
                Catch ex As Exception
                    throw ex
                End Try

GetAttach Class to call getter stored procedure

Public Function GetAttach(ByVal MyParameter As Integer)
Dim docFileReader As SqlDataReader

    Try

        Dim Myadapter As New SqlDataAdapter

        Using connection As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
            Using command As New SqlCommand("GetAttachment", connection)
                command.CommandType = CommandType.StoredProcedure
                command.Parameters.Add(New SqlParameter("@MY\_SP\_PARAMETER", MyParameter))
                connection.Open()
                docFileReader = command.ExecuteReader
                docFileReader.Read()
                EXTENSION = docFileReader.Item("EXTENSION").ToString
                ATTACH\_NAME = docFileReader.Item("ATTACH\_NAME").ToString
                WEIGHT = docFileReader.Item("WEIGHT").ToString
                Dim FileData(docFileReader.GetBytes(0, 0, Nothing, 0, Integer.MaxValue) - 1) As Byte
                docFileReader.GetBytes(0, 0, FileData, 0, FileData.Length)
                docFileReader.Close()

                Return FileData

            End Using
        End Using

    Catch ex As Exception
        If IsNothing(docFileReader) = False Then
            docFileReader.Close()
        End If
        Throw ex
    End Try

End Function

eheheh right Xint0 ;)