---
title: "How To Create Login Form in CSharp .NET"  
description: "First of all we have to design a table in database in order to store the user and password of the entire user who can log on to our application having"  
author: "Anonymous User"  
published: 2010-07-22  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/67/how-to-create-login-form-in-csharp-dot-net  
category: "c#"  
tags: ["c#"]  
reading_time: 2 minutes  

---

# How To Create Login Form in CSharp .NET

First of all we have to design a table in database in order to store the user and password of the entire user who can log on to our application having at least two entities ‘username’ and ‘password’ , here my database name is ‘Employee’ and table name is ‘login’.

Our next step is to design login form.

![How To Create Login Form in CSharp .NET](https://www.mindstick.com/mindstickarticle/543d4dea-c228-4fbc-a2af-2239a4a6db2d/images/ad83ab97-8904-44e7-b1fe-6512519be28f.png)

Set the password text box ‘password char’ to ‘*’.

Now, once the login form and tables are designed our next step is to design the code for the login form.

##### Coding

```
        Boolean log = false; //Assigning public variable log of type Boolean to set property of this from//in order to access it from  other form.         public Login()        {            InitializeComponent();        }               private void btnCancel_Click(object sender, EventArgs e)        {            Application.Exit();        } //Application will exit if cancel button is clicked.         public void fnlogin()        { //Function for login             try            { //Managing connection to the database                 string sqlString = "Server=abc\\SQLEXPRESs;Database=Employee;Trusted_Connection=True";                SqlConnection con = new SqlConnection(sqlString);                con.Open();                SqlCommand cmd = new SqlCommand("select UserName, Password from login whereUserName='" + txtUserName.Text.Trim() + "' and Password='" + txtPassword.Text.Trim() + "'", con); //Fetching only those records from the table which matches with the record//in the text field in the login form.                SqlDataReader rdr = cmd.ExecuteReader();                if (rdr.HasRows)                { //checking whether datareader contains any rows or not. If the condition//is true then the code below will be executed otherwise code in else//block will be executed.                     while (rdr.Read())                    {  //Reading all records fetched, one by one and matching with the user name//and password entered by user, in order to overcome small and upper caps//complexities in user name and password.                        if (rdr[0].ToString().ToUpper() ==txtUserName.Text.Trim().ToUpper() && txtPassword.Text==rdr[1].ToString())                        {                            log= true;                            this.Close();                        }                        else                        {//If username or password provider by the user are incorrect then//following message will be displayed.                            MessageBox.Show("User Name or Password incorrect!!!");                            txtUserName.Text= "";                            txtPassword.Text= "";                            txtUserName.Focus();                            log= false;                        }                    }                                                 }                else                {                    MessageBox.Show("User Name or Password incorrect!!!");                    txtUserName.Text = "";                    txtPassword.Text = "";                    txtUserName.Focus();                    log = false;                }            }            catch (Exception ex)            {                MessageBox.Show(ex.Message);            }        }        private void btnLogin_Click(object sender, EventArgs e)        {            fnlogin();                   }         private void txt_KeyPress(object sender, KeyPressEventArgs e)        {//Checking whether enter key is pressed in text boxes or not.            if (e.KeyChar == (char)13)                fnlogin();        } //Setting property of this form in order to use it in another form//so as to get the information whether the login was successful or not.        public Boolean pLog        {            get            {                return log;            }            set            {                log = value;            }        }
```

Screen Shot

![How To Create Login Form in CSharp .NET](https://www.mindstick.com/mindstickarticle/543d4dea-c228-4fbc-a2af-2239a4a6db2d/images/f3fdc8ca-f007-4266-a1a0-9932fa365c14.png)

Message displayed if username and password provider are incorrect.

---

Original Source: https://www.mindstick.com/articles/67/how-to-create-login-form-in-csharp-dot-net

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.