SetLength Method

In This Topic

Syntax
Remarks
Example
See Also

Sets length for MySqlBlob value.

Syntax

Visual Basic
C#

public override void SetLength( 
   long len
)

'Declaration
 
Public Overrides Sub SetLength( _
   ByVal len As Long _
)

Parameters

len: The size of the MySqlBlob in bytes.

Remarks

If the given value is less than the current length of the stream, the stream is truncated. If the given value is larger than the current length of the stream, the stream is expanded. If the stream is expanded, the contents of the stream between the old and the new length are undefined.

Example

csharp

MySqlDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
MySqlBlob pictureBlob = pictureReader.GetMySqlBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);

Visual Basic

Dim pictureReader As MySqlDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As MySqlBlob = pictureReader.GetMySqlBlob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If

Reference

MySqlBlob Class
MySqlBlob Members
Length Property

Send Feedback