Java - How To Create Login Window In Java With MySQL Database In Java NetBeans

C# - How To Create Login Form In C# With MySQL Database

5 Comments

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

Download Projects Source Code

C# - How To Hide And Show Password Using C#

Add Comment

C# - How To Hide And Display Password Text Using C#

In This C# Tutorial We Will See How To Show And Hide Password Text In TextBox With A CheckBox Using CSharp Programming Language .

Source Code :

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 Show_Hide_Password : Form

{

public Show_Hide_Password()

{

InitializeComponent();

}

private void checkBox_Show_Hide_CheckedChanged(object sender, EventArgs e)

{

if(checkBox_Show_Hide.Checked)

{

textBox_Password.UseSystemPasswordChar = true;

}

else

{

textBox_Password.UseSystemPasswordChar = false;

}

=> OutPut :

Hide And Show Password Using C#

Download Projects Source Code

C# And MySQL - Populate Combobox Depending On Another Combobox Selected Value

1 Comment

C# And MySQL - Bind Combobox Depending On Another Combobox Selected Value

In This C# Tutorial We Will See How To Fill Data Into A ComboBox
Based On A ComboBox Selected value In CSharp Programming Language .

Source Code:

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 MySql.Data.MySqlClient;

namespace Csharp_And_MySQL

{

public partial class Csharp_MySQL_datagridview_depending_combobox_value : Form

{

MySqlConnection con = new MySqlConnection("datasource=localhost;port=3306;Initial Catalog ='project';username=root;password=");

MySqlCommand command;

MySqlDataAdapter adapter;

DataTable table;

public Csharp_MySQL_datagridview_depending_combobox_value()

{

InitializeComponent();

}

private void Csharp_MySQL_datagridview_depending_combobox_value_Load(object sender, EventArgs e)

{

string query = "SELECT `CAT_ID`, `CAT_NAME` FROM `categories`";

comboBox_Categories.DataSource = getData(query);

comboBox_Categories.DisplayMember = "CAT_NAME";

comboBox_Categories.ValueMember = "CAT_ID";

comboBox_Categories_SelectedIndexChanged(null, null);

}

public DataTable getData(string query)

{

command = new MySqlCommand(query, con);

adapter = new MySqlDataAdapter(command);

table = new DataTable();

adapter.Fill(table);

return table;

}

private void comboBox_Categories_SelectedIndexChanged(object sender, EventArgs e)

{

int val;

Int32.TryParse(comboBox_Categories.SelectedValue.ToString(), out val);

string query = "SELECT `ID_PRO`, `PRO_NAME`, `QTE_IN_STOCK`, `PRICE`, `ID_CAT` FROM `products` WHERE `ID_CAT` = " + val;

dataGridView_Products.DataSource = getData(query);

}

=> OUTPUT:

Populate Combobox Depending On Another Combobox In C#

Download Projects Source Code