.jpg)
How to create Login Page in Asp.net with Connected Mode……………………………
// create database test………………………
Create database test
Use test
// create table LoginTable in database test………………………
create table LoginTable ( EmailId nvarchar(50) primary key,Password nvarchar(50),LoginTime nvarchar(50),Role nvarchar(50),Status nvarchar(50) ,SQues nvarchar(50),SAns nvarchar(50))
<%@ Page Title="Login Page"
Language="C#"
MasterPageFile="~/Main.master"
AutoEventWireup="true"
CodeFile="Login.aspx.cs"
Inherits="Login"
%>
<asp:Content ID="Content1"
ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
<table style="width: 100%">
<tr>
<td>
</td>
<td colspan="2">
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label5" runat="server" Font-Bold="True" Text="EmailId"></asp:Label>
</td>
<td colspan="2">
<asp:TextBox ID="txtemailid" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtemailid" ErrorMessage="Please enter emailid"
SetFocusOnError="True" ValidationGroup="g1" ForeColor="Red">*</asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
ControlToValidate="txtemailid" ErrorMessage="not valid format"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
ValidationGroup="g1" ForeColor="Red">*</asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label7" runat="server" Font-Bold="True" Text="Password"></asp:Label>
</td>
<td colspan="2">
<asp:TextBox ID="txtpassword" runat="server" TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtpassword" ErrorMessage="Please enter password"
ValidationGroup="g1" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="height: 27px">
</td>
<td style="height: 27px">
<asp:Button ID="Button2" runat="server" Height="25px" onclick="Button1_Click"
Text="Login" ValidationGroup="g1" />
</td>
<td style="height: 27px">
<asp:HyperLink ID="HyperLink3" runat="server" NavigateUrl="~/Regitration.aspx">Sign Up</asp:HyperLink>
</td>
</tr>
<tr>
<td colspan="3" style="height: 27px">
<center>
<asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">Forget Password</asp:LinkButton>
</center>
</td>
</tr>
<tr>
<td colspan="3" style="height: 27px" align="center">
<asp:Label ID="Label17" runat="server" Visible="False" ForeColor="Red"></asp:Label>
</td>
</tr>
<tr>
<td>
</td>
<td colspan="2">
<asp:ValidationSummary ID="ValidationSummary1" runat="server"
ForeColor="Red"
/>
</td>
</tr>
</table>
</asp:Content>
// this code for
web configuration file …………………
<configuration>
<connectionStrings>
<add name="kush" connectionString="Data Source=KUSH-PC\KUSH;Initial
Catalog=SocialNet;Integrated Security=True"/>
</connectionStrings>
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;
using System.IO;
using System.Web.Security;
public partial class Login :
System.Web.UI.Page
{
SqlConnection
con;
SqlCommand
cmd;
SqlDataReader
dr;
protected void Page_Load(object
sender, EventArgs e)
{
con = new
SqlConnection(ConfigurationManager.ConnectionStrings["kush"].ConnectionString);
}
protected void Button1_Click(object
sender, EventArgs e)
{
try
{
cmd = new
SqlCommand("select
EmailId,Password,Status from LoginTable where EmailId=@EmailId and Password=
@Password", con);
cmd.Parameters.AddWithValue("@EmailId", txtemailid.Text);
cmd.Parameters.AddWithValue("@Password", txtpassword.Text);
con.Open();
dr = cmd.ExecuteReader();
if
(dr.Read())
{
if
(dr["Status"].ToString() == "True")
{
Session["email"] = dr["EmailId"];
FormsAuthentication.RedirectFromLoginPage("a", false);
Response.Redirect("UserHome.aspx");
}
else
{
Label17.Visible = true;
Label17.Text = "Your Account is not active";
}
}
else
{
Label17.Visible = true;
Label17.Text = "EmailId and
Password is not match Please try
again...........";
}
}
catch (Exception ex)
{
Label17.Visible = true;
Label17.Text = ex.Message;
}
}
protected void LinkButton1_Click(object
sender, EventArgs e)
{
Session["email"]
= txtemailid.Text;
Response.Redirect("ForgetPassword.aspx");
}
}
