Click here to Skip to main content
15,881,204 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Count the number of database hit were made Pin
desanti25-Aug-19 15:07
desanti25-Aug-19 15:07 
AnswerRe: Count the number of database hit were made Pin
Mycroft Holmes26-Aug-19 12:14
professionalMycroft Holmes26-Aug-19 12:14 
GeneralRe: Count the number of database hit were made Pin
desanti26-Aug-19 13:41
desanti26-Aug-19 13:41 
AnswerRe: Count the number of database hit were made Pin
Richard Deeming27-Aug-19 2:46
mveRichard Deeming27-Aug-19 2:46 
QuestionAre these queries doing the same thing Pin
desanti24-Aug-19 6:37
desanti24-Aug-19 6:37 
QuestionRe: Are these queries doing the same thing Pin
Richard MacCutchan24-Aug-19 20:54
mveRichard MacCutchan24-Aug-19 20:54 
AnswerRe: Are these queries doing the same thing Pin
Eddy Vluggen28-Aug-19 23:49
professionalEddy Vluggen28-Aug-19 23:49 
QuestionDigital Personal fmd.Serialized and fmd.Deserialized Pin
Member 1404752219-Aug-19 22:22
Member 1404752219-Aug-19 22:22 
can someone help me fix my code? i'I'm having problem deserializing the xmlcode save on my database. i can save FMD on database by using Fmd.SerializeXML() but when i'm going to extract record on database i use Fmd.DeserializeXML() but i'm having error. I'm stuck with it.
here is my code.

Public Sub OnVerify(ByVal captureResult As CaptureResult)
        ' Check capture quality and throw an error if bad.
        If Not Me.CheckCaptureResult(captureResult) Then Return

        SendMessage(Action.SendMessage, "A finger was captured.")

        Dim resultConversion As DataResult(Of Fmd) = FeatureExtraction.CreateFmdFromFid(captureResult.Data, Formats.Fmd.ANSI)

        If resultConversion.ResultCode <> Constants.ResultCode.DP_SUCCESS Then
            Me.Reset = True
            Throw New Exception("" & resultConversion.ResultCode.ToString())
        End If

      
        firstFinger = resultConversion.Data
       

        'PULL FINGERPRINT RECORD FROM DATABASE
        Dim FMDDataset As New DataSet
        Dim DBconn As MySqlConnection = New MySqlConnection(connString)
        Dim sql As MySqlCommand = New MySqlCommand("SELECT * " & _
        " FROM tbl_fr ", DBconn)


        DBconn.Open()
        Dim DataAdapter As MySqlDataAdapter = New MySqlDataAdapter()
        DataAdapter.SelectCommand = sql
        FMDDataset.Clear()
        DataAdapter.Fill(FMDDataset, "tbl_fr")
        DBconn.Close()

      

        If FMDDataset.Tables("tbl_fr").Rows.Count > 0 Then
            Dim counter As Integer = 0

            Dim fp1, fp2 As String
            fp1 = Fmd.SerializeXml(resultConversion.Data)

               
                Dim byteS As Byte()
                'data from database
                byteS = FMDDataset.Tables("tbl_fr").Rows(0).Item("frp")


                'im having error on this line of code
                'DP_INVALID_PARAMETER:  Data at the root level is invalid. Line 1, position 1.
                MatchFinger = Fid.DeserializeXml(Convert.ToString(byteS))
               
                Dim resultConversionDATA As DataResult(Of Fmd) = FeatureExtraction.CreateFmdFromFid(MatchFinger, Formats.Fmd.ANSI)
                Dim idResult As DPUruNet.IdentifyResult = DPUruNet.Comparison.Identify(firstFinger, 0, "resultConversionDATA", 2147, 2)
                If (idResult.ResultCode = DPUruNet.Constants.ResultCode.DP_SUCCESS) Then
                    If (idResult.Indexes.Length >= 1) Then  'Found potential match, dont search second collection (speed optimized)
                        MsgBox("RECORD MATCH")
                    Else
                        MsgBox("RECORD MISMATCH")
                    End If
                End If

             

                counter = counter + 1
                Me.BindingContext(FMDDataset, "tbl_fr").Position += 1
            Loop While (counter <= FMDDataset.Tables("tbl_fr").Rows.Count)
            

       End If

    End Sub




HERE IS MY SERIALIZED DATA SAVED ON MY DATABASE.

'1, 1, '<fid><bytes>Rk1SACAyMAABuAAz/v8AAAFlAYgAxQDFAQAAAFZEgKsAzXlTgMUAzn1TgL8Ae5FSQCUAtiJSgEoA9RdSgHcAsHhSgRQArTJQgQgBCSVPQOgAj4lNgQ0AwINMQEgAkR1MQDwA5WJMQQkBBSJLgJIA+R5KgJIA3XVKQCgAliJJQCMA9WBJQKoAV6dJQIoA3nNJgGgBVwVJgO4A9XxHgOsBAh5HQMwBV3pFQIMBMhREQKABO2JEgK0APLJDgNoAVqNCgBUAt4dCQRIBCSRBQGUBQwpBQGUBSGBAQJ4AhnZAgJ4BYw8/QLcAYqE/QMsAXZ4+gCMA2V8+gQUBJok+gNEBZHE+QK0Ae4k9gDcBIwo9QKUBZBI9QPMBJng9gLkAWqA8QK0AXaE8gRQBIHg8QSUAi487gBsA4l07QQ8BLYM7gIgBNgs7gSUAySs7QJ4Ae3E6QPIBNh45gHwBZ1o5QB0A3V44QOcBSHM3gKQAi343QOgBNBs3gLcAcI82gQwBNiw2QPEBSps2QMwBY3E1AKQBXGs1AOEBLBs0ANAAPKc0APgA+Xo0ASYAui8zAJcBPRYzAPcBQZ4zAAA=<format>1769473<version>1.0.0'
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Richard MacCutchan19-Aug-19 23:35
mveRichard MacCutchan19-Aug-19 23:35 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Member 1404752221-Aug-19 21:40
Member 1404752221-Aug-19 21:40 
GeneralRe: Digital Personal fmd.Serialized and fmd.Deserialized Pin
Richard MacCutchan21-Aug-19 21:53
mveRichard MacCutchan21-Aug-19 21:53 
Generalaccess database using vb net Pin
cws_ap15-Aug-19 19:00
cws_ap15-Aug-19 19:00 
GeneralRe: access database using vb net Pin
Richard MacCutchan15-Aug-19 20:45
mveRichard MacCutchan15-Aug-19 20:45 
QuestionOpening the "Windows 10 Settings" form from vb.net possible? Pin
Sam Marrocco14-Aug-19 10:35
Sam Marrocco14-Aug-19 10:35 
AnswerRe: Opening the "Windows 10 Settings" form from vb.net possible? Pin
Richard Deeming15-Aug-19 2:10
mveRichard Deeming15-Aug-19 2:10 
QuestionHow do I copy specific node with children from one document into a new document? Pin
Member 1140330410-Aug-19 6:40
Member 1140330410-Aug-19 6:40 
QuestionI want to make a data selection wizard. Pin
Member 45239717-Aug-19 2:27
Member 45239717-Aug-19 2:27 
AnswerRe: I want to make a data selection wizard. Pin
Eddy Vluggen8-Aug-19 1:14
professionalEddy Vluggen8-Aug-19 1:14 
GeneralRe: I want to make a data selection wizard. Pin
Member 45239718-Aug-19 21:17
Member 45239718-Aug-19 21:17 
SuggestionRe: I want to make a data selection wizard. Pin
Ralf Meier8-Aug-19 23:40
mveRalf Meier8-Aug-19 23:40 
QuestionBoss Key in Vb .Net Pin
Ahmed Neutron6-Aug-19 9:53
Ahmed Neutron6-Aug-19 9:53 
AnswerRe: Boss Key in Vb .Net Pin
ZurdoDev6-Aug-19 10:02
professionalZurdoDev6-Aug-19 10:02 
AnswerRe: Boss Key in Vb .Net Pin
Richard MacCutchan6-Aug-19 20:06
mveRichard MacCutchan6-Aug-19 20:06 
QuestionSource Convert VB.Net to C# Pin
Baloch_khan6-Aug-19 8:59
Baloch_khan6-Aug-19 8:59 
AnswerRe: Source Convert VB.Net to C# Pin
ZurdoDev6-Aug-19 10:03
professionalZurdoDev6-Aug-19 10:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.