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

In This Topic
    Position Property (MySqlBlob)
    In This Topic
    Gets the current read position in the MySqlBlob stream.
    Syntax
    'Declaration
     
    Public Overrides Property Position As Long
    public override long Position {get; set;}

    Property Value

    The current position within the MySqlBlob stream.
    Remarks
    The stream must support seeking to get or set the position. Use the CanSeek property to determine whether the stream supports seeking.
    Example
    void ReverseBlob()
    {
      byte[] byteArray = { (byte)'A', (byte)'B', (byte)'C' };
      MySqlBlob blobFrom = new MySqlBlob(byteArray);
      //blobFrom.ToString() = "ABC"
    
      MySqlBlob blobTo = new MySqlBlob();
      ........
      //reverse MySqlBlob
      if (blobFrom.CanSeek && blobFrom.CanRead && blobTo.CanWrite)
        for (blobFrom.Seek(-1, System.IO.SeekOrigin.End); ;blobFrom.Position -= 2)
        {
          blobTo.WriteByte((byte)blobFrom.ReadByte());
          if (blobFrom.Position == 1) break;
        }
      //blobTo.ToString() = "CBA";
    }
    Private Sub ReverseBlob()
      Dim byteArray As Byte() = New Byte() {AscW("A"c), AscW("B"c), AscW("C"c)}
      Dim blobFrom As New MySqlBlob(byteArray)
      ' blobFrom.ToString() = "ABC"
    
      Dim blobTo As New MySqlBlob
      ......
      ' reverse MySqlBlob
      If ((blobFrom.CanSeek AndAlso blobFrom.CanRead) AndAlso blobTo.CanWrite) Then
        blobFrom.Seek(CLng(-1), System.IO.SeekOrigin.End)
        Do While True
          blobTo.WriteByte(CByte(blobFrom.ReadByte))
          If (blobFrom.Position = 1) Then
            Return
          End If
          blobFrom.Position = blobFrom.Position - 2
        Loop
      End If
      ' blobTo.ToString() = "CBA";
    End Sub
    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

    See Also