Simple Login Project in ASP.Net

Introduction

As we know on internet world without security we can not expect any thing. At least on every website we use to face such like to create account but as far we concern to learn how to create it then without any good guidelines we can't. Let's take a look on this article to create such project.

Perquisite

This article expect something from you as

1. You should know MS-SQL Server
2. You should have the basic knowledge of ASP.Net controls

Creating Database

To store the user's credentials for future login, we should have database. So, let's create it.

Database Name: myDb.mdf

Table Name: myTb

Column Names:

Creating Database Configuration in web.config file

To create database configuration in web.config file, simply drag the 'myTb' table from Database Explorer on any form and now delete the dragged item from web page, it will create the configuration settings for your database in web.config file automatically.



Here is your configuration in web.config file

<connectionStrings>
<add name="myDbConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myDb.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

Create User Form Designing

To create or register new user we should have a form as given below. You can ignore the side links, top banner and footer texts because they are occurring from master page.

To call for the database configuration setting from web.config file I have used a function

public string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["myDbConnectionString1"].ConnectionString;
}

I have used a execute named function in code behind to perform the insertion task when 'Create User' named button clicked

private void execution(string name, string username, string password, string emailid)
{
SqlConnection conn = new SqlConnection(GetConnectionString());
string sql = "INSERT INTO myTb (name, username, password, emailid) VALUES "
+ " (@name, @username, @password, @emailid)";
try
{
conn.Open();

SqlCommand cmd = new SqlCommand(sql, conn);
SqlParameter[] pram = new SqlParameter[4];

pram[0] = new SqlParameter("@name", SqlDbType.VarChar, 50);
pram[1] = new SqlParameter("@username", SqlDbType.VarChar, 50);
pram[2] = new SqlParameter("@password", SqlDbType.VarChar, 50);
pram[3] = new SqlParameter("@emailid", SqlDbType.Char, 10);

pram[0].Value = name;
pram[1].Value = username;
pram[2].Value = password;
pram[3].Value = emailid;

for (int i = 0; i < pram.Length; i++)
{
cmd.Parameters.Add(pram[i]);
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex_msg)
{
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
}

Finally I have used to following code in 'Create User' button click event. In this event we have to check the database for the duplication. Because in login project duplications are never assumed even. If there is no any duplication found in code behind will create a new account. Here it is

protected void create_Click(object sender, EventArgs e)
{
SqlDataSource sds = new SqlDataSource();
sds.ConnectionString = ConfigurationManager.ConnectionStrings["myDbConnectionString1"].ToString();