problem to insert an image into a database using programatically

• • Reply

  14 years ago

  by nib

  Baye kito

  Addis Ababa, Ethiopia

  Joined 14 years ago

  Hi everyone

  I am trying to insert an image into a database table field using sqlCommand object method ExecuteNonQuery().  My SQL statement has a parameter to assign the image. I keep getting an error saying "the object need to implement IConvertable". I don't know why?

  any help !

  'i wrote like this.........

  sql = "UPDATE tablename SET field1 = @image"

  dim picture as image = picturebox1.image

  Try

      SqlCommand(sql, cn)

     Dim par As New SqlParameter("@picture", SqlDbType.Image)

     par.Value = picture

     cmd.Parameters.Add(par)

     cmd.ExecuteNonQuery()

  Catch e As InvalidCastException

     MessageBox.Show(e.Message)

  End try

  Report abuse