Read : How to Create Login & Register form Using MD5 Password ?
How to make a database (MySQL) ?
How to crate Connections in C# ?
Membuat Project Login dan Register C#
Langsung saja kita akan membuat project baru dengan visual studio 2015, dan sebelumnya saya pestikan kamu sudah harus membuat sebuah database MySQL, kamu juga bisa mendownload source code dan contoh database yang digunakan dalam tutorial ini nantinya.Buatlah project baru dan beri nama "RegisterLogin-c", atau bisa kamu sesuaikan sesuai kebutuhan aja. ikuti tutorial selanjutnya di bawah ini.
Form Login dan Register
pada Form1.cs ubah menjadi FormLogin.cs, disini kita akan membuat window tampilan untuk user login. desainlah tampilan halaman login seperti gambar berikut :
Selanjutnya buatlah form baru dengan nama FormRegistrations.cs dan desain tampilan FormRegistration.cs seperti gambar dibawah ini :
Kira - kira tampilan login form dan registration form seperti tampilan diatas, kamu bisa saja menyesuaikan dengan kebutuhan kamu.
Source Code Form Login C Sharp
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;
using System.Data.Odbc;
namespace LoginRegister_C {
public partial class LoginForm : Form {
// before you must have a database (MySQL database)
// and we will create a connection using ODBC class
OdbcConnection connection = new OdbcConnection("DSN=java_db;MultipleActiveResultSets=True");
public LoginForm() {
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e) {
connection.Open(); //open our connection
OdbcDataReader dr; // declaration data reader
OdbcCommand cmd; // declaration command
// syntax for read all data from users tables
string sql = "SELECT * FROM users WHERE name='"+ textBox1.Text +"' and password=MD5('"+ textBox2.Text +"')";
cmd = new OdbcCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
cmd.Connection = connection;
dr = cmd.ExecuteReader();
if (dr.HasRows) { // if data reader not null
while(dr.Read()) {
if(dr["level"].ToString() == "1") {
// if level is 1, its just for our Administrations
// so just show any form for administrator
MessageBox.Show("Wellcome Administrator using access level 1", "Information");
} else if(dr["level"].ToString() == "2") {
// if level is 2, its just for user
// so just show any form for user
MessageBox.Show("Wellcome User using access level 2", "Information");
} else if(dr["level"].ToString() == "3") {
// if level is 3, its just for other
// so just show any form for other
MessageBox.Show("Wellcome Other using access level 3", "Information");
} // you can add more user access level here
else {
// show warning if not registered with any level
MessageBox.Show("Not registered with any level access", "Warning");
}
}
} else {
// show message if wrong username or password
MessageBox.Show("Username or password wrong", "Waning");
}
connection.Close(); // close our connections
cmd.Dispose();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) {
FormRegistrations reg = new FormRegistrations();
reg.Show(); // show our ne form registrations
}
private void button2_Click(object sender, EventArgs e) {
this.Close(); // close form
}
}
}
Source Code Form Registrations C Sharp
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;
using System.Data.Odbc; // import namespace of ODBC
namespace LoginRegister_C {
public partial class FormRegistrations : Form {
// same with login form, create connection using ODBC class with MySQL database
OdbcConnection connection = new OdbcConnection("DSN=java_db;MultipleActiveResultSets=True");
public FormRegistrations() {
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e) {
connection.Open(); // open our connection
string TypeUser; // declaration type user to string
int level = Convert.ToInt32(0);
TypeUser = comboBox1.Text;
if(TypeUser == "administrator") {
// if type user is administrator, so level is 1
level = 1;
} else if(TypeUser == "user") {
level = 2; // if type user is "user", so level is 2
} else if(TypeUser == "other") {
level = 2; // if other, level is 3
} else {
// show message if level user is not selected when registering
MessageBox.Show("Please select any level user", "Warning");
}
OdbcDataReader dr; // declaration our data reader
OdbcCommand cmd; //declaration our command
// declaration our syntax to save new user into users tables MySQL database
// the password will be automatic convert into MD5 password
string sql = "INSERT INTO users(name,password,level) VALUES('"+ textBox1.Text +"',MD5('"+ textBox2.Text +"'),'"+ level +"')";
cmd = new OdbcCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
cmd.Connection = connection;
dr = cmd.ExecuteReader();
// show message when success registrations
MessageBox.Show("Registrations Success !", "Information");
connection.Close(); // close our connection
cmd.Dispose();
}
private void FormRegistrations_Load(object sender, EventArgs e) {
comboBox1.Text = "administrator";
}
private void button2_Click(object sender, EventArgs e) {
this.Close();
}
}
}
Jangan lupa menambahkan item pada combobox1 pada form Registration, item yang ditambahkan : administrator, user, other.
Jika semuanya sudah selesai coba jalankan aplikasi sederhana kamu, harus nya akan berjalan baik. jika masih bingung dengan tutorial diatas, silahkan lihat video tutorial berikut ini :
Video tutorial C# login & Registrations form with MySQL and MD5 Password
Download Aplikasi C# login & Registrations form
Download Database Project