private void button2_Click(object sender, EventArgs e) { if (name.Text == "" || number.Text == "" || setpassword.Text == "" || depart.SelectedItem == "" || ((sexboy.Checked == false) & (sexgirl.Checked == false))) { MessageBox.Show("请填完整信息", "警告"); } else { SqlConnection con = new SqlConnection("Data Source=154.8.169.229;Initial Catalog=StudentSociety_SQL;User ID=psn;Password=student=123"); con.Open(); string sql = "select * from [User] where User_ID= '" + number.Text.Trim() + "'"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); if (sdr.HasRows) { MessageBox.Show("该用户已注册", "提示"); } else { string sex; sdr.Close(); SqlConnection conn = new SqlConnection("Data Source=154.8.169.229;Initial Catalog=StudentSociety_SQL;User ID=psn;Password=student=123"); conn.Open(); if (sexboy.Checked) { sex = "男"; } else { sex = "女"; } string schoolID; switch (school.Text) { case "地球科学与技术学院": schoolID = "001"; break; case "石油工程学院": schoolID = "002"; break; case "化学工程学院": schoolID = "003"; break; case "机电工程学院": schoolID = "004"; break; case "信息与控制工程学院": schoolID = "005"; break; case "储运与建筑工程学院": schoolID = "006"; break; case "计算机与通讯工程学院": schoolID = "007"; break; case "经济管理学院": schoolID = "008"; break; case "理学院": schoolID = "009"; break; case "文学院": schoolID = "010"; break; case "马克思主义学院": schoolID = "011"; break; default: schoolID = "012"; break; } /*string gradeID; * switch (grade.Text) * { * case "2018级": * gradeID = "001"; break; * case "2017级": * gradeID = "002"; break; * case "2016级": * gradeID = "003"; break; * default: * gradeID = "004"; break; * }*/ string departID; switch (depart.Text) { case "活动策划组": departID = "001"; break; case "活动组织部": departID = "002"; break; case "活动宣传部": departID = "003"; break; case "行政部": departID = "004"; break; case "财务部": departID = "005"; break; case "外联部": departID = "006"; break; default: departID = "007"; break; } string myinsert = "insert into [Project](New_ID,New_Name,New_Grade,New_DepartID,New_Sex,New_School,New_Telephone,New_Password,Check_Result)" + " values ('" + number.Text + "','" + name.Text + "','" + grade.Text + "','" + departID + "','" + sex + "','" + schoolID + "','" + phone.Text + "','" + setpassword.Text + "','未审核')"; SqlCommand mycom = new SqlCommand(myinsert, conn); //定义OleDbCommnad对象并连接数据库 mycom.ExecuteNonQuery(); //执行插入语句 conn.Close(); //关闭对象并释放所占内存空间 conn.Dispose(); MessageBox.Show("申请成功,请等待审核!"); Welcome welcome1 = new Welcome(); welcome1.Show(); this.Close(); } } }