Here am shows how to read RFID data and store information in to database
Form1.designer.cs
Code:
- namespace AMS
- {
- partial class Form1
- {
-
-
-
- private System.ComponentModel.IContainer components = null;
-
-
-
-
-
- protected override void Dispose(bool disposing)
- {
- if (disposing && (components != null))
- {
- components.Dispose();
- }
- base.Dispose(disposing);
- }
-
- #region Windows Form Designer generated code
-
-
-
-
-
- private void InitializeComponent()
- {
- this.txttag = new System.Windows.Forms.TextBox();
- this.label1 = new System.Windows.Forms.Label();
- this.label2 = new System.Windows.Forms.Label();
- this.label3 = new System.Windows.Forms.Label();
- this.label4 = new System.Windows.Forms.Label();
- this.label5 = new System.Windows.Forms.Label();
- this.txtstudname = new System.Windows.Forms.TextBox();
- this.txtrollno = new System.Windows.Forms.TextBox();
- this.comboclass = new System.Windows.Forms.ComboBox();
- this.combosec = new System.Windows.Forms.ComboBox();
- this.btnsubmit = new System.Windows.Forms.Button();
- this.btncancel = new System.Windows.Forms.Button();
- this.SuspendLayout();
-
-
-
- this.txttag.Location = new System.Drawing.Point(138, 50);
- this.txttag.Name = "txttag";
- this.txttag.Size = new System.Drawing.Size(100, 20);
- this.txttag.TabIndex = 0;
-
-
-
- this.label1.AutoSize = true;
- this.label1.Location = new System.Drawing.Point(60, 50);
- this.label1.Name = "label1";
- this.label1.Size = new System.Drawing.Size(40, 13);
- this.label1.TabIndex = 1;
- this.label1.Text = "Tag ID";
-
-
-
- this.label2.AutoSize = true;
- this.label2.Location = new System.Drawing.Point(44, 78);
- this.label2.Name = "label2";
- this.label2.Size = new System.Drawing.Size(75, 13);
- this.label2.TabIndex = 2;
- this.label2.Text = "Student Name";
-
-
-
- this.label3.AutoSize = true;
- this.label3.Location = new System.Drawing.Point(60, 108);
- this.label3.Name = "label3";
- this.label3.Size = new System.Drawing.Size(42, 13);
- this.label3.TabIndex = 3;
- this.label3.Text = "Roll No";
-
-
-
- this.label4.AutoSize = true;
- this.label4.Location = new System.Drawing.Point(60, 135);
- this.label4.Name = "label4";
- this.label4.Size = new System.Drawing.Size(32, 13);
- this.label4.TabIndex = 4;
- this.label4.Text = "Class";
-
-
-
- this.label5.AutoSize = true;
- this.label5.Location = new System.Drawing.Point(57, 163);
- this.label5.Name = "label5";
- this.label5.Size = new System.Drawing.Size(43, 13);
- this.label5.TabIndex = 5;
- this.label5.Text = "Section";
-
-
-
- this.txtstudname.Location = new System.Drawing.Point(138, 78);
- this.txtstudname.Name = "txtstudname";
- this.txtstudname.Size = new System.Drawing.Size(100, 20);
- this.txtstudname.TabIndex = 6;
-
-
-
- this.txtrollno.Location = new System.Drawing.Point(138, 105);
- this.txtrollno.Name = "txtrollno";
- this.txtrollno.Size = new System.Drawing.Size(100, 20);
- this.txtrollno.TabIndex = 7;
-
-
-
- this.comboclass.FormattingEnabled = true;
- this.comboclass.Items.AddRange(new object[] {
- "I",
- "II",
- "III",
- "IV",
- "V",
- "VI",
- "VII",
- "VIII",
- "IX",
- "X"});
- this.comboclass.Location = new System.Drawing.Point(138, 132);
- this.comboclass.Name = "comboclass";
- this.comboclass.Size = new System.Drawing.Size(121, 21);
- this.comboclass.TabIndex = 8;
-
-
-
- this.combosec.FormattingEnabled = true;
- this.combosec.Items.AddRange(new object[] {
- "A",
- "B",
- "C",
- "D",
- "E",
- "F",
- "G",
- "H"});
- this.combosec.Location = new System.Drawing.Point(138, 160);
- this.combosec.Name = "combosec";
- this.combosec.Size = new System.Drawing.Size(121, 21);
- this.combosec.TabIndex = 9;
-
-
-
- this.btnsubmit.Location = new System.Drawing.Point(105, 202);
- this.btnsubmit.Name = "btnsubmit";
- this.btnsubmit.Size = new System.Drawing.Size(75, 23);
- this.btnsubmit.TabIndex = 10;
- this.btnsubmit.Text = "Submit";
- this.btnsubmit.UseVisualStyleBackColor = true;
- this.btnsubmit.Click += new System.EventHandler(this.btnsubmit_Click);
-
-
-
- this.btncancel.Location = new System.Drawing.Point(197, 202);
- this.btncancel.Name = "btncancel";
- this.btncancel.Size = new System.Drawing.Size(75, 23);
- this.btncancel.TabIndex = 11;
- this.btncancel.Text = "Cancel";
- this.btncancel.UseVisualStyleBackColor = true;
-
-
-
- this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
- this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
- this.ClientSize = new System.Drawing.Size(290, 261);
- this.Controls.Add(this.btncancel);
- this.Controls.Add(this.btnsubmit);
- this.Controls.Add(this.combosec);
- this.Controls.Add(this.comboclass);
- this.Controls.Add(this.txtrollno);
- this.Controls.Add(this.txtstudname);
- this.Controls.Add(this.label5);
- this.Controls.Add(this.label4);
- this.Controls.Add(this.label3);
- this.Controls.Add(this.label2);
- this.Controls.Add(this.label1);
- this.Controls.Add(this.txttag);
- this.Name = "Form1";
- this.Text = "Form1";
- this.Load += new System.EventHandler(this.Form1_Load);
- this.ResumeLayout(false);
- this.PerformLayout();
-
- }
-
- #endregion
-
- private System.Windows.Forms.TextBox txttag;
- private System.Windows.Forms.Label label1;
- private System.Windows.Forms.Label label2;
- private System.Windows.Forms.Label label3;
- private System.Windows.Forms.Label label4;
- private System.Windows.Forms.Label label5;
- private System.Windows.Forms.TextBox txtstudname;
- private System.Windows.Forms.TextBox txtrollno;
- private System.Windows.Forms.ComboBox comboclass;
- private System.Windows.Forms.ComboBox combosec;
- private System.Windows.Forms.Button btnsubmit;
- private System.Windows.Forms.Button btncancel;
- }
- }
Screen Design:
Form1.cs
Code:
Adding namespaces for serial port connection.
- using System.IO.Ports;
- using System.Threading;
- using System.Data.Sql;
- using System.Data.SqlClient;
Full Code:
- using System.IO.Ports;
- using System.Threading;
- using System.Data.Sql;
- using System.Data.SqlClient;
-
- Full Code:
- 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.IO.Ports;
- using System.Threading;
- using System.Data.Sql;
- using System.Data.SqlClient;
- namespace AMS
- {
- public partial class Form1 : Form
- {
- string str = "Data Source=.;Initial Catalog=AMS;Integrated Security=True";
- private SerialPort RFID;
- private string DispString;
- public Form1()
- {
- InitializeComponent();
- }
-
- private void Form1_Load(object sender, EventArgs e)
- {
-
- RFID = new SerialPort();
- RFID.PortName = "COM5";
- RFID.BaudRate = 9600;
- RFID.DataBits = 8;
- RFID.Parity = Parity.None;
- RFID.StopBits = StopBits.One;
- RFID.Open();
- RFID.ReadTimeout = 200;
- if (RFID.IsOpen)
- {
- DispString = "";
- txttag.Text = "";
- }
- else
- {
- RFID.Close();
- }
- RFID.DataReceived += new SerialDataReceivedEventHandler(RFID_DataReceived);
-
- }
-
- private void button1_Click(object sender, EventArgs e)
- {
-
- }
- private void RFID_DataReceived(object sender, SerialDataReceivedEventArgs e)
- {
-
- if (txttag.Text.Length >= 12)
- {
- RFID.Close();
-
- }
- else
- {
- DispString = RFID.ReadExisting();
- this.Invoke(new EventHandler(DisplayText));
- }
-
- }
- private void DisplayText(object sender, EventArgs e)
- {
- txttag.AppendText(DispString);
- }
-
- private void btnsubmit_Click(object sender, EventArgs e)
- {
- switch (btnsubmit.Text)
- {
- case "Submit":
- if (txttag.Text.Length == 0 || txtrollno.Text.Length == 0 || txtstudname.Text.Length == 0)
- { return; }
- if (!CheckDuplicateRFID())
- {
- MessageBox.Show("Already Saved");
- txttag.Text = "";
- return;
- }
- break;
- }
- SqlConnection con = new SqlConnection(str);
- con.Open();
- SqlCommand cmd = new SqlCommand("insert into tbl_Studentdet(RFID,Student_Name,RollNo,Class,Section) values (@RFID,@Student_Name,@RollNo,@Class,@Section)", con);
- cmd.Parameters.AddWithValue("@RFID", txttag.Text);
- cmd.Parameters.AddWithValue("@Student_Name", txtstudname.Text);
- cmd.Parameters.AddWithValue("@RollNo", txtrollno.Text);
- cmd.Parameters.AddWithValue("@Section", combosec.SelectedItem.ToString());
- cmd.Parameters.AddWithValue("@Class", comboclass.SelectedItem.ToString());
- cmd.ExecuteNonQuery();
- MessageBox.Show("Student added");
- con.Close();
- }
- private bool CheckDuplicateRFID()
- {
- SqlConnection con = new SqlConnection(str);
- con.Open();
- SqlCommand cmd = new SqlCommand("select * from tbl_Studentdet where RFID='" + txttag.Text + "'", con);
- SqlDataReader rd = cmd.ExecuteReader();
- if (rd.HasRows)
- {
- rd.Close();
- return false;
- }
- else
- {
- rd.Close();
- return true;
- }
- }
-
-
- }
- }
Output(While showing the card In to the RFID reader).