Value Property (SQLiteBlob)

In This Topic

Gets the value of the SQLiteBlob object.

Syntax

Visual Basic
C#

'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.

csharp

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.");
}

Visual Basic

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SQLiteBlob Class
SQLiteBlob Members
Read Method
Write Method

Send Feedback