How to Finger Print Store and Retrive (SQL)

Question

Laxmidhar Sahoo · Answer

actualy the figurprint is stored in byte[] array bellow is theexample private void SaveButton_Click( object sender, EventArgs e) { MemoryStream fingerprintData = new MemoryStream(); Template.Serialize(fingerprintData); fingerprintData.Position = 0; BinaryReader br = new BinaryReader(fingerprintData); Byte[] bytes = br.ReadBytes((Int32)fingerprintData.Length); //Insert the file into database SqlConnection cn = new SqlConnection( "Data Source=10.115.5.3; Initial Catalog=EnrollmentSampledb;Integrated Security=SSPI;" ); SqlCommand cmd = new SqlCommand( "INSERT INTO tblUser VALUES(@ID_NUMBER, @FIRSTNAME, @LASTNAME, @FINGERPRINT, @DATE_ADDED, @DATE_MODIFIED)" , cn); cmd.Parameters.Add( "ID_NUMBER" , SqlDbType.NVarChar).Value = tboxIdNum.Text; cmd.Parameters.Add( "FIRSTNAME" , SqlDbType.NVarChar).Value = tboxFname.Text; cmd.Parameters.Add( "LASTNAME" , SqlDbType.NVarChar).Value = tboxLname.Text; cmd.Parameters.Add( "FINGERPRINT" , SqlDbType.Image).Value = bytes; cmd.Parameters.Add( "DATE_ADDED" , SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add( "DATE_MODIFIED" , SqlDbType.DateTime).Value = DateTime.Now; cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); tboxIdNum.Text = "" ; tboxFname.Text = "" ; tboxLname.Text = "" ; }

Madan Shekar · Answer

Fingerprints are usually encoded into special files, called fingerprint templates, in order to be stored into a database. Raw fingerprint images should not be stored for a number of drawbacks [1] - A fingerprint image takes about 250 KB of space, whereas a template takes about 500 bytes. Storing raw fingerprint images is unsafe since it may lead to information leak once compromised. Different algorithms may generate different templates for the same fingerprint, hence you must use the same algorithm when comparing fingerprints. Now, when it comes to choosing the best datatype for storing the file You can store this as normal Varchar. If it helps pls accept the answer

How to Finger Print Store and Retrive (SQL)

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)