(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 );