dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlBlob Class / Value Property
Example

Value Property (MySqlBlob)
Gets the value of the MySqlBlob object.
Syntax
'Declaration
 
Public ReadOnly Property Value As Byte()
 

Property Value

The value of the MySqlBlob object.
Remarks
Check the IsNull property before reading the Value property to avoid raising an exception.
Example
This code fragment downloads a BLOB field from a table to a file. Value property is initialized by calling MySqlDataReader.GetMySqlBlob method and then written to a stream.
MySqlBlob myBlob = myReader.GetMySqlBlob(myReader.GetOrdinal("Picture"));
if(!myBlob.IsNull)
{
  string FN = myReader.GetString(myReader.GetOrdinal("PicName"));
  FileStream fs = new FileStream("D:\\Tmp\\"+FN+".bmp", FileMode.Create);
  fs.Write(myBlob.Value,0,(int)myBlob.Length);
  fs.Close();
  Console.WriteLine(FN+" downloaded.");
}
Dim myBlob As MySqlBlob = myReader.GetMySqlBlob(myReader.GetOrdinal("Picture"))
If Not myBlob.IsNull Then
  Dim FN As String = myReader.GetString(myReader.GetOrdinal("PicName"))
  Dim fs As FileStream = New FileStream("D:\Tmp\" + FN + ".bmp", FileMode.Create)
  fs.Write(myBlob.Value, 0, Convert.ToInt32(myBlob.Length))
  fs.Close()
  Console.WriteLine(String.Concat(FN, " downloaded."))
End If
See Also