private void bttnConfirm_Click(object sender, EventArgs e) { connection = new MySqlConnection("server = 127.0.0.1; port = 3306; user = root; password = Vfhnvfhn23@; database = tinkoffbudget; sslmode = none"); connection.Open(); string Password = HashingPsw.HashPassword(tbPassword.Text); MySqlCommand cSelect = new MySqlCommand("SELECT Логин, Пароль FROM пользователи WHERE Логин= '" + tbLogin.Text + "' AND Пароль= '" + Password + "'", connection); MySqlDataAdapter daSelect = new MySqlDataAdapter(cSelect); DataTable dtSelect = new DataTable(); daSelect.Fill(dtSelect); if (dtSelect.Rows.Count > 0) { //Active user MySqlCommand cUserID = new MySqlCommand("SELECT `ID пользователя` FROM пользователи WHERE Логин = '" + tbLogin.Text + "'", connection); object userIDObj = cUserID.ExecuteScalar(); string userID = userIDObj.ToString(); Hide(); frmMainMenu FMA = new frmMainMenu(userID); FMA.ShowDialog(); } else { MessageBox.Show("Пожалуйста, проверьте правильность написания логина и пароля."); connection.Close(); } }
private void bttnConfirm_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(tbLogin.Text)) { MessageBox.Show("Строка \"Логин\" не может быть пустой"); } else if (string.IsNullOrWhiteSpace(tbPassword.Text)) { MessageBox.Show("Строка \"Пароль\" не может быть пустой"); } else { MySqlConnection connection = new MySqlConnection("server = 127.0.0.1; port = 3306; user = root; password = Vfhnvfhn23@; database = tinkoffbudget; sslmode = none"); connection.Open(); string password = HashingPsw.HashPassword(tbPassword.Text); MySqlCommand cAdd = new MySqlCommand("INSERT INTO пользователи(Логин, Пароль) VALUES ('" + tbLogin.Text + "', '" + password + "')", connection); if (cAdd.ExecuteNonQuery() == 1) { connection.Close(); Close(); } } }