How to read binary data from MySQL / vb.net

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • balasubramanya
    New Member
    • Sep 2010
    • 1

    #1

    How to read binary data from MySQL / vb.net

    how to read this "†Z`ÌómF{E’½î¼• ûŠ; ;D*²cú³Ôš–Sœà øq‰’îfˆÔef«‡" data from MySQL database

    here is my code


    Dim SQL_EXTractIDFR As String = _
    "SELECT systemidentifie r FROM rcdips WHERE rcdips.systemip = @SYSIP"

    Dim CMD_extractIDFR As New MySqlCommand(SQ L_EXTractIDFR, cnnRCD)
    CMD_extractIDFR .Parameters.Add WithValue("@sys ip", SYSip)
    Dim da_extractIDFR As New MySqlDataAdapte r(CMD_extractID FR)
    Dim DS As New DataSet

    da_extractIDFR. Fill(DS, "CX")

    If Not DS.Tables("CX") .Rows.Count = 0 Then
    SYSid = DS.Tables("CX") .Rows(0).Item(0 ).ToString
    Else
    SYSid = "-1"
    End If

    but i am getting SYSid = System.byte[]
    any advise please
Working...