Title: insertFingerPrint                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
using System;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Drawing;
using System.Globalization;
using System.Windows.Forms;
namespace TestGate
{
    public class Form1 : Form
    {
        private IContainer components = null;
        private Button btn_Save;
        private Label label1;
        private Label label2;
        private Label label3;
        private RadioButton radio_In;
        private RadioButton radio_Out;
        private ComboBox combo_ID;
        private ComboBox combo_Fname;
        private ComboBox combo_LName;
        private Label label4;
        private DateTimePicker DTP_Time;
        protected override void Dispose(bool disposing)
        {
            if (disposing && this.components != null)
            {
                this.components.Dispose();
            }
            base.Dispose(disposing);
        }
        private void InitializeComponent()
        {
            this.btn_Save = new Button();
            this.label1 = new Label();
            this.label2 = new Label();
            this.label3 = new Label();
            this.radio_In = new RadioButton();
            this.radio_Out = new RadioButton();
            this.combo_ID = new ComboBox();
            this.combo_Fname = new ComboBox();
            this.combo_LName = new ComboBox();
            this.label4 = new Label();
            this.DTP_Time = new DateTimePicker();
            base.SuspendLayout();
            this.btn_Save.Location = new Point(88, 168);
            this.btn_Save.Name = "btn_Save";
            this.btn_Save.Size = new Size(100, 23);
            this.btn_Save.TabIndex = 0;
            this.btn_Save.Text = "Save";
            this.btn_Save.UseVisualStyleBackColor = true;
            this.btn_Save.Click += new EventHandler(this.btn_Save_Click);
            this.label1.AutoSize = true;
            this.label1.Location = new Point(31, 25);
            this.label1.Name = "label1";
            this.label1.Size = new Size(40, 13);
            this.label1.TabIndex = 1;
            this.label1.Text = "UserID";
            this.label2.AutoSize = true;
            this.label2.Location = new Point(31, 52);
            this.label2.Name = "label2";
            this.label2.Size = new Size(58, 13);
            this.label2.TabIndex = 1;
            this.label2.Text = "First Name";
            this.label3.AutoSize = true;
            this.label3.Location = new Point(31, 79);
            this.label3.Name = "label3";
            this.label3.Size = new Size(57, 13);
            this.label3.TabIndex = 1;
            this.label3.Text = "Last Name";
            this.radio_In.AutoSize = true;
            this.radio_In.Checked = true;
            this.radio_In.Location = new Point(99, 136);
            this.radio_In.Name = "radio_In";
            this.radio_In.Size = new Size(36, 17);
            this.radio_In.TabIndex = 3;
            this.radio_In.TabStop = true;
            this.radio_In.Text = "IN";
            this.radio_In.UseVisualStyleBackColor = true;
            this.radio_Out.AutoSize = true;
            this.radio_Out.Location = new Point(163, 136);
            this.radio_Out.Name = "radio_Out";
            this.radio_Out.Size = new Size(43, 17);
            this.radio_Out.TabIndex = 3;
            this.radio_Out.Text = "Out";
            this.radio_Out.UseVisualStyleBackColor = true;
            this.combo_ID.FormattingEnabled = true;
            this.combo_ID.Items.AddRange(new object[]
            {
                "9001",
                "9004",
                "1006"
            });
            this.combo_ID.Location = new Point(96, 17);
            this.combo_ID.Name = "combo_ID";
            this.combo_ID.Size = new Size(124, 21);
            this.combo_ID.TabIndex = 4;
            this.combo_Fname.FormattingEnabled = true;
            this.combo_Fname.Items.AddRange(new object[]
            {
                "محمد",
                "طاهر",
                "عبدالسلام"
            });
            this.combo_Fname.Location = new Point(96, 49);
            this.combo_Fname.Name = "combo_Fname";
            this.combo_Fname.Size = new Size(124, 21);
            this.combo_Fname.TabIndex = 4;
            this.combo_LName.FormattingEnabled = true;
            this.combo_LName.Items.AddRange(new object[]
            {
                "الخولي",
                "جبر",
                "حمشو"
            });
            this.combo_LName.Location = new Point(96, 76);
            this.combo_LName.Name = "combo_LName";
            this.combo_LName.Size = new Size(124, 21);
            this.combo_LName.TabIndex = 4;
            this.label4.AutoSize = true;
            this.label4.Location = new Point(32, 104);
            this.label4.Name = "label4";
            this.label4.Size = new Size(57, 13);
            this.label4.TabIndex = 1;
            this.label4.Text = "Last Name";
            this.DTP_Time.CustomFormat = "HH:mm:ss.fff";
            this.DTP_Time.Format = DateTimePickerFormat.Time;
            this.DTP_Time.Location = new Point(96, 103);
            this.DTP_Time.Name = "DTP_Time";
            this.DTP_Time.Size = new Size(124, 20);
            this.DTP_Time.TabIndex = 5;
            base.AutoScaleDimensions = new SizeF(6f, 13f);
            base.AutoScaleMode = AutoScaleMode.Font;
            base.ClientSize = new Size(274, 213);
            base.Controls.Add(this.DTP_Time);
            base.Controls.Add(this.combo_LName);
            base.Controls.Add(this.combo_Fname);
            base.Controls.Add(this.combo_ID);
            base.Controls.Add(this.radio_Out);
            base.Controls.Add(this.radio_In);
            base.Controls.Add(this.label4);
            base.Controls.Add(this.label3);
            base.Controls.Add(this.label2);
            base.Controls.Add(this.label1);
            base.Controls.Add(this.btn_Save);
            base.Name = "Form1";
            base.Load += new EventHandler(this.Form1_Load);
            base.ResumeLayout(false);
            base.PerformLayout();
        }
        public Form1()
        {
            this.InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
        }
        private void btn_Save_Click(object sender, EventArgs e)
        {
            SqlConnection sqlConnection = new SqlConnection("Server=192.168.0.206;Database=TBS_BAWSE;User ID=sa;Password=Aa123123");
            string text;
            if (this.radio_In.Checked)
            {
                text = "100";
            }
            else
            {
                text = "200";
            }
            CultureInfo provider = new CultureInfo("en-US");
            string text2 = DateTime.Now.ToString("yyyy-MM-dd", provider).ToString() + " " + this.DTP_Time.Value.ToString("HH:mm:ss.fff").ToString();
            SqlCommand sqlCommand = new SqlCommand(string.Concat(new string[]
            {
                "insert into TBST_TARecords(TA_Timestamp,TA_ZoneID,TA_AccessPointID,TA_AuthenticationResult,TA_AuthorizationResult,TA_UserID,TA_UserFirstName,TA_UserLastName,TA_IDContext,TA_IDFactor,TA_LocalTimestamp,TA_Info,Transferred) values(`",
                text2,
                "`,`computer`,`5901B15200161600`,100,100,`",
                this.combo_ID.Text,
                "`,`",
                this.combo_Fname.Text,
                "`,`",
                this.combo_LName.Text,
                "`,`",
                text,
                "`,`3`,`",
                text2,
                "`,`NULL`,0)"
            }));
            sqlCommand.Connection = sqlConnection;
            sqlConnection.Open();
            sqlCommand.ExecuteNonQuery();
            sqlConnection.Close();
            MessageBox.Show("Successfully");
        }
    }
}