dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteBlob Class / Value Property
Example

In This Topic
    Value Property (SQLiteBlob)
    In This Topic
    Gets the value of the SQLiteBlob object.
    Syntax
    'Declaration
     
    Public ReadOnly Property Value As Byte()
    public byte[] Value {get;}

    Property Value

    The value of the SQLiteBlob 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 SQLiteDataReader.GetSQLiteBlob method and then written to a stream.
    SQLiteBlob myBlob = myReader.GetSQLiteBlob(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 SQLiteBlob = myReader.GetSQLiteBlob(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