BestCloudHostingASP.NET | Best and affordable ASP.NET Hosting. Today I will share tutorial about how to creating registration and login page in ASP.NET ??? Ok Let me to show you.

• We first open Visual Studio 2013 as administrator and create a new website. Create using File -> New -> Website. From the Visual C#  tab select the ASP.NET Empty Web Site and click on the OK button.
• After creating the website the next step is to add a web form to this website. Right-click on the website and add a Web Form to the website.
• In the Design page we have used three labels, three textboxes and two buttons. One is for the Registration and the other one is for the Login. Now provide the name of labels and buttons, depending on your requirements.
• Now create the table into the SQL Server database and take the three fields. The fields are username, password and email fields. The code looks as in this:

create table registration  
(  
   Username varchar(100),  
   Email varchar(100),  
   Password varchar(20)  
)

 Stored Procedure for the table:

    create procedure [dbo].[strlogin]  
    (  
       @username varchar(40),  
       @email varchar(50),  
       @password varchar(20)  
    )  
    as  
    insert into registration values(@username,@email,@password )

 We now double-click on the button and use the following code:

protected void Button1_Click(object sender, EventArgs e)  
{  
    string strcon = "Data Source=.;uid=sa;pwd=Password$2;database=roham";  
    SqlConnection con = new SqlConnection(strcon);  
    SqlCommand com = new SqlCommand("CUser", con);  
    com.CommandType = System.Data.CommandType.StoredProcedure;  
    SqlParameter p1 = new SqlParameter("username", TextBoxusername.Text);  
    SqlParameter p2 = new SqlParameter("password", TextBoxpassword.Text);  
    com.Parameters.Add(p1);  
    com.Parameters.Add(p2);  
    con.Open();  
    SqlDataReader rd = com.ExecuteReader();  
    if (rd.HasRows)  
    {  
        rd.Read();  
        Label3.Text = "Login successful.";  
        Label3.Visible = true;  
    }  
    else  
    {  
        Label3.Text = "Invalid username or password.";  
        Label3.Visible = true;  
    }  
}

For login we create an another webform and now right-click on the website.
Add a new form and provide the name, whatever you want.

Now create a Stored Procedure for the login page as in the following:

    create PROCEDURE CUser  
    (  
       @username as varchar(50),  
       @password as varchar(50)  
    )  
    SELECT * FROM registrationtab WHERE username=@username AND password=@password

 Now we double-click on the login button and write the following code:

protected void Button1_Click(object sender, EventArgs e)  
{  
    string strcon = "Data Source=.;uid=sa;pwd=Password$2;database=roham";  
    SqlConnection con = new SqlConnection(strcon);  
    SqlCommand com = new SqlCommand("CUser", con);  
    com.CommandType = System.Data.CommandType.StoredProcedure;  
    SqlParameter p1 = new SqlParameter("username", TextBoxusername.Text);  
    SqlParameter p2 = new SqlParameter("password", TextBoxpassword.Text);  
    com.Parameters.Add(p1);  
    com.Parameters.Add(p2);  
    con.Open();  
    SqlDataReader rd = com.ExecuteReader();  
    if (rd.HasRows)  
    {  
        rd.Read();  
        Label3.Text = "Login successful.";  
        Label3.Visible = true;  
    }  
    else  
    {  
        Label3.Text = "Invalid username or password.";  
        Label3.Visible = true;  
    }  
}

 Now run the application by pressing the F5 key.

I hope this article is helpful for the readers that want to simply create a registration and login page in ASP.NET. Thanks for reading this article, I hope you like it.

Happy Coding

TOP 3 Recommendation Best ASP.NET 5 Hosting