[C#] login form 만들기

출처 : https://www.youtube.com/watch?v=ruTifUtQu88

Mysql을 연동하기 위해 참조 추가

Mysql 테이블 만들기

추가->새항목->window form이면 새로운 창 만들기

추가->클래스하면 mysql데이터 저장하는 class

속성->설정 (Remember Me를 누르면 ID와 Password를 기록해놓음)

frmLogin.cs

using System; using System.Collections.Generic; using System.ComponentModel; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using Dapper; using MySql.Data.MySqlClient; namespace LoginForm { public partial class frmLogin : MetroFramework.Forms.MetroForm { public frmLogin() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { this.StyleManager = metroStyleManager1; metroStyleManager1.Theme = MetroFramework.MetroThemeStyle.Light; metroStyleManager1.Style = MetroFramework.MetroColorStyle.Green; if (Properties.Settings.Default.RememberMe) { txtUserName.Text = Properties.Settings.Default.UserName; txtPassword.Text = Properties.Settings.Default.Password; } } private void btnLogin_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtUserName.Text)) { MetroFramework.MetroMessageBox.Show(this, "Please enter your username.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtUserName.Focus(); return; } //mysql 연동 MySqlConnection conn; string strconn = "Server=localhost;Database=user;Uid=root;Pwd=PASSWORD;"; conn = new MySqlConnection(strconn); try { conn.Open(); string strSelect = "SELECT * from user where UserName=" + txtUserName.Text; MySqlCommand cmd = new MySqlCommand(strSelect, conn); MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { if (rdr["Password"].ToString() == txtPassword.Text) { using (frmMain frm = new frmMain()) { this.Hide(); frm.ShowDialog(); } } else { MetroFramework.MetroMessageBox.Show(this, "Your username and password don't match.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } private void chkRememberMe_CheckedChanged(object sender, EventArgs e) { if (chkRememberMe.Checked) { Properties.Settings.Default.UserName = txtUserName.Text; Properties.Settings.Default.Password = txtPassword.Text; } else { Properties.Settings.Default.UserName = null; Properties.Settings.Default.Password = null; } Properties.Settings.Default.RememberMe = chkRememberMe.Checked; Properties.Settings.Default.Save(); } } }

User.cs (class만듬)

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace LoginForm { public class User { public String UserName { get; set; } public String Password { get; set; } } }

결과화면

1. login 화면

2. 둘다 빈칸이면 뜨는 에러 메시지

3. 아이디나 비밀번호가 맞지 않으면 나오는 메시지