STUDID
How do I use S T U D I D
Below are practical examples compiled from projects for learning and reference purposes
Featured Snippets
File name: Form1.cs
Copy
254 public void NavRecords()
255 {
256
257 STUDID.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][1]);
258 TextBox1.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][2]);
259 TextBox2.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][3]);
260 TextBox3.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][4]);
261 TextBox4.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][5]);
262 TextBox5.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][6]);
263 TextBox6.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][7]);
264 TextBox7.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][8]);
265 TextBox8.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][9]);
266 TextBox9.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][10]);
267 TextBox10.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][11]);
268 TextBox11.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][12]);
269 TextBox12.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][13]);
270 TextBox13.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][14]);
271 TextBox14.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][15]);
272 TextBox15.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][16]);
273 TextBox16.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][17]);
274 TextBox17.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][18]);
275 TextBox18.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][19]);
276 TextBox19.Text = (string) (dsgrade.Tables["grade1"].Rows[inc][20]);
277
278 }
File name: Form1.cs
Copy
347 public void Button6_Click(System.Object sender, System.EventArgs e)
348 {
349
350 TextBox1.Text = DataGridView1.CurrentRow.Cells[1].Value.ToString();
351 TextBox2.Text = DataGridView1.CurrentRow.Cells[2].Value.ToString();
352 TextBox3.Text = DataGridView1.CurrentRow.Cells[3].Value.ToString();
353 TextBox4.Text = DataGridView1.CurrentRow.Cells[4].Value.ToString();
354 TextBox5.Text = DataGridView1.CurrentRow.Cells[5].Value.ToString();
355 TextBox6.Text = DataGridView1.CurrentRow.Cells[6].Value.ToString();
356 TextBox7.Text = DataGridView1.CurrentRow.Cells[7].Value.ToString();
357 TextBox8.Text = DataGridView1.CurrentRow.Cells[8].Value.ToString();
358 TextBox9.Text = DataGridView1.CurrentRow.Cells[9].Value.ToString();
359 TextBox10.Text = DataGridView1.CurrentRow.Cells[10].Value.ToString();
360 TextBox11.Text = DataGridView1.CurrentRow.Cells[11].Value.ToString();
361 TextBox12.Text = DataGridView1.CurrentRow.Cells[12].Value.ToString();
362 TextBox13.Text = DataGridView1.CurrentRow.Cells[13].Value.ToString();
363 TextBox14.Text = DataGridView1.CurrentRow.Cells[14].Value.ToString();
364 TextBox15.Text = DataGridView1.CurrentRow.Cells[15].Value.ToString();
365 TextBox16.Text = DataGridView1.CurrentRow.Cells[16].Value.ToString();
366 TextBox17.Text = DataGridView1.CurrentRow.Cells[17].Value.ToString();
367 TextBox18.Text = DataGridView1.CurrentRow.Cells[18].Value.ToString();
368 TextBox19.Text = DataGridView1.CurrentRow.Cells[19].Value.ToString();
369 STUDID.Text = DataGridView1.CurrentRow.Cells[0].Value.ToString();
370
371 }
File name: Form1.cs
Copy
397 public void DataGridView1_CellDoubleClick(object sender, System.Windows.Forms.DataGridViewCellEventArgs e)
398 {
399 TextBox1.Text = DataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
400 TextBox2.Text = DataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
401 TextBox3.Text = DataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
402 TextBox4.Text = DataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
403 TextBox5.Text = DataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
404 TextBox6.Text = DataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
405 TextBox7.Text = DataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();
406 TextBox8.Text = DataGridView1.Rows[e.RowIndex].Cells[8].Value.ToString();
407 TextBox9.Text = DataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString();
408 TextBox10.Text = DataGridView1.Rows[e.RowIndex].Cells[10].Value.ToString();
409 TextBox11.Text = DataGridView1.Rows[e.RowIndex].Cells[11].Value.ToString();
410 TextBox12.Text = DataGridView1.Rows[e.RowIndex].Cells[12].Value.ToString();
411 TextBox13.Text = DataGridView1.Rows[e.RowIndex].Cells[13].Value.ToString();
412 TextBox14.Text = DataGridView1.Rows[e.RowIndex].Cells[14].Value.ToString();
413 TextBox15.Text = DataGridView1.Rows[e.RowIndex].Cells[15].Value.ToString();
414 TextBox16.Text = DataGridView1.Rows[e.RowIndex].Cells[16].Value.ToString();
415 TextBox17.Text = DataGridView1.Rows[e.RowIndex].Cells[17].Value.ToString();
416 TextBox18.Text = DataGridView1.Rows[e.RowIndex].Cells[18].Value.ToString();
417 TextBox19.Text = DataGridView1.Rows[e.RowIndex].Cells[19].Value.ToString();
418 STUDID.Text = DataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
419
420
421 }
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 }
STUDID 133 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
502 lượt xem
Java enum Constructor
476 lượt xem
Toán tử Spread JavaScript
743 lượt xem
LinQ.QLTV.designer.cs.dll
882 lượt xem
QLTV.designer.cs.dll
896 lượt xem