private void button1_Click(object sender, EventArgs e) { StudentInfoData data = new StudentInfoData(); data.Sno = txtSno.Text; data.Sname = txtSname.Text; if (rdoMale.Checked) { data.Sex = rdoMale.Text; } else { data.Sex = rdoFemale.Text; } data.Birthday = txtBirthday.Text; data.Classid = txtClassid.Text; data.Tel = txtTel.Text; data.Address = txtAddress.Text; if (txtSno.Text == "" || txtSno.Text == null) { MessageBox.Show("学号不能为空"); txtSno.Focus(); return; } Classes.StudentInfoOperation op = new Classes.StudentInfoOperation(); if (op.InsertStudentInfo(data)) { MessageBox.Show("插入成功"); } else { MessageBox.Show("失败"); } }
DataSet Bind() { StudentInfoData data = new StudentInfoData(); data.Sno = txtSno.Text; data.Sname = txtSname.Text; data.Sex = txtSex.Text; data.Classid = txtClass.Text; Classes.StudentInfoOperation op = new Classes.StudentInfoOperation(); ds = op.GetStudentInfo(data); return(ds); }
//删除 private void button3_Click(object sender, EventArgs e) { string sno = txtSno1.Text; Classes.StudentInfoOperation op = new Classes.StudentInfoOperation(); if (op.DeleteStudent(sno)) { MessageBox.Show("成功"); } else { MessageBox.Show("失败了"); } dataGridView1.DataSource = Bind().Tables[0]; }
//修改 private void button2_Click(object sender, EventArgs e) { StudentInfoData data = new StudentInfoData(); data.Sno = txtSno1.Text; data.Sname = txtSname1.Text; data.Sex = txtSex1.Text; data.Birthday = txtBirthday1.Text; data.Classid = txtClass.Text; data.Tel = txtTel1.Text; data.Address = txtAddress1.Text; Classes.StudentInfoOperation op = new Classes.StudentInfoOperation(); if (op.UpdateStudent(data)) { MessageBox.Show("成功"); } else { MessageBox.Show("失败了"); } dataGridView1.DataSource = Bind().Tables[0]; }