Length Property (SQLiteBlob)

In This Topic

Syntax
Remarks
Example
See Also

Gets the size of the SQLiteBlob.

Syntax

Visual Basic
C#

public override long Length {get;}

'Declaration
 
Public Overrides ReadOnly Property Length As Long

Property Value

The size of the SQLiteBlob in bytes.

Remarks

The size of the SQLiteBlob is always returned in bytes for all data types.

Example

csharp

SQLiteDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
SQLiteBlob pictureBlob = pictureReader.GetSQLiteBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);

Visual Basic

Dim pictureReader As SQLiteDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As SQLiteBlob = pictureReader.GetSQLiteBlob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If

Reference

SQLiteBlob Class
SQLiteBlob Members
SetLength Method

Send Feedback