Login System in C# and SQL Server 2005

In this tutorial, I will teach you how to create a Login System in C#.net and SQL server 2005. This is a cool and simple Login System that could help you secure your system from invaders. It covers features that would make the login system user-friendly and contains step by step guide that is so easy to follow. So, in the future, you will know how to build an application that features a login system.

But if you want to start how to code using visual studio 2019, you can start your lesson here on how to connect Mysql to visual Studio 2019.

Let’s get started:

Create a database and name it “employeedb”.

After creating the database, open Microsoft Visual Studio and create new Windows Form Application. Then do the following design of a Form as shown below.

Go to the Solution Explorer, double click the “View Code”  to display the code editor.

Note: Put using System.Data.SqlClient; above the namespace to access sql server library.

In the code editor, declare all the classes and variables that are needed.

  //initialize all classes
 SqlConnection conn = new SqlConnection();
 SqlCommand cmd = new SqlCommand();
 SqlDataAdapter da = new SqlDataAdapter();
 DataTable dt = new DataTable();

 //declaring variables
 string query;
 int result, maxrow;

After declaring the classes and variables, establish a connection between SQL server 2005 and C#.net in the first load of the Form.

private void Form1_Load(object sender, EventArgs e)
 {
 //set a connection between SQL server and Visual C#
 conn.ConnectionString = "Data Source=.\\SQLEXPRESS;database=employeedb;trusted_connection=true;";
 }

After that, go back to the design view, double click the button and do the following code in the method.

 private void btnLogin_Click(object sender, EventArgs e)
 {
 try
 {
 conn.Open();
 //create a query for retrieving data in the database.
 query = "SELECT * FROM tbluser WHERE UNAME='" + txtUsername .Text + "' and PASS='" + txtPassword .Text +"'";
 //initialize new Sql commands
 cmd = new SqlCommand();
 //hold the data to be executed.
 cmd.Connection = conn;
 cmd.CommandText = query;
 //initialize new Sql data adapter
 da = new SqlDataAdapter();
 //fetching query in the database.
 da.SelectCommand = cmd;
 //initialize new datatable
 dt = new DataTable();
 //refreshes the rows in specified range in the datasource. 
 da.Fill(dt);
 //getting the total row in the table.
 maxrow = dt.Rows.Count;
 //validating the total rows in the table
 if (maxrow > 0)
 {
 //popup message
 MessageBox.Show("Welcome " + dt.Rows[0].Field<string>("UROLE"));
 //disable the group box.
 groupBox1 .Enabled = false ;
 //store the value in the linklabel
 lblGuest.Text = "Hello " + dt.Rows[0].Field<string>("NAME") + " Logout";
 //clearing textboxes
 txtPassword.Clear();
 txtUsername.Clear();
 }
 else
 {
 //when account does not exist, it will display this message.
 MessageBox.Show("Account does not exist.");
 }


 }
 catch (Exception ex)
 {
 //catching error
 MessageBox.Show(ex.Message);
 }
 finally
 {
 da.Dispose(); 
 conn.Close();
 }
 }

Do the following method for the logout of the “Login” system.

 private void lblGuest_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
 {
 //logout process..
 //the form will return to the Guest view.
 lblGuest.Text = "Hello Guest!";
 groupBox1.Enabled = true;
 txtPassword.Clear();
 txtUsername.Clear();
 }

Finally, do the following method for the “close” button.

 private void btnClose_Click(object sender, EventArgs e)
 {
 //closing the form.
 this.Close();
 }

Output:

For Inquiries

If you have any questions or suggestions about this System, please leave a comment below.

For all students who need a programmer for your thesis system or anyone who needs a sourcecode in any programming languages. You can contact me @ :
Email – [email protected]
Mobile No. – 09305235027 – tnt

Download the Login System in C# and SQL Server 2005 Full source code below

Download Sourcecode