private void button_submit_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(forgotpw.connectionstr); conn.Open(); String sql = "select * from [dbo].[user] where uname='" + text_un.Text + "'and upw='" + text_pw.Text + "'and uphone='" + text_phone.Text + "'and uemail='" + text_email.Text + "'and uredate='" + dateTimePicker1.Value + "'"; SqlDataAdapter adp = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); adp.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { DialogResult result = MessageBox.Show("Sure to delete?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { string sqluid = "select * from [dbo].[user] where uname='" + text_un.Text + "'"; SqlCommand finduid = new SqlCommand(sqluid, conn); SqlDataReader uidread = finduid.ExecuteReader(); uidread.Read(); string uid = uidread["uid"].ToString().Trim(); uidread.Close(); SqlCommand cmd1 = conn.CreateCommand(); cmd1.CommandText = "delete from [dbo].[active] where uid='" + uid + "'"; cmd1.ExecuteNonQuery(); SqlCommand cmd2 = conn.CreateCommand(); cmd2.CommandText = "delete from [dbo].[user] where uname='" + text_un.Text + "'"; cmd2.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Succeeded!"); string un = text_un.Text; this.Close(); fm1.Close(); login form = new login(); form.Show(); } } else { warn.Visible = true; } }
protected void button_submit_Click(object sender, EventArgs e)//以插入表现注册新账号 { if (text_un.Text == "") { username.ForeColor = Color.FromArgb(255, 0, 0); } else { username.ForeColor = Color.FromArgb(255, 255, 255); } if (text_pw.Text == "") { password.ForeColor = Color.FromArgb(255, 0, 0); } else { password.ForeColor = Color.FromArgb(255, 255, 255); } if (text_confirmpw.Text == "") { confirmpw.ForeColor = Color.FromArgb(255, 0, 0); } else { confirmpw.ForeColor = Color.FromArgb(255, 255, 255); } if (text_phone.Text == "") { phone.ForeColor = Color.FromArgb(255, 0, 0); } else { phone.ForeColor = Color.FromArgb(255, 255, 255); } if (text_confirmpw.Text != text_pw.Text) { confirmpw.ForeColor = Color.FromArgb(255, 0, 0); } int lenun, lenpw; lenun = System.Text.Encoding.Default.GetByteCount(text_un.Text); lenpw = System.Text.Encoding.Default.GetByteCount(text_pw.Text); Regex number = new Regex(@"^[0-9]+$"); //仅数字的正则表达式 Regex letter = new Regex(@"^[A-Za-z]+$"); //仅字母的正则表达式 if ((lenun < 8 || lenun > 16) && (!number.IsMatch(text_un.Text) || !letter.IsMatch(text_un.Text) || !text_un.Text.Contains("_")) && text_un.Text != "") { warn2.Visible = true; } else { warn2.Visible = false; } if ((lenpw < 8 || lenpw > 16) && (!number.IsMatch(text_pw.Text) || !letter.IsMatch(text_pw.Text)) && text_pw.Text != "") { warn2.Visible = true; } else { warn2.Visible = false; } if ((!number.IsMatch(text_phone.Text)) && text_phone.Text != "") { warn3.Visible = true; } else { warn3.Visible = false; } if (!text_email.Text.Contains("@") && text_email.Text != "") { warn3.Visible = true; } else { warn3.Visible = false; } if (username.ForeColor != Color.FromArgb(255, 0, 0) && password.ForeColor != Color.FromArgb(255, 0, 0) && confirmpw.ForeColor != Color.FromArgb(255, 0, 0) && phone.ForeColor != Color.FromArgb(255, 0, 0) && warn2.Visible == false && warn3.Visible == false) { SqlConnection conn = new SqlConnection(register.connectionstr); conn.Open(); string sql = String.Format("select uname from [dbo].[user] where uname = '{0}'", text_un.Text); SqlCommand command = new SqlCommand(sql, conn); SqlDataReader datareader = command.ExecuteReader(); int i; for (i = 0; datareader.Read(); i++) { } if (i > 0) { warn1.Visible = true; } else//未注册,检查填写邮箱,向数据表中插入相应的用户名和密码 { datareader.Close(); string newuser = String.Format("insert into [dbo].[user](uname,upw,uban,uphone,uemail,uredate) values('{0}','{1}','{2}','{3}','{4}','{5}')", text_un.Text, text_pw.Text, 0, text_phone.Text, text_email.Text, DateTime.Now.ToShortDateString().ToString()); SqlCommand cmd = new SqlCommand(newuser, conn); int j = cmd.ExecuteNonQuery(); if (j > 0) { MessageBox.Show("Welcome"); this.DialogResult = DialogResult.Retry; conn.Close(); login form = new login(); form.Show(); this.Hide(); } } } label_code.Text = randomcode.code(); text_code.Text = ""; button_submit.Enabled = false; }