Form1
How do I use Form1
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
File name: Form1.cs
Copy
32 {
33 get
34 {
35 if (defaultInstance == null)
36 {
37 defaultInstance = new Form1();
38 defaultInstance.FormClosed += new FormClosedEventHandler(defaultInstance_FormClosed);
39 }
40
41 return defaultInstance;
42 }
43 }
File name: gradeclass.cs
Copy
68 public void RefreshDGV()
69 {
70
71 System.Data.OleDb.OleDbConnection conn = GetConnection();
72 string sql = default(string);
73 sql = "SELECT STUDENTID,data1 AS Firstname, data2 AS Lastname," + "data3 AS 20, data4 AS EG, data5 AS [1st-10%], data6 AS 50pt," + "data7 AS EG1, data8 AS [2nd-10%], data9 AS 50pts, data10 AS EG2," + "data11 AS [20%], data12 AS 100pt, data13 AS EG3, data14 AS [30%]," + "data15 AS 100, data16 AS EG4, data17 AS [2nd-30%], data18 AS PrelimGrade," + "data19 AS Remarks FROM Table1 ORDER BY ID";
74
75 System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
76 DataTable dt = new DataTable("grade1");
77 da.Fill(dt);
78 Form1.Default.DataGridView1.DataSource = dt;
79 }
File name: gradeclass.cs
Copy
80 public void clearall()
81 {
82 Form1.Default.TextBox1.Text = "";
83 Form1.Default.TextBox2.Text = "";
84 Form1.Default.TextBox3.Text = "";
85 Form1.Default.TextBox4.Text = "";
86 Form1.Default.TextBox5.Text = "";
87 Form1.Default.TextBox6.Text = "";
88 Form1.Default.TextBox7.Text = "";
89 Form1.Default.TextBox8.Text = "";
90 Form1.Default.TextBox9.Text = "";
91 Form1.Default.TextBox10.Text = "";
92 Form1.Default.TextBox11.Text = "";
93 Form1.Default.TextBox12.Text = "";
94 Form1.Default.TextBox13.Text = "";
95 Form1.Default.TextBox14.Text = "";
96 Form1.Default.TextBox15.Text = "";
97 Form1.Default.TextBox16.Text = "";
98 Form1.Default.TextBox17.Text = "";
99 Form1.Default.TextBox18.Text = "";
100 Form1.Default.TextBox19.Text = "";
101 Form1.Default.STUDID.Text = "";
102
103
104 }
File name: gradeclass.cs
Copy
110 public DataSet SaveItem(string sortfield)
111 {
112
113 System.Data.OleDb.OleDbConnection conn = GetConnection();
114
115 try
116 {
117
118 string SQL = default(string);
119
120 SQL = "INSERT INTO TABLE1 (STUDENTID, DATA1, DATA2, DATA3, DATA4, DATA5,DATA6, DATA7," + "DATA8, DATA9, DATA10, DATA11, DATA12, DATA13, DATA14, DATA15, DATA16, DATA17, DATA18," + "DATA19) VALUES(@STUDENTID, @DATA1, @DATA2, @DATA3, @DATA4, @DATA5,@DATA6, @DATA7,DATA8, @DATA9," + "@DATA10, @DATA11, @DATA12, @DATA13, @DATA14, @DATA15, @DATA16, @DATA17, @DATA18, @DATA19)";
121 System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(SQL, conn);
122 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
123 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
124 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
125 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
126 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
127 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
128 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
129 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
130 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
131 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
132 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
133 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
134 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
135 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
136 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
137 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
138 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
139 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
140 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
141 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
142
143 conn.Open();
144 cmd.ExecuteNonQuery();
145 conn.Close();
146 MessageBox.Show("New data is Added!");
147
148 Form1.Default.TextBox1.Text = "";
149 Form1.Default.TextBox2.Text = "";
150 Form1.Default.TextBox3.Text = "";
151 Form1.Default.TextBox4.Text = "";
152 Form1.Default.TextBox5.Text = "";
153 Form1.Default.TextBox6.Text = "";
154 Form1.Default.TextBox7.Text = "";
155 Form1.Default.TextBox8.Text = "";
156 Form1.Default.TextBox9.Text = "";
157 Form1.Default.TextBox10.Text = "";
158 Form1.Default.TextBox11.Text = "";
159 Form1.Default.TextBox12.Text = "";
160 Form1.Default.TextBox13.Text = "";
161 Form1.Default.TextBox14.Text = "";
162 Form1.Default.TextBox15.Text = "";
163 Form1.Default.TextBox16.Text = "";
164 Form1.Default.TextBox17.Text = "";
165 Form1.Default.TextBox18.Text = "";
166 Form1.Default.TextBox19.Text = "";
167 Form1.Default.STUDID.Text = "";
168
169 RefreshDGV();
170
171 }
172 finally
173 {
174 conn.Close();
175 conn.Dispose();
176 }
177
178 return default(DataSet);
179 }
File name: gradeclass.cs
Copy
225 public DataSet deldata(string sortfield)
226 {
227
228 System.Data.OleDb.OleDbConnection conn = GetConnection();
229 DataSet ds = new DataSet();
230
231 try
232 {
233
234 int inc;
235 int MaxRows;
236
237 //Dim sql As String = "select * from table1"
238 //Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(sql, conn)
239
240 try
241 {
242
243 string sqldelete = default(string);
244 sqldelete = "DELETE * FROM table1 WHERE STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
245 System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqldelete, conn);
246
247 // Gets the records from the table and fills our adapter with those.
248 DataTable dt = new DataTable("grade1");
249 da.Fill(dt);
250 MessageBox.Show("Data has been deleted");
251 clearall();
252
253 Form1.Default.DataGridView1.DataSource = dt;
254
255 RefreshDGV();
256
257 }
258 finally
259 {
260 //da.Dispose()
261 }
262
263 return ds;
264 }
265 finally
266 {
267 conn.Close();
268 conn.Dispose();
269 }
270 }
File name: gradeclass.cs
Copy
276 public DataSet updtedata(string sortfield)
277 {
278
279 System.Data.OleDb.OleDbConnection conn = GetConnection();
280 DataSet ds = new DataSet();
281
282 try
283 {
284
285 string sqlupdate = default(string);
286
287 sqlupdate = "UPDATE Table1 set STUDENTID=@STUDENTID, data1=@data1, data2=@data2, data3=@data3, data4=@data4," + "data5=@data5, data6=@data6, data7=@data7, data8=@data8, data9=@data9, data10=@data10," + "data11=@data11, data12=@data12, data13=@data13, data14=@data14, data15=@data15, data16=@data16," + "data17=@data17, data18=@data18, data19=@data19 where STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
288 System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sqlupdate, conn);
289
290 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
291 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
292 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
293 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
294 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
295 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
296 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
297 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
298 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
299 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
300 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
301 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
302 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
303 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
304 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
305 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
306 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
307 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
308 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
309 cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
310
311 conn.Open();
312 cmd.ExecuteNonQuery();
313 conn.Close();
314 MessageBox.Show("Data Updated in the Database");
315 RefreshDGV();
316
317 }
318 finally
319 {
320 }
321 return ds;
322 }
File name: Program.cs
Copy
14 static void Main()
15 {
16 Application.EnableVisualStyles();
17 Application.SetCompatibleTextRenderingDefault(false);
18 Application.Run(new Form1());
19 }
File name: Program.cs
Copy
15 static void Main()
16 {
17 Application.EnableVisualStyles();
18 Application.SetCompatibleTextRenderingDefault(false);
19 Application.Run(new Form1());
20 }
Download file with original file name:Form1
Form1 123 lượt xem
Gõ tìm kiếm nhanh...
Dự án liên quan!
Cách sửa bàn phím laptop bị liệt hiệu quả 170k
497 lượt xem
Java enum Constructor
472 lượt xem
Toán tử Spread JavaScript
738 lượt xem
QLTV.designer.cs.dll
895 lượt xem
LinQ.QLTV.designer.cs.dll
879 lượt xem