Click here to Skip to main content
15,903,362 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi All,

•Capture person thumb impression from device(finger print scanner device Device name : "digital Persona U are U 4500 )and move into our database.
•Once the same person gives his thumb impression for second time, details of that person should be retrieved from the database to the form.

How to save finger print image in sql 2008 R2. How to do this? Can any one please guide me!


Thanks in Advance!
Posted
Updated 6-Oct-17 0:39am
v2

Fingerprint data would be a binary data so you would use BLOBs.
Read this : Store and retrieve objects as BLOBs in SQL Server 2000 and 2005 using ASP.NET 2.0[^]
 
Share this answer
 
Comments
Abhinav S 28-May-12 1:39am    
That is correct. 5.
Mehdi Gholam 28-May-12 1:43am    
Thanks Abhinav!
if it is image than you can save this image in sql server to in varbinary field. i give you one link of how to save image in sql server

Reading and Writing pdf,images,.doc files Data to Microsoft SQL or Oracle Database[^]

i think it will solve your problem.
 
Share this answer
 
v2
Comments
Jolan Chris Bagalayos 6-Oct-17 6:47am    
Can anyone here review my code because it is not working
Dim conn As SqlConnection = MainForm.con()
Dim cmd As New SqlCommand()
cmd.Connection = MainForm.con()
cmd.CommandText = "select * from fprintt"
Dim rdr As SqlDataReader = cmd.ExecuteReader()
Dim MemStream As IO.MemoryStream
Dim fpBytes As Byte()
Dim templa8 As DPFP.Template = New DPFP.Template()
Dim FPList As List(Of AppData) = New List(Of AppData)
Dim tmpObj As New AppData
Dim VerifiedFPData = New AppData
Dim ver As New DPFP.Verification.Verification()
Dim res As New DPFP.Verification.Verification.Result()
Dim compareTo As New DPFP.FeatureSet
Dim tmplateData As New DPFP.Template
Dim fingerprintData As MemoryStream = New MemoryStream
Dim brr As BinaryReader = New BinaryReader(fingerprintData)
Dim bytes() As Byte = brr.ReadBytes(CType(fingerprintData.Length, Int32))
While rdr.Read()
fpBytes = rdr("Finger")
MemStream = New IO.MemoryStream(fpBytes)
templa8.DeSerialize(MemStream)
End While
FPList.Add(tmpObj)
Dim printFound As Boolean = False
Try
For Each FPData As AppData In FPList
Template = templa8
compareTo = FeatureSet()
If Not tmplateData Is Nothing Then
ver.Verify(FeatureSet, tmplateData, res)
If res.Verified Then
'EventHandlerStatus = DPFP.Gui.EventHandlerStatus.Success
printFound = True
Template = templa8
Exit For ' success
End If
End If
Next
Catch ex As Exception
MessageBox.Show("verification error")
End Try
Jolan Chris Bagalayos 6-Oct-17 6:47am    
that is my code on retrieving part. thanks in advance
AnvilRanger 6-Oct-17 14:49pm    
If you have question create a new post and ask it there. Receiving an 5 year old question with unrelated content is not a good thing to do and can be seen as spam.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900