Re: Storing/Retrieving BLOB Data directly into a PictureBox in VB.NET

[Subu Mysore]

I am getting an error...Data too long for column. I am trying the following code
fs = New FileStream(strImgName, _
FileMode.Open, FileAccess.Read)
FileSize = fs.Length

rawData = New Byte(FileSize) {}
fs.Read(rawData, 0, FileSize)
fs.Close()
CONN.Open()
cmd.Connection = CONN
cmd.CommandText = "prc_AddUpdateImage"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("pID", Nothing)
cmd.Parameters.AddWithValue("pImageID", clsImageID)
cmd.Parameters.AddWithValue("pFileName", "NewImageName")
cmd.Parameters.AddWithValue("pFileExt", "jpg")
cmd.Parameters.AddWithValue("pImageContent", rawData)
cmd.ExecuteNonQuery()
CONN.Close()

Using vb.net 3.5, .NET Connector 5.2.2.0, Image Size= 300kb, Column = LONGBLOB and charset=Latin1

Please help