TextBox6

67         private void btnthem_Click(object sender, EventArgs e)
68         {
69             try
70             {
71             string mats = textBox1.Text;
72             string hoten = textBox2.Text;
73             string ngaysinh = textBox3.Text;
74             string gioitinh = textBox4.Text;
75             string quequan = textBox5.Text;
76             string sodt = textBox6.Text;
77             string email = textBox7.Text;
78
79             string strSQL = "insert SINHVIEN values('" + mats + "','" + hoten + "','" + ngaysinh + "','" + gioitinh + "','" + quequan + "','" + sodt + "','" + email + "')";
80             sqlcmd = new SqlCommand(strSQL, sqlcon);
81             sqlcmd.ExecuteNonQuery();
82             MessageBox.Show("B?n dã dang ký thành công");
83             load();
84             }
85                 catch
86             {
87                 MessageBox.Show("Trùng mã sinh viên !!!");
88                 }
89
90         }

97         private void btnsua_Click(object sender, EventArgs e)
98         {
99             try
100             {
101                 string mats = textBox1.Text;
102                 string hoten = textBox2.Text;
103                 string ngaysinh = textBox3.Text;
104                 string gioitinh = textBox4.Text;
105                 string quequan = textBox5.Text;
106                 string sodt = textBox6.Text;
107                 string email = textBox7.Text;
108                 sqlcmd = new SqlCommand("update sinhvien set mats='" + mats + "',hoten='" + hoten + "',ngaysinh='" + ngaysinh + "',gioitinh='" + gioitinh + "',quequan='" + quequan + "',sodienthoai='" + sodt + "',email'" + email + "' ", sqlcon);
109                 sqlcmd.ExecuteNonQuery();
110
111                 load();
112             }
113             catch
114             {
115                 MessageBox.Show("Loi");
116             }
117         }

128         private void listView1_SelectedIndexChanged(object sender, EventArgs e)
129         {
130             for (int i = 0; i < listView1.Items.Count; i++)
131                 if (listView1.Items[i].Selected)
132                 {
133                     textBox1.Text = listView1.Items[i].SubItems[0].Text;
134                     textBox2.Text = listView1.Items[i].SubItems[1].Text;
135                     textBox3.Text = listView1.Items[i].SubItems[2].Text;
136                     textBox4.Text = listView1.Items[i].SubItems[3].Text;
137                     textBox5.Text = listView1.Items[i].SubItems[4].Text;
138                     textBox6.Text = listView1.Items[i].SubItems[5].Text;
139                     textBox7.Text = listView1.Items[i].SubItems[6].Text;
140
141                 }
142         }

58   public void Button1_Click(System.Object sender, System.EventArgs e)
59   {
60    int a = default(int);
61    decimal b = new decimal();
62
63    if (Information.IsNumeric(TextBox3.Text))
64    {
65     if (int.Parse(TextBox3.Text) <= 20 )
66     {
67      a = (int) ((double.Parse(TextBox3.Text) * 100) / 20);
68      TextBox4.Text = a.ToString();
69      b = (decimal) (a * 0.1);
70      TextBox5.Text = b.ToString();
71     }
72     else
73     {
74      MessageBox.Show("Please Enter value equal to 20 and below!");
75     }
76    }
77    if (Information.IsNumeric(TextBox6.Text))
78    {
79
80     if (int.Parse(TextBox6.Text) <= 50 )
81     {
82      int c = default(int);
83      decimal d = new decimal();
84      c = (int) ((double.Parse(TextBox6.Text) * 100) / 50);
85      TextBox7.Text = c.ToString();
86      d = (decimal) (c * 0.1);
87      TextBox8.Text = d.ToString();
88
89     }
90     else
91     {
92      MessageBox.Show("Please Enter value equal to 50 and below!");
93
94
95     }
96    }
97
98    if (Information.IsNumeric(TextBox9.Text))
99    {
100     if (int.Parse(TextBox9.Text) <= 50 )
101     {
102      int g = default(int);
103      decimal f = new decimal();
104      g = (int) ((double.Parse(TextBox9.Text) * 100) / 50);
105      TextBox10.Text = g.ToString();
106      f = (decimal) (g * 0.2);
107      TextBox11.Text = f.ToString();
108
109     }
110     else
111     {
112      MessageBox.Show("Please Enter value equal to 50 and below!");
113
114
115     }
116    }
117    if (Information.IsNumeric(TextBox12.Text))
118    {
119     if (int.Parse(TextBox12.Text) <= 100 )
120     {
121      int g = default(int);
122      decimal f = new decimal();
123      g = (int) ((double.Parse(TextBox12.Text) * 100) / 100);
124      TextBox13.Text = g.ToString();
125      f = (decimal) (g * 0.3);
126      TextBox14.Text = f.ToString();
127
128     }
129     else
130     {
131      MessageBox.Show("Please Enter value equal to 100 and below!");
132
133
134     }
135    }
136
137    if (Information.IsNumeric(TextBox15.Text))
138    {
139     if (int.Parse(TextBox15.Text) <= 100 )
140     {
141      int j = default(int);
142      decimal f1 = new decimal();
143      j = (int) ((double.Parse(TextBox15.Text) * 100) / 100);
144      TextBox16.Text = j.ToString();
145      f1 = (decimal) (j * 0.3);
146      TextBox17.Text = f1.ToString();
147
148     }
149     else
150     {
151      MessageBox.Show("Please Enter value equal to 100 and below!");
152
153
154     }
155    }
156
157    decimal adal = new decimal();
158    adal = (decimal) (Conversion.Val(TextBox5.Text) + Conversion.Val(TextBox8.Text) + Conversion.Val(TextBox11.Text) + Conversion.Val(TextBox14.Text) + Conversion.Val(TextBox17.Text));
159
160    TextBox18.Text = adal.ToString();
161
162    if (Conversion.Val(TextBox18.Text) <= 74)
163    {
164
165     TextBox19.Text = "Failed";
166     TextBox19.ForeColor = Color.Red;
167    }
168    else
169    {
170     TextBox19.Text = "Passed";
171     TextBox19.ForeColor = Color.Black;
172
173
174    }
175
176
177   }

185   public void Button3_Click(System.Object sender, System.EventArgs e)
186   {
187
188    TextBox1.Text = "";
189    TextBox12.Text = "";
190    TextBox3.Text = "";
191    TextBox4.Text = "";
192    TextBox5.Text = "";
193    TextBox6.Text = "";
194    TextBox7.Text = "";
195    TextBox8.Text = "";
196    TextBox9.Text = "";
197    TextBox10.Text = "";
198    TextBox11.Text = "";
199    TextBox12.Text = "";
200    TextBox13.Text = "";
201    TextBox14.Text = "";
202    TextBox15.Text = "";
203    TextBox16.Text = "";
204    TextBox17.Text = "";
205    TextBox18.Text = "";
206    TextBox19.Text = "";
207
208
209   }

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   }

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   }

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   }

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   }

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   }