private void buttonReset_Click(object sender, EventArgs e) { var currentrow = dataGridViewUsers.CurrentRow; string usercell = currentrow.Cells["ColumnUsername"].Value.ToString(); string newpass = DataHandler.GenerateRandomString(8); string connectionString = "Data Source=ANDREY;Initial Catalog=Signatures;Integrated Security=True"; var conn = new SqlConnection(connectionString); try { conn.Open(); var command = new SqlCommand( @"UPDATE [Users] SET [Password] = @pass, [IsTemporary] = 1 WHERE [Username] = @user", conn); command.Parameters.AddWithValue("@user", usercell); command.Parameters.AddWithValue("@pass", DataHandler.hash(newpass)); //Обратное значение command.ExecuteNonQuery(); MessageBox.Show("Новый пароль: " + newpass, "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception err) { MessageBox.Show("Ошибка: " + err.Message, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { conn.Close(); GetData(dataGridViewUsers.Rows.IndexOf(currentrow)); } }
private void buttonGenPass_Click(object sender, EventArgs e) { textBoxPassword.Text = DataHandler.GenerateRandomString(8); }