private void btn_login_Click(object sender, RoutedEventArgs e) { MySqlConnection sqlCon = new MySqlConnection("xxxxxx"); try { if (sqlCon.State == System.Data.ConnectionState.Closed) sqlCon.Open(); String query = "SELECT COUNT(1) FROM tblUser WHERE Username=@Username AND Password=@Password"; MySqlCommand sqlCmd = new MySqlCommand(query, sqlCon); sqlCmd.CommandType = System.Data.CommandType.Text; sqlCmd.Parameters.AddWithValue("@Username", txtUsername.Text); sqlCmd.Parameters.AddWithValue("@Password", utils.hashPassword(txtPassword.Text)); int count = Convert.ToInt32(sqlCmd.ExecuteScalar()); if (count == 1) { //Logged in MessageBox.Show('Logged in'); } else { //Wrong details! MessageBox.Show('Wrong Details'); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlCon.Close(); } }
public class utils { public static string hashPassword(string password) { SHA1CryptoServiceProvider sha1 = new SHA1CryptoServiceProvider(); byte[] password_bytes = Encoding.ASCII.GetBytes(password); byte[] encripted_bytes = sha1.ComputeHash(password_bytes); return Convert.ToBase64String(encripted_bytes); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)