how to get rfid value and store the database in asp.net

Question

any one help me, how to get & add rfid value into database

Taimoor Sultan · Answer

Form1.designer.cs Code: namespace AMS { partial class Form1 { ///

/// Required designer variable. ///

private System.ComponentModel.IContainer components = null ; ///

/// Clean up any resources being used. ///

/// true if managed resources should be disposed; otherwise, false. protected override void Dispose( bool disposing) { if (disposing && (components != null )) { components.Dispose(); } base .Dispose(disposing); } #region Windows Form Designer generated code ///

/// Required method for Designer support - do not modify /// the contents of this method with the code editor. ///

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(); // // txttag // 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; // // label1 // 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" ; // // label2 // 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" ; // // label3 // 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" ; // // label4 // 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" ; // // label5 // 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" ; // // txtstudname // 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; // // txtrollno // 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; // // comboclass // 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; // // combosec // 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; // // btnsubmit // 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); // // btncancel // 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 ; // // Form1 // 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; } } 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 ; } } } }

how to get rfid value and store the database in asp.net

Answers (1)