Advertisement
Guest User

Untitled

a guest
May 14th, 2019
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.06 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using MySql.Data.MySqlClient;
  11.  
  12. namespace toko_baju
  13. {
  14. public partial class frmLogin : Form
  15. {
  16. public static string PassingData1 = "";
  17. string Connection = "Server=localhost;Port=3306;UID=root;PWD=;Database=toko_baju";
  18. MySqlConnection cnn;
  19. MySqlCommand cmd;
  20. MySqlDataReader dr;
  21.  
  22. public frmLogin()
  23. {
  24. InitializeComponent();
  25. }
  26.  
  27. private void lblSignUp_Click(object sender, EventArgs e)
  28. {
  29. this.Hide();
  30. frmRegister fr = new frmRegister();
  31. fr.Show();
  32. }
  33.  
  34. private void btnLogin_Click(object sender, EventArgs e)
  35. {
  36. string username, password;
  37. username = txtUsername.Text;
  38. password = txtPassword.Text;
  39.  
  40. MySqlConnection cnn = new MySqlConnection(Connection);
  41. try
  42. {
  43. cnn.Open();
  44. MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM admin WHERE username = '" + username + "' && password = '" + password + "'", cnn);
  45. DataTable dt = new DataTable();
  46. da.Fill(dt);
  47. if (dt.Rows.Count <= 0)
  48. {
  49. MessageBox.Show("Username Atau Password Salah!!!", "Peringatan", MessageBoxButtons.OK);
  50. }
  51. else
  52. {
  53. PassingData1 = username;
  54. this.Hide();
  55. frmMaster fm = new frmMaster("Welcome : " + username);
  56. fm.Show();
  57. }
  58. cnn.Close();
  59. }
  60. catch (Exception)
  61. {
  62. MessageBox.Show("Koneksi Error");
  63. }
  64. }
  65.  
  66. private void frmLogin_Load(object sender, EventArgs e)
  67. {
  68.  
  69. }
  70. }
  71. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement