/// <summary> /// 点击添加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { Student stu = new Student() { LoginPwd = this.txtPwd.Text.Trim(), StudentName = this.txtStudentName.Text.Trim(), Gender = this.rbMale.Checked? "男":"女", GradeId = this.cbGrade.SelectedIndex + 1, Phone = this.txtPhone.Text.Trim(), Address = this.txtAddress.Text.Trim(), BornDate = Convert.ToDateTime(this.dtpBornDate.Value), Email = this.txtEmail.Text.Trim(), IdentityCard = this.txtIdentity.Text.Trim() }; List <Student> stuList = new List <Student>(); stuList.Add(stu); string sql = ""; foreach (Student item in stuList) { sql = string.Format(@"insert into student values('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", item.LoginPwd, item.StudentName, item.Gender, item.GradeId, item.Phone, item.Address, item.BornDate, item.Email, item.IdentityCard); } string a = StudentService.AddReault(sql); MessageBox.Show("添加成功"); frm.Updated("select * from student"); }