C# - How To Create Login Window In C# With MySQL Database
In This C# Tutorial We Will See How To Make A Login Form Using CSharp Programming Language And MySQL Database.
Part 1
Part 2
Source Code :
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Csharp_And_MySQL
{
public partial class Login_Form_2 : Form
{
public Login_Form_2()
{
InitializeComponent();
}
MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;Initial Catalog='test';username=root;password=");
MySqlDataAdapter adapter;
DataTable table = new DataTable();
private void BTN_Login_Click(object sender, EventArgs e)
{
adapter = new MySqlDataAdapter("SELECT `username`, `password` FROM `users` WHERE `username` = '" + textBox_username.Text + "' AND `password` = '" + textBox_password.Text + "'", connection);
adapter.Fill(table);
if(table.Rows.Count <= 0)
{
panel1.Height = 0;
label_Message.ForeColor = Color.Red;
label_Message.Text = "Username Or Password Are Invalid";
timer1.Start();
}
else
{
panel1.Height = 0;
label_Message.ForeColor = Color.Green;
label_Message.Text = "Login Successfully";
timer1.Start();
}
table.Clear();
}
private void timer1_Tick(object sender, EventArgs e)
{
if(panel1.Height != 100)
{
panel1.Height = panel1.Height + 5;
if(panel1.Height == 100)
{
timer1.Stop();
}
}
}
private void timer2_Tick(object sender, EventArgs e)
{
if (panel1.Height != 0)
{
panel1.Height = panel1.Height - 5;
if (panel1.Height == 0)
{
timer2.Stop();
}
}
}
private void BTN_OK_Click(object sender, EventArgs e)
{
timer2.Start();
}
private void checkBox_ShowPass_CheckedChanged(object sender, EventArgs e)
{
if(checkBox_ShowPass.Checked)
{
textBox_password.UseSystemPasswordChar = true;
}
else
{
textBox_password.UseSystemPasswordChar = false;
}
}
}
}
=> OutPut :
Login Failed |
Login Successfully |
Update Contact :
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email : Fajarudinsidik@gmail.com
No Wa/Telepon (puat) : 085267792168
No Wa/Telepon (fajar) : 085369237896
Email: Fajarudinsidik@gmail.com
atau Kirimkan Private messanger melalui email dengan klik tombol order dibawah ini :