how to develop clockin system using fingerprint

Question

i want to develop a clockin/out system i have staff table but with staff_id,staff_code,staff_names,image i want now to add fingerprint and i dont know which data type to use ,any one with idea help plis,using vb.net and sql

Ananth G · Answer

try this code 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 = "" ; }