Creating Login Form In ASP.NET

Brajesh Kumar

23 Comments

Join the conversation! Your thoughts help the community grow.

Brajesh Kumar9y ago
Http://www.c-sharpcorner.com/blogs/login-form-in-angularjs-and-asp-net-mvc
Pravas Ranjan9y ago
Hi Kumar once you post the article please share me the link thanks again Bhai.......
- Brajesh Kumar9y ago
  Hello Pravas Biswal I have posted my new post on angular js -----------------http://www.c-sharpcorner.com/blogs/login-form-in-angularjs-and-asp-net-mvc -----your feedback is always welcome and valuable.
- Pravas Ranjan9y ago
  Thank you so much Kumar..
Pravas Ranjan9y ago
Hello Kumar, i will definitely wait for your new upcoming article on Angular JS and MVC CRUD operation with bootstrap and one thing please make this article as simple as possible so that it can be very easy to understand for beginner as well as experience professional prospective ..... Thanks again Kumar for this nice and easy article......
- Brajesh Kumar9y ago
  Sure Pravas soon i am going to post an article on Angular and will try to make as simple as i can.your feedbacks are always welcome.
garima kumari9y ago
Thanks @Brajesh keep posting article like this .Eagerly waiting for your next angular post.Great and simple
- Brajesh Kumar9y ago
  Thanks Garima for your great complement.i will definitely post a article on angular
Anmol Chaudhary9y ago
Hi pravas biswal i think 1. You can use the Oracle data provider that comes with Microsoft, but I recommend using ODP.Net. It's best to use native libraries when possible since they are usually optimized better, at least in my experience. 2. You only need to configure the tnsnames.ora on the server, because the server is what's going to be handling the DB connections, not the client PCs (assuming that this is a MVC website).
- Brajesh Kumar9y ago
  Thanks Priceless for your feedback
- Pravas Ranjan9y ago
  Thanks the issue has been sorted out thank you friend for your kind help here....
Pravas Ranjan9y ago
I am not using Sql server i am using Oracle and fetching db details from web.config please sugest
- Anmol Chaudhary9y ago
  Pleasure will be always mine Pravas
- Brajesh Kumar9y ago
  Hello Pravas Can you please tell me something about your project like you are using Asp.Net Webforms or .Net MVC Entity framework You can Go through following links i think it will help you : 1.https://docs.oracle.com/cd/B28359_01/appdev.111/b28844/using_aspnt.htm#TDPNG00000 2.https://www.codeproject.com/tips/421105/using-oracle-with-entityframework
- Pravas Ranjan9y ago
  Hello Kumar thank you so much for your help and suggestion the issue has been sorted out that issue was with configuration
Pravas Ranjan9y ago
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Pravas Ranjan9y ago
Kumar i am using Oracle Database and it is in another server and when i am running my application getting below error can you please tell me where is the problem
Pravas Ranjan9y ago
Keep posting Article like this.................
- Brajesh Kumar9y ago
  Thanks for your valuable feedback
Pravas Ranjan9y ago
Hello Kumar Excellent Article but can you please add same topic using Angular JS and MVC with bootstrap...
- Brajesh Kumar9y ago
  Sure as per you request i will definitely post same topic using angular js
Satyaprakash Samantaray9y ago
Put some screen shots as well as some output result for end user's better understanding....
- Brajesh Kumar9y ago
  Thanks for your valuable feedback .i will definately put some Screen shot

Today, we are going to make a login page, just another simple web form. You can easily implement this concept anywhere in .NET applications. I have used some controls to build the login form in a .NET application.

Text Box
Label and Button

Please follow these steps to make this application.

Step 1

First, open your Visual Studio -> File -> New -> Website -> ASP.NET Empty website and click OK. Now, open Solution Explorer and go to Add New Item -> Web form -> click Add.

Step 2

Now, make a Login page like the one given below.

.aspx or design page (front-end)

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Login Form</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td> Username: </td>
<td>
<asp:TextBox ID="txtUserName" runat="server" />
<asp:RequiredFieldValidator ID="rfvUser" ErrorMessage="Please enter Username" ControlToValidate="txtUserName" runat="server" /> </td>
</tr>
<tr>
<td> Password: </td>
<td>
<asp:TextBox ID="txtPWD" runat="server" TextMode="Password" />
<asp:RequiredFieldValidator ID="rfvPWD" runat="server" ControlToValidate="txtPWD" ErrorMessage="Please enter Password" /> </td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="btnSubmit" runat="server" Text="Submit" /> </td>
</tr>
</table>
</div>
</form>
</body>
</html>

Now, create an event for click button, such as - onclick="<>".

onclick="btnSubmit_Click"

So, our button tag will be like <asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" />. And in login.aspx.cs page, we need to write the following code.

C# Code --Code behind(Aspx.cs)

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

After adding the namespaces, write the following code in code behind.

protected void btnSubmit_Click(object sender, EventArgs e) {
SqlConnection con = newSqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("select * from UserInformation where UserName =@username and Password=@password", con);
cmd.Parameters.AddWithValue("@username", txtUserName.Text);
cmd.Parameters.AddWithValue("@password", txtPWD.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0) {
Response.Redirect("Details.aspx");
} else {
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Invalid Username and Password')</script>");
}
}

Now, for connecting it with the database, write the database connection string like the following.

Web Config

<connectionStrings>
<add name="dbconnection" connectionString="Data Source=BrajeshKr;Integrated Security=true;Initial Catalog=MyDB" /> </connectionStrings>

That's it. Now, our Login page is ready to be executed. You can download the code for this application and run that on your Visual Studio.