資源簡介
將指紋信息存入數據庫中,這里主要講解的是SqlServer數據庫

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?System.Runtime.InteropServices;
namespace?將指紋數據存入數據庫中
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????bool?isConnected=false;//判斷是否已經連接
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????if?(axZKFPEngX1.InitEngine()?==?0)//初始化指紋儀
????????????{
????????????????toolStripStatusLabel1.Text=?“指紋儀連接成功“;//顯示指紋儀連接成功
????????????????this.Text?=“注冊碼:“+?axZKFPEngX1.SensorSN;//獲取指紋儀的注冊碼
????????????????isConnected?=?true;//標識,指紋儀連接成功
????????????}
????????????else
????????????{
????????????????toolStripStatusLabel1.Text?=?“指紋儀連接失敗“;//顯示指紋儀連接失敗
????????????????isConnected?=?false;//標識,指紋儀連接失敗
????????????}
????????}
????????private?void?timer1_Tick(object?sender?EventArgs?e)
????????{
????????????label2.Text?=?DateTime.Now.ToString();
????????}
????????private?void?Form1_Load(object?sender?EventArgs?e)
????????{
????????????label2.Text?=?DateTime.Now.ToString();
????????}
????????private?void?axZKFPEngX1_OnCapture(object?sender?AxZKFPEngXControl.IZKFPEngXEvents_OnCaptureEvent?e)
????????{
????????????if?(isConnected)
????????????{
????????????????if?(e.actionResult)//如果成功取到指紋模板
????????????????{
????????????????????string?dtt?=?““;
????????????????????Graphics?g?=?panel1.CreateGraphics();//獲取panel1控件的Graphics類
????????????????????string?tp?=?““;//記錄是對比成功還是對比失敗
????????????????????string?Ntemp?=?axZKFPEngX1.GetTemplateAsString();//獲取當前指紋圖片的字符串
????????????????????SqlConnection?conn?=?new?SqlConnection(“server=.;database=db_Finger;uid=sa;pwd=“);//設置要連接數據庫
????????????????????conn.Open();//連接數據庫
?????????????????????dtt?=?DateTime.Now.ToString();
?????????????????????//向數據表中插入當有員工的信息
?????????????????????SqlCommand?cmd1?=?new?SqlCommand(“insert?into?tb_finger(Ufingerdt)?values(‘“?+?Ntemp?+?“‘‘“?+?dtt?+?“‘)“?conn);
?????????????????????int?i?=?cmd1.ExecuteNonQuery();//獲取SQL影響的行數
?????????????????????if?(i?>?0)//插入成功
?????????????????????{
?????????????????????????tp?=?“指紋錄入成功!“;
?????????????????????}
????????????????????conn.Close();//斷開數據庫的連接
????????????????????toolStripStatusLabel1.Text?=?tp;
????????????????????richTextBox1.Clear();
????????????????????richTextBox1.AppendText(tp);
????????????????????richTextBox1.AppendText(“指紋模板:“?+?Ntemp);
????????????????????richTextBox1.AppendText(“考勤日期:“?+?dtt);
????????????????????//在panel1控件的指定位置顯示是否考勤成功
????????????????????g.DrawString(tp?new?Font(“黑體“20?Fontstyle.Bold)?new?SolidBrush(Color.Red)?new?PointF(18?120));
????????????????}
????????????}
????????}
????????[DllImport(“kernel32“)]
????????public?static?extern?int?Beep(int?dwFreg?int?dwDuration);
????????private?void?axZKFPEngX1_OnImage
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????3928??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Form1.cs
?????文件???????7126??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Form1.designer.cs
?????文件???????6877??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Form1.resx
?????文件????????514??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Program.cs
?????文件???????1398??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Properties\AssemblyInfo.cs
?????文件???????2916??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Properties\Resources.Designer.cs
?????文件???????5612??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Properties\Resources.resx
?????文件???????1118??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Properties\Settings.Designer.cs
?????文件????????249??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\Properties\Settings.settings
?????文件???????4709??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\將指紋數據存入數據庫中.csproj
?????文件????????955??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\將指紋數據存入數據庫中.sln
????..A..H.?????16384??2012-11-13?08:21??將指紋數據存入數據庫中\Backup\將指紋數據存入數據庫中.suo
?????文件??????13312??2012-11-27?22:11??將指紋數據存入數據庫中\bin\Debug\將指紋數據存入數據庫中.exe
?????文件??????40448??2012-11-27?22:11??將指紋數據存入數據庫中\bin\Debug\將指紋數據存入數據庫中.pdb
?????文件??????11608??2012-11-27?22:11??將指紋數據存入數據庫中\bin\Debug\將指紋數據存入數據庫中.vshost.exe
?????文件????????490??2010-03-17?22:39??將指紋數據存入數據庫中\bin\Debug\將指紋數據存入數據庫中.vshost.exe.manifest
?????文件????1048576??2012-11-13?08:21??將指紋數據存入數據庫中\databa
?????文件????1048576??2012-11-13?08:21??將指紋數據存入數據庫中\databa
?????文件???????3928??2012-11-13?08:21??將指紋數據存入數據庫中\Form1.cs
?????文件???????7126??2012-11-13?08:21??將指紋數據存入數據庫中\Form1.designer.cs
?????文件???????6877??2012-11-13?08:21??將指紋數據存入數據庫中\Form1.resx
?????文件???????7506??2012-11-13?08:21??將指紋數據存入數據庫中\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????6238??2012-11-27?22:11??將指紋數據存入數據庫中\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????892??2012-11-27?22:11??將指紋數據存入數據庫中\obj\Debug\GenerateResource-ResGen.read.1.tlog
?????文件????????810??2012-11-27?22:11??將指紋數據存入數據庫中\obj\Debug\GenerateResource-ResGen.write.1.tlog
?????文件??????12885??2012-11-27?22:11??將指紋數據存入數據庫中\obj\Debug\ResolveAssemblyReference.cache
?????文件???????5059??2012-11-27?22:11??將指紋數據存入數據庫中\obj\Debug\將指紋數據存入數據庫中.csproj.FileListAbsolute.txt
?????文件????????847??2012-11-13?08:21??將指紋數據存入數據庫中\obj\Debug\將指紋數據存入數據庫中.csproj.GenerateResource.Cache
?????文件????????689??2012-11-25?21:12??將指紋數據存入數據庫中\obj\Debug\將指紋數據存入數據庫中.csproj.ResolveComReference.cache
?????文件??????13312??2012-11-27?22:11??將指紋數據存入數據庫中\obj\Debug\將指紋數據存入數據庫中.exe
............此處省略124個文件信息
評論
共有 條評論