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

Form1.designer.cs

Code:
namespace AMS
{
partial class Form1
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
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;
}
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Taimoor Sultan10y ago
1. Form1.designer.cs
  
  Code:
3. namespace AMS
4. {
5. partial class Form1
6. {
7. /// <summary>
8. /// Required designer variable.
9. /// </summary>
10. private System.ComponentModel.IContainer components = null;
12. /// <summary>
13. /// Clean up any resources being used.
14. /// </summary>
15. /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
16. protected override void Dispose(bool disposing)
17. {
18. if (disposing && (components != null))
19. {
20. components.Dispose();
21. }
22. base.Dispose(disposing);
23. }
25. #region Windows Form Designer generated code
27. /// <summary>
28. /// Required method for Designer support - do not modify
29. /// the contents of this method with the code editor.
30. /// </summary>
31. private void InitializeComponent()
32. {
33. this.txttag = new System.Windows.Forms.TextBox();
34. this.label1 = new System.Windows.Forms.Label();
35. this.label2 = new System.Windows.Forms.Label();
36. this.label3 = new System.Windows.Forms.Label();
37. this.label4 = new System.Windows.Forms.Label();
38. this.label5 = new System.Windows.Forms.Label();
39. this.txtstudname = new System.Windows.Forms.TextBox();
40. this.txtrollno = new System.Windows.Forms.TextBox();
41. this.comboclass = new System.Windows.Forms.ComboBox();
42. this.combosec = new System.Windows.Forms.ComboBox();
43. this.btnsubmit = new System.Windows.Forms.Button();
44. this.btncancel = new System.Windows.Forms.Button();
45. this.SuspendLayout();
46. //
47. // txttag
48. //
49. this.txttag.Location = new System.Drawing.Point(138, 50);
50. this.txttag.Name = "txttag";
51. this.txttag.Size = new System.Drawing.Size(100, 20);
52. this.txttag.TabIndex = 0;
53. //
54. // label1
55. //
56. this.label1.AutoSize = true;
57. this.label1.Location = new System.Drawing.Point(60, 50);
58. this.label1.Name = "label1";
59. this.label1.Size = new System.Drawing.Size(40, 13);
60. this.label1.TabIndex = 1;
61. this.label1.Text = "Tag ID";
62. //
63. // label2
64. //
65. this.label2.AutoSize = true;
66. this.label2.Location = new System.Drawing.Point(44, 78);
67. this.label2.Name = "label2";
68. this.label2.Size = new System.Drawing.Size(75, 13);
69. this.label2.TabIndex = 2;
70. this.label2.Text = "Student Name";
71. //
72. // label3
73. //
74. this.label3.AutoSize = true;
75. this.label3.Location = new System.Drawing.Point(60, 108);
76. this.label3.Name = "label3";
77. this.label3.Size = new System.Drawing.Size(42, 13);
78. this.label3.TabIndex = 3;
79. this.label3.Text = "Roll No";
80. //
81. // label4
82. //
83. this.label4.AutoSize = true;
84. this.label4.Location = new System.Drawing.Point(60, 135);
85. this.label4.Name = "label4";
86. this.label4.Size = new System.Drawing.Size(32, 13);
87. this.label4.TabIndex = 4;
88. this.label4.Text = "Class";
89. //
90. // label5
91. //
92. this.label5.AutoSize = true;
93. this.label5.Location = new System.Drawing.Point(57, 163);
94. this.label5.Name = "label5";
95. this.label5.Size = new System.Drawing.Size(43, 13);
96. this.label5.TabIndex = 5;
97. this.label5.Text = "Section";
98. //
99. // txtstudname
100. //
101. this.txtstudname.Location = new System.Drawing.Point(138, 78);
102. this.txtstudname.Name = "txtstudname";
103. this.txtstudname.Size = new System.Drawing.Size(100, 20);
104. this.txtstudname.TabIndex = 6;
105. //
106. // txtrollno
107. //
108. this.txtrollno.Location = new System.Drawing.Point(138, 105);
109. this.txtrollno.Name = "txtrollno";
110. this.txtrollno.Size = new System.Drawing.Size(100, 20);
111. this.txtrollno.TabIndex = 7;
112. //
113. // comboclass
114. //
115. this.comboclass.FormattingEnabled = true;
116. this.comboclass.Items.AddRange(new object[] {
117. "I",
118. "II",
119. "III",
120. "IV",
121. "V",
122. "VI",
123. "VII",
124. "VIII",
125. "IX",
126. "X"});
127. this.comboclass.Location = new System.Drawing.Point(138, 132);
128. this.comboclass.Name = "comboclass";
129. this.comboclass.Size = new System.Drawing.Size(121, 21);
130. this.comboclass.TabIndex = 8;
131. //
132. // combosec
133. //
134. this.combosec.FormattingEnabled = true;
135. this.combosec.Items.AddRange(new object[] {
136. "A",
137. "B",
138. "C",
139. "D",
140. "E",
141. "F",
142. "G",
143. "H"});
144. this.combosec.Location = new System.Drawing.Point(138, 160);
145. this.combosec.Name = "combosec";
146. this.combosec.Size = new System.Drawing.Size(121, 21);
147. this.combosec.TabIndex = 9;
148. //
149. // btnsubmit
150. //
151. this.btnsubmit.Location = new System.Drawing.Point(105, 202);
152. this.btnsubmit.Name = "btnsubmit";
153. this.btnsubmit.Size = new System.Drawing.Size(75, 23);
154. this.btnsubmit.TabIndex = 10;
155. this.btnsubmit.Text = "Submit";
156. this.btnsubmit.UseVisualStyleBackColor = true;
157. this.btnsubmit.Click += new System.EventHandler(this.btnsubmit_Click);
158. //
159. // btncancel
160. //
161. this.btncancel.Location = new System.Drawing.Point(197, 202);
162. this.btncancel.Name = "btncancel";
163. this.btncancel.Size = new System.Drawing.Size(75, 23);
164. this.btncancel.TabIndex = 11;
165. this.btncancel.Text = "Cancel";
166. this.btncancel.UseVisualStyleBackColor = true;
167. //
168. // Form1
169. //
170. this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
171. this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
172. this.ClientSize = new System.Drawing.Size(290, 261);
173. this.Controls.Add(this.btncancel);
174. this.Controls.Add(this.btnsubmit);
175. this.Controls.Add(this.combosec);
176. this.Controls.Add(this.comboclass);
177. this.Controls.Add(this.txtrollno);
178. this.Controls.Add(this.txtstudname);
179. this.Controls.Add(this.label5);
180. this.Controls.Add(this.label4);
181. this.Controls.Add(this.label3);
182. this.Controls.Add(this.label2);
183. this.Controls.Add(this.label1);
184. this.Controls.Add(this.txttag);
185. this.Name = "Form1";
186. this.Text = "Form1";
187. this.Load += new System.EventHandler(this.Form1_Load);
188. this.ResumeLayout(false);
189. this.PerformLayout();
191. }
193. #endregion
195. private System.Windows.Forms.TextBox txttag;
196. private System.Windows.Forms.Label label1;
197. private System.Windows.Forms.Label label2;
198. private System.Windows.Forms.Label label3;
199. private System.Windows.Forms.Label label4;
200. private System.Windows.Forms.Label label5;
201. private System.Windows.Forms.TextBox txtstudname;
202. private System.Windows.Forms.TextBox txtrollno;
203. private System.Windows.Forms.ComboBox comboclass;
204. private System.Windows.Forms.ComboBox combosec;
205. private System.Windows.Forms.Button btnsubmit;
206. private System.Windows.Forms.Button btncancel;
207. }
208. }
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;
}
}

}
}