Problem updating BlOB field
Posted: Tue 31 Oct 2006 19:48
I just added a MEDIUMBLOB column to my contacts table for saving images. However, when I try to update a record, I get the following exception:
(CoreLab.MySql) Lost connection to MySQL server during query.
I'm trying to save a Byte[] to the field, using this code:
The update worked fine before I added this field, but I really don't know where to begin with this particular error. I know that the Byte[] is good because I can use it to display the image as such:
(CoreLab.MySql) Lost connection to MySQL server during query.
I'm trying to save a Byte[] to the field, using this code:
Code: Select all
// Put Byte[] in data field
MemoryStream stream = new MemoryStream();
pboxMap.Image.Save( stream,
System.Drawing.Imaging.ImageFormat.Bmp );
farm.Map = stream.ToArray();
// Create a parameter and add to the DbCommand
DbParameter param = GenerateParameter( "Map", farm );
param.Size = farm.Map.Length;
cmd.Parameters.Add( param );
private DbParameter GenerateParameter(
string name,
FarmInfo farm
)
{
PropertyInfo property = FARM_TYPE.GetProperty( name );
DbParameter parameter = GenericDbFactoryHelper.Parameter;
parameter.ParameterName = "@" + name;
parameter.Value = property.GetValue( farm, null );
return parameter;
}
Code: Select all
MemoryStream stream2 = new MemoryStream( farm.Map );
pboxMap.Image = new Bitmap( stream2 );