01.using System;
02.using System.Collections.Generic;
03.using System.ComponentModel;
04.using System.Data;
05.using System.Drawing;
06.using System.Linq;
07.using System.Text;
08.using System.Threading.Tasks;
09.using System.Windows.Forms;
10.using System.Data.OleDb;
11.
12.namespace EquipmentManagement
13.{
14. public partial class EquipmentManagement : Form
15. {
16. public EquipmentManagement()
17. {
18. InitializeComponent();
19. }
20. OleDbCommand CM = new OleDbCommand();
21. OleDbDataAdapter AP = new OleDbDataAdapter();
22. DataTable DTshow = new DataTable();
23. OleDbCommandBuilder CB = new OleDbCommandBuilder();
24. OleDbConnection CN = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\\Project\\Visual Studio\\ระบบยืมคืน\\ระบบยืม-คืน.mdb");
25. private void Form1_Load(object sender, EventArgs e)
26. {
27. try
28. {
29. CN.Open();
30. Showdata();
31. }
32. catch
33. { MessageBox.Show("Error"); }
34. }
35. private void Showdata()
36. {
37. string sql = "select * from Equipment";
38. OleDbCommand CM = new OleDbCommand(sql, CN);
39. OleDbDataReader DR = CM.ExecuteReader();
40. DataTable Dt = new DataTable();
41. if (DR.HasRows)
42. {
43. Dt.Load(DR);
44. dataGridView1.DataSource = Dt;
45. dataGridView1.Columns[0].Width = 85;
46. dataGridView1.Columns[1].Width = 85;
47. dataGridView1.Columns[2].Width = 85;
48. dataGridView1.Columns[3].Width = 85;
49. dataGridView1.Columns[4].Width = 85;
50. }
51. else
52. {
53. dataGridView1.DataSource = null;
54. }
55. DR.Close();
56.
57. }
58.
59. private void Addequipment_Click(object sender, EventArgs e)
60. {
61. string sql = "Insert Into Equipment (@BarcodeID(E),@E_ID,@E_name,@E_group,@E_quantity)Values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
62. OleDbCommand CM = new OleDbCommand(sql, CN);
63. CM.ExecuteNonQuery();
64. MessageBox.Show("บันทึกเรียบร้อย", "Equipment", MessageBoxButtons.OK, MessageBoxIcon.Information);
65. Showdata();
66. Cleardata();
67. }
68. private void Cleardata()
69. {
70. textBox1.Clear();
71. textBox2.Clear();
72. textBox3.Clear();
73. textBox4.Clear();
74. textBox5.Clear();
75. }
76. }
77.}
Code (C#)
