How to create ASP.NET Registration Form Using C# and SQL Server Database

.In this tutorial, we will explain how to create an ASP.NET Registration form using C# and SQL Server database. So if you want to implement a simple signup functionality on your website, then this tutorial is going to help you. Also, check out our latest tutorial on how to create an ASP.NET login page.

The logic behind the ASP.NET Registration form:

There is no rocket science involved here – users will simply enter their details like email, first name, last name, and other information about the registration form. After that, they will click on a button to register themselves on your site.

What happens when the code runs:

Users will enter their details in the user registration form and hit the Register button. After that, a connection to the database will be established, and a SQL Insert query will be executed to store all user inputs in the user details table.

Here is the breakdown of the complete process:

1. Creating an empty ASP.NET website.

2. Designing the user registration form.

3. Adding a SQL database to the project in which we will create a table to store user details.

4. Configuring web.config file.

5. Code the backend of the user registration form.

6. Try and test the application.

Also Read:

• Android WebView Tutorial with an example project.
• Android keyboard app to autocorrect grammar while typing.

Now, let’s begin and create an ASP.NET registration form.

1. Create an empty ASP.NET website.

Step 1: Open Visual Studio and hit the Control+Shift+N shortcut and select ASP.NET Empty Web Site from the dialog box, as shown below.

Step 2: After that, Visual Studio will create the project for you. Now, you need to add a web form to your project. Press Control+Shift+A hotkey to open the Add New Item dialog box and select Web Form (Visual C#) from the options. Once done, click on the Add button.

2. Design the ASP.NET Registration form.

After adding the web form, switch to the Design tab, and create a registration form, as shown in the screenshot above. You just have to drag and drop the elements from the Toolbox. If you feel lazy, then download the code from the link provided at the end of this tutorial.

3. Add a SQL Server database and create a table.

Step 1: Hit the Control+Shift+A shortcut and select the SQL Server Database option. After that, Visual Studio will prompt you to create an App_Data folder within your project, accept it, and open the Server Explorer box. Now, you have added a database to your ASP.NET website.

Step 2: From the Server Explorer, right-click on the Tables and select the Add New Table option, as shown in the screenshot below.

Step 3: Now, you will see the table designing interface, as shown below.

Simply specify the user attributes and their respective data types that you want to store within the table. After that, click on the Update button. Now, you will see the generated script to update the database, as shown below. Click on the Update Database button to create your table.

4. Configure Web.config file.

Open Web.config file from the Solution Explorer and paste the connection string of your database in the following format within the <configuration></configuration> tags. Do not add the <connectionStrings> inside any other tag.

<connectionStrings> 
<add name="dbconnection" connectionString="Paste your DB connection string here"/> 
</connectionStrings>

To get the connectionString of your database, open Server Explorer and right-click on it. Select the Properties option. Now, from the Properties box, copy the Connection String of your database and paste it at the specified place in the code snippet.

5. Write the C# code to register the user.

Now, open the C# (aspx.cs) file of your ASP.NET registration form and paste the code into the button click event, as demonstrated in the code snippet below.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page 
{ 
    protected void Page_Load(object sender, EventArgs e) 
    { 
    } 
    protected void Register_Click(object sender, EventArgs e) 
    { 
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString); 
        con.Open(); 
        SqlCommand cmd = new SqlCommand("insert into RegistrationTable values (@FirstName, @LastName, @Email, @MobileNumber, @Password)", con); 
        cmd.Parameters.AddWithValue("FirstName", FnameTxt.Text); 
        cmd.Parameters.AddWithValue("LastName", LnameTxt.Text); 
        cmd.Parameters.AddWithValue("Email", Email.Text);
        cmd.Parameters.AddWithValue("MobileNumber", MobileNumber.Text); 
        cmd.Parameters.AddWithValue("Password", Password.Text); cmd.ExecuteNonQuery(); 
        Label7.Visible = true; 
        Label7.Text = "User registered successfully"; 
        FnameTxt.Text = ""; 
        LnameTxt.Text = ""; 
        Email.Text = ""; 
        MobileNumber.Text = ""; 
        Password.Text = ""; 
        FnameTxt.Focus();
    } 
}

6. Testing the ASP.NET Signup form.

Debug your ASP.NET site and enter the details in the user registration form, as shown in the main screenshot. After that, click on the Register button. If you get any SQL Exception in Visual Studio, then probably check out the table or the C# code. And if everything goes perfectly, you will see this message ‘User registered successfully.’ You can also check if the code worked or not from the user details table data, as shown below.

Closing words:

We hope that this tutorial will help you easily create a simple ASP.NET registration form using C# and SQL Server database. Down the line, we will create different versions of this tutorial or update it and make this ASP.NET SignUp form smarter by applying JavaScript code to verify user input values so that no wrong or dummy value gets stored in the database.

If you come across any issue, then feel free to contact us or leave your comment below.

Download ASP.NET registration form code files from our GitHub repository.

Are you having trouble with GitHub? We have also hosted the complete project on Google Drive.