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(RFIDStudent_NameRollNoClassSection) 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 ; } } } }