private void button1_Click(object sender, EventArgs e) { int errors = 0; string outMessage = ""; if (textBox1.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter name\n"; } if (textBox2.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter login\n"; } if (textBox3.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter password\n"; } if (textBox4.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter password\n"; } if (!textBox3.Text.Equals(textBox4.Text)) { errors = errors + 1; outMessage = outMessage + errors.ToString() + " )Password do not match\n"; } if (errors == 0) { var connection = new SqlConnection(Properties.Settings.Default.dbConnectionString); connection.Open(); try { rrr = new Authform(); SqlCommand cmd = new SqlCommand("INSERT INTO users (name,login,pass) VALUES (@name,@login,@password)", connection); cmd.Parameters.AddWithValue("@name", textBox1.Text); cmd.Parameters.AddWithValue("@login", textBox2.Text); cmd.Parameters.AddWithValue("@password", rrr.md5(textBox3.Text)); int regged = Convert.ToInt32(cmd.ExecuteNonQuery()); connection.Close(); MessageBox.Show("You have successfully registered!"); } catch { MessageBox.Show("User exists!"); } } else { MessageBox.Show("There are mistakes!\n" + outMessage); } }
// Обрабочтик события Click по кнопке Save private void button1_Click(object sender, EventArgs e) { // Проверки // Если все проверки пройдены, то errors = 0, в противном случае errors > 0 int errors = 0; string outMessage = ""; if (textBox1.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter name\n"; } if (textBox2.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter login\n"; } if (textBox3.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter password\n"; } if (textBox4.Text == "") { errors++; outMessage = outMessage + errors.ToString() + " )Enter password\n"; } if (!textBox3.Text.Equals(textBox4.Text)) { errors = errors + 1; outMessage = outMessage + errors.ToString() + " )Password do not match\n"; } if (errors == 0) { // Если ошибок нет, открываем SQL соединение connection.Open(); try { // Формируем строку запроса, на добавление пользователя rrr = new Authform(); SqlCommand cmd = new SqlCommand("INSERT INTO users (name,login,pass) VALUES (@name,@login,@password)", connection); cmd.Parameters.AddWithValue("@name", textBox1.Text); cmd.Parameters.AddWithValue("@login", textBox2.Text); cmd.Parameters.AddWithValue("@password", rrr.md5(textBox3.Text)); int regged = Convert.ToInt32(cmd.ExecuteNonQuery()); // Закрываем соединение connection.Close(); MessageBox.Show("You have successfully registered!"); } catch { // Если такой пользователь существует, то выбрасываем исключение MessageBox.Show("User exists!"); } } else { MessageBox.Show("There are mistakes!\n" + outMessage); } }