asp.net - 使用 vb.net 从 asp.net 中的 SQL Server 数据库中读取下拉列表中所选项目的图像

Question

我想从下拉列表中检索任何选定项目的图像。我在线上遇到错误

Image1.ImageUrl = Image.FromStream(ms)

这是我的代码：

  Public Sub Presdorpic()
    myconnection = New SqlConnection(a)
    myconnection.Open()
    Dim str As String
    str = "SELECT Picture FROM candidates WHERE Fname = '" & ddlPresident.SelectedItem.Text & "'"
    Dim cmd As SqlCommand = New SqlCommand(str, myconnection)
    dr = cmd.ExecuteReader
    While dr.Read()
        Try

            Dim data As Byte() = DirectCast(dr("Picture"), Byte())
            Dim ms As New IO.MemoryStream(data)
            Image1.ImageUrl = Image.FromStream(ms)
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

    End While
End Sub

标签： asp.netsql-server