Member Avatar for tqmd1

Dear Experts

I use following codes to display image from sql server.

On this line of codes

Dim ms As New IO.MemoryStream(CType(row("user_img"), Byte()))

this error messages appears

Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.

How to get rid of this error message.
This message appears because image column is NULL.

Dim cmd As New SqlClient.SqlCommand("select user_img from login where user_sno =" & Val(Me.TextBox1.Text), con)
        Dim dr As SqlClient.SqlDataReader = cmd.ExecuteReader()
        Dim dt As New DataTable
        dt.Load(dr)
        Dim row As DataRow = dt.Rows(0)

        If dt.Rows.Count > 0 Then

            Dim ms As New IO.MemoryStream(CType(row("user_img"), Byte()))
            Dim img As Image = Image.FromStream(ms)
            PictureBox1.Image = img
        End If

Please Help

  • 2 Contributors
  • 1 Reply
  • 707 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

I tried to convince you that you had a null value in another thread:
http://www.daniweb.com/forums/thread248684-2.html

I guess now you agree it is in fact a null? Please continue with the older thread instead of this one since it is the same question.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.