private void btnLogin_Click(object sender, EventArgs e) { string user = this.textBox_user.Text; //用户名 string pwd = this.textBox2.Text; //密码 string studentNO = this.textBox_StudentNO.Text; //学号 string studentName = this.textBox_StudentName.Text; //姓名 //int classNum = int.Parse (textBox_class.Text) ;//班级编号 string sex = this.textBox_sex.Text; //性别 string studentIDNO = this.textBox_StudentIDNO.Text; //身份证号 string major = this.textBox_Major.Text; //专业 string schoolBefore = this.textBox_SchoolBefore.Text; //学校地址 string phone = this.textBox_phone.Text; //电话 string address = this.textBox_addresss.Text; //住址 string postalCode = this.textBox_PostalCode.Text; //邮政编码 string cityWanted = this.textBox_JobWanted.Text; //市区 string jobWanted = this.textBox_JobWanted.Text; //职位 string comment = this.textBox_Comment.Text; //备注 string email = this.textBox_Email.Text; //邮箱 SqlConnection sqlcon = new SqlConnection("Data Source=localhost;Initial Catalog=MySchool;Integrated Security=True"); sqlcon.Open(); string str = "insert into Student(LoginId,LoginPwd,UserStateId,ClassId,StudentNO,StudentName,Sex,StudentIDNO,Major,SchoolBefore,Phone,Address,PostalCode,CityWanted,JobWanted,Comment,Email ) values ('" + user + "','" + pwd + "'," + t + "," + textBox_class.Text + ",'" + studentNO + "','" + studentName + "','" + sex + "','" + studentIDNO + "','" + major + "','" + schoolBefore + "','" + phone + "','" + address + "','" + postalCode + "','" + cityWanted + "','" + jobWanted + "','" + comment + "','" + email + "')"; SqlCommand sqlcom = new SqlCommand(str, sqlcon); int s = sqlcom.ExecuteNonQuery(); if (s > 0) { MessageBox.Show("添加成功"); textBox_user.Clear(); //用户名 textBox2.Clear(); //密码 textBox_StudentNO.Clear(); //学号 textBox_StudentName.Clear(); //姓名 textBox_class.Clear(); //班级编号 textBox_sex.Clear(); //性别 textBox_StudentIDNO.Clear(); //身份证号 textBox_Major.Clear(); //专业 textBox_SchoolBefore.Clear(); //学校地址 textBox_phone.Clear(); //电话 textBox_addresss.Clear(); //住址 textBox_PostalCode.Clear(); //邮政编码 textBox_JobWanted.Clear(); //市区 textBox_JobWanted.Clear(); //职位 textBox_Comment.Clear(); //备注 textBox_Email.Clear(); //邮箱 findStudentForm studentForm = new findStudentForm(); studentForm.Show(); this.Close(); } sqlcon.Close(); }
private void 查找ToolStripMenuItem_Click(object sender, EventArgs e) { findStudentForm findStudent = new findStudentForm(); findStudent.Show(); }