Login and Registration Form in Asp Net Mvc With Database

Hi Friends!Today, i am going to make a CustomRegistration and Login Page.This is not a simple web form page.In this Form i have used many concepts.You can easily implement this concept to any where in .NET Application. In this application i have covered all things which is required in various Registration and Login Form in any  website.I am really saying to you,if you run this application on your computer then you will feel how much good it is.You can download this application from bottom and run on your visual studio.There are some controls which i have used in this application.

• Script Manager(Ajax)
• UpdatePannel(Ajax)
• RequiredFieldValidator
• RegularExpressionValidator
• Captcha Image
• Session
• Text Box
• Label and Button

There are some steps to make this application.Please follow this.

Step 1: First open your visual studio->File->New->website->ASP.NET Empty website->click OK.->Now open Solution Explorer->Add New Item-> Web form-> click Add.
Step 2: Now make a Registration page like this,which is given below.
see it:

Make this Registration Form in following ways:

• First put ScriptManager on your form.
• Create UserName-->Now put UpdatePanel-->Now put TextBox in UpdatePanel->Put RequiredFieldValidator.
• Password--> TextBox-->Now put RequiredFieldValidator.
• Retype Password-->TextBox-->Now put RequiredFieldValidator.
• Mobile Number-->TextBox-->Put RegularExpressionValidator &  RequiredFieldValidator
• Email Id -->TextBox-->Put RegularExpressionValidator and  RequiredFieldValidator.
• Captcha Image-->To know more here
• Enter Captcha Image-->TextBox-->Put Label and RequiredFieldValidator.

Now go propeties in every RegularExpressionValidator &  RequiredFieldValidator and set following fields which is given below:

Control To Validate -->Select TextBox which you want to validate. open this application on your visual studio and see all changes.This is more easy for you.

Step

 3: Now Add Database(.mdf) on your website.Open Solution Explorer -->Right click on website-->Add New Item-->Sql Server Database-->click Add.

Now if you are facing problem in adding database(.mdf) on Website,please here.

Step

 4: Now Double click  on Database.mdf --> Solution Exporer will open-->Right click on Tables -->Add New Table-->Now Enter the column name.
see it:

Step  5: Now double click on Submit Button and write the following code which is given below:

                      using System; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Drawing;  public partial class _Default : System.Web.UI.Page {     protected void TextBox1_TextChanged(object sender, EventArgs e)     {           SqlConnection con = new SqlConnection(@"Data Source=.\;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True;");         con.Open();         SqlCommand cmd = new SqlCommand("select*from regform where username='" + TextBox1.Text + "'", con);         SqlDataReader dr = cmd.ExecuteReader();          if (dr.Read())         {             Label1.Text = "User Name is Already Exist";             this.Label1.ForeColor = Color.Red;         }         else         {             Label1.Text = "UserName is Available";             this.Label1.ForeColor = Color.Red;         }         con.Close();     }     protected void  Button1_Click(object sender, EventArgs e) {     captcha1.ValidateCaptcha(TextBox6.Text.Trim());     if (captcha1.UserValidated)     {   //you can use disconnected architecture also,here i have used connected architecture.         SqlConnection con = new SqlConnection(@"Data Source=.\;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True;");         con.Open();        SqlCommand cmd = new SqlCommand("insert into regform values(@a,@b,@c,@d)",con);         cmd.Parameters.AddWithValue("a", TextBox1.Text);         cmd.Parameters.AddWithValue("b", TextBox2.Text);         cmd.Parameters.AddWithValue("c", TextBox4.Text);         cmd.Parameters.AddWithValue("d", TextBox5.Text);         cmd.ExecuteNonQuery();         Session["name"] = TextBox1.Text;         Response.Redirect("default.aspx");         con.Close();     }     else     {  Label2.ForeColor = System.Drawing.Color.Red;  Label2.Text = "You have Entered InValid Captcha Characters please Enter again";   }       }     }                  

Step

 6: Now create a New page and make a Login form which is give below:
see it:

Note->In this application  all( * )represents theLabel control.

Step

 7: Now Double click on Login Button and write the following codes which is given below:

                          using System; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Drawing;  public partial class login : System.Web.UI.Page {     protected void Button1_Click(object sender, EventArgs e)     {         SqlConnection con = new SqlConnection(@"Data Source=.\;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True;");         con.Open();         SqlCommand cmd = new SqlCommand("select COUNT(*)FROM regform WHERE username='" + TextBox1.Text + "' and password='" + TextBox2.Text + "'");         cmd.Connection = con;         int OBJ = Convert.ToInt32(cmd.ExecuteScalar());         if (OBJ > 0)         {             Session["name"] = TextBox1.Text;             Response.Redirect("default.aspx");         }         else         {             Label1.Text = "Invalid username or password";             this.Label1.ForeColor = Color.Red;         }     }     protected void LinkButton2_Click(object sender, EventArgs e)     {         Response.Redirect("Registration.aspx");     } }                      

Step

 8: Now Create a another page (Default.aspx)which is given below:
see it:

Step

 9: Now Double click on Pageand write the following codes  on Page load which is given below:

                          using System; using System.Web; using System.Web.UI; using System.Web.UI.WebControls;  public partial class _Default : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {         Label1.Text = Session["name"].ToString();     } }                      

Step

 10: Now Run the program(Press F5).
see it:

There are some points to see the Exact output of whole application.

1. If you are not part of this application then click New User Button.

   see it:

 2. When you will Enter UserName then this user name will check from database.if this name is available then it will show User Name is available otherwise show User Name is Already Exist.
see it:

3.  when you will Enter Password & ReType Password  Field ,if both Password are not matched then see it:

4. whenyou will Enter Mobile Number Field ,if Number is Not correct (according to India).you will see following output:

      5. If you will Enter Email Id Field and Email is not correct format then you will see following error.

6. when  you will enter wrongCaptcha code then you will see following output:

7. When you will enter all fields in Registration page correct then you will see following output:

Step

 11: Now you will see Rajesh has  entered Database(.mdf).
see student table:

Step

 12: Now you can directly Login  with correct Login Name and Password,which is present in Database(.mdf).
see it:

see output:-

Step 13 : You can add Change Password page in this page fromhere

Step14: You can add Forget password codes in this page from here

Step15: You can add send email service in this page from here

Step16 : You can build 3 Tier Registration and Login page from here.

Step 17 : You can create existing asp.net registration and login page esaily from here.

Step 18 : Youcan use cookie concepts in this page from here.

Step 19 :Youcan use caching concepts in this page from here.

Step 20 : You can create secure registration and login page with hashing in asp.net here.

Note- If you want to run this application on your system directly, without any changes then follow first two steps(1 to 2)  and other four steps(3 to 6),you can add extra features in your application which are given below:

1. First download this application form bottom and open this application to your visual studio 2010.
2. Now go Tools -->Options -->Database Tools -->Data connections -->Remove Sql Server Instance Name(blank for default) from right hand side-->click OK.
3. If you want ,you can implement Form Based authentication in this form for security purpose.
4. You can use different connection strings for your registration and loin page also from here. Such as store procedure,connected architecture,disconnected architecture parameterized connection etc.It will provide full security to your asp.net application.
5. This registration page is full secure,i have putted security codes also.

I hope this helpful for you.
Please share this page if this is helpful for you.

Download Whole Attached file

Login and Registration Form in Asp Net Mvc With Database

Source: https://www.msdotnet.co.in/2013/04/how-to-make-registration-and-login-form.html

Share :