Private Sub verifyControl_OnComplete(ByVal Control As Object, ByVal FeatureSet As DPFP.FeatureSet, ByRef EventHandlerStatus As DPFP.Gui.EventHandlerStatus) Handles verifyControl.OnComplete Try cn.Open() sqlCommand.CommandText = "Select * from student" sqlCommand.CommandType = CommandType.Text sqlCommand.Connection = cn Dim lrd As MySqlDataReader = sqlCommand.ExecuteReader() While lrd.Read() usr = lrd("print") End While lrd.Dispose() bytes = Nothing bytes = usr template = New DPFP.Template() template.DeSerialize(usr) 'Perform match matcher.Verify(FeatureSet, template, matchResult) If matchResult.Verified Then EventHandlerStatus = Gui.EventHandlerStatus.Success MessageBox.Show("Verified!, Fingerprint exist in database") I suspect the fault to be from this block sqlCommand.CommandText = " select StudentID from student where print like '%template%' " Dim publictable As New DataTable Try adapter.SelectCommand = sqlCommand adapter.Fill(publictable) txtstudentID.Text = publictable.Rows(0).Item(1) Finally adapter.Dispose() cn.Close() End Try
ExecuteNonQuery
Select * from student where id = InsertResult
InsertResult
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)