private void skinButton1_Click(object sender, EventArgs e) { if (skinTextBox1.Text != "") { //string sql = "insert into student(sno,sname,ssex,sclass,zno,Admission_time,Graduation_time,inschool) values('" + skinTextBox1.Text.ToString() + "','" // + skinTextBox2.Text + "','" + skinComboBox1.SelectedItem + "','" + skinTextBox3.Text + "','" //+ skinComboBox2.SelectedItem + "','" + dateTimePicker1.Value + "','" //+ dateTimePicker2.Value + "'," + skinComboBox3.SelectedItem + ")"; string sql = "insert into student(sno,sname,ssex,sclass,zno,Admission_time,Graduation_time,inschool) values('" + skinTextBox1.Text + "','" + skinTextBox2.Text + "','" + skinComboBox1.SelectedItem + "','" + skinTextBox3.Text + "','" + skinComboBox2.SelectedItem + "','" + dateTimePicker1.Value + "','" + dateTimePicker2.Value + "'," + skinComboBox3.SelectedItem + ")"; if (op.OPSQL(sql)) { //ClearText(); MessageBox.Show("新建成功!"); } else { MessageBox.Show("创建失败!"); } } else { MessageBox.Show("信息输入不全!"); } }
private void skinDataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { //获取行号 int rowindex = e.RowIndex; string value0 = skinDataGridView1.Rows[rowindex].Cells[0].Value.ToString(); string value1 = skinDataGridView1.Rows[rowindex].Cells[1].Value.ToString(); string value2 = skinDataGridView1.Rows[rowindex].Cells[2].Value.ToString(); string value3 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString(); string sql = "UPDATE Teacher_teaching SET lesson_time = '" + value3 + "' WHERE tno = '" + value0 + "' and cno = '" + value1 + "'"; //string sql = "update grade set grade='" + value3 + "' where sno='" + value0 + "'and cno='" + value1 + "'and tno='" + value2 + "'"; if (op.OPSQL(sql)) { //修改成功 label1.Text = "更新课表信息成功!! 职工号:" + value0 + " 行号:" + rowindex; //MessageBox.Show("修改成功!"); } else { MessageBox.Show("更新课表信息成功!!职工号:" + value0 + " 行号:" + rowindex); label1.Text = "更新课表信息失败!! 职工号:" + value0 + " 行号:" + rowindex; } }
private void skinButton1_Click(object sender, EventArgs e) { if (skinTextBox1.Text != "") { string sql = "UPDATE teacher SET tno = '" + skinTextBox1.Text + "',tname = '" + skinTextBox2.Text + "', tsex = '" + skinComboBox1.SelectedItem + "', tduties='" + skinComboBox2.SelectedItem + "' WHERE tno = '" + skinTextBox1.Text + "'"; //string sql = "insert into student(sno,sname,ssex,date,nation,nativeplace,grade,profession,scholarship) values('" + txtID.Text + "','" + txtName.Text + "','" + comboSex.SelectedItem + "','" + dateTime.Value + "','" + txtNation.Text + "','" + txtNative.Text + "','" + txtScore.Text + "','" + comboMajor.SelectedItem + "','" + txtGrant.Text + "')"; if (op.OPSQL(sql)) { //ClearText(); MessageBox.Show("更新成功!"); } else { MessageBox.Show("更新失败!"); } } else { MessageBox.Show("请输入要修改的职工号"); } }
private void skinDataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { //获取行号 int rowindex = e.RowIndex; string value0 = skinDataGridView1.Rows[rowindex].Cells[0].Value.ToString(); string value1 = skinDataGridView1.Rows[rowindex].Cells[1].Value.ToString(); string value2 = skinDataGridView1.Rows[rowindex].Cells[2].Value.ToString(); string value3 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString(); string value4 = skinDataGridView1.Rows[rowindex].Cells[1].Value.ToString(); string value5 = skinDataGridView1.Rows[rowindex].Cells[2].Value.ToString(); string value6 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString(); string value7 = skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString(); // int value7 = int.Parse(skinDataGridView1.Rows[rowindex].Cells[3].Value.ToString()); string sql = "UPDATE student SET sno='" + value0 + "',sname = '" + value1 + "',ssex = '" + value2 + "',sclass = '" + value3 + "',zno = '" + value4 + "',Admission_time = '" + value5 + "',Graduation_time = '" + value6 + "',inschool = " + value7 + " WHERE sno = '" + value0 + "'"; //string sql = "update grade set grade='" + value3 + "' where sno='" + value0 + "'and cno='" + value1 + "'and tno='" + value2 + "'"; if (op.OPSQL(sql)) { //修改成功 label1.Text = "更新学生信息成功!! 学号:" + value0 + " 行号:" + rowindex; //MessageBox.Show("修改成功!"); } else { MessageBox.Show("更新学生信息成功!!学号:" + value0 + " 行号:" + rowindex); label1.Text = "更新学生信息失败!! 学号:" + value0 + " 行号:" + rowindex; } }
private void skinButton1_Click(object sender, EventArgs e) { if (skinTextBox1.Text != "") { string sql = "insert into teacher(tno,tname,tsex,tduties) values('" + skinTextBox1.Text + "','" + skinTextBox2.Text + "','" + skinComboBox1.SelectedItem + "','" + skinComboBox2.SelectedItem + "')"; if (op.OPSQL(sql)) { //ClearText(); MessageBox.Show("新建成功!"); } else { MessageBox.Show("创建失败!"); } } else { MessageBox.Show("信息输入不全!"); } }