Remember Username and Password using Remember me checkbox during login in asp.net | ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

Remember Username and Password using Remember me checkbox during login in asp.net

Introduction: In this article I will epxlain how we can remember USERNAME and PASSWORD using Remember me checkbox during login in asp.net.
Remember Username and Password

Description:
I created a Table USER_REGISTRATION:
ID
int
USERNAME
varchar(50)
PASSWORD
varchar(50)
FIRST_NAME
varchar(50)
LAST_NAME
varchar(50)
SEX
varchar(50)
EMAIL_ID
varchar(50)

Here ID is autoincrement and primary key. Registers user detail/information store in table and check the username and password detlais on login page.
Add a new webform to project. Drag and drop the control from Toolbox and desgin the .aspx page as shown below:
<table align="center">
    <tr><td>Username:-</td><td>
        <asp:TextBox ID="txtusername" runat="server"></asp:TextBox></td></tr>
        <tr><td>&nbsp;</td></tr>
        <tr><td>Password:-</td><td>
            <asp:TextBox ID="txtpassword" TextMode="Password" runat="server"></asp:TextBox></td></tr>
             <tr><td>&nbsp;</td></tr>
            <tr><td>Remeber me</td><td>
                <asp:CheckBox ID="CheckBox1" runat="server" /></td></tr>
                <tr><td>&nbsp;</td><td>
                <asp:Button ID="btnlogin" runat="server" Text="Login"
                    onclick="btnlogin_Click" /></td></tr>                
                </table>

Now write the below given code on .aspx.cs page:
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.Cookies["USERNAME"] != null && Request.Cookies["PASSWORD"] != null)
            {
                txtusername.Text = Request.Cookies["USERNAME"].Value;
                txtpassword.Attributes["value"] = Request.Cookies["PASSWORD"].Value;
            }
        }
    }
    protected void btnlogin_Click(object sender, EventArgs e)
    {
        try
        {
            string query = "select * from USER_REGISTRATION where USERNAME = @USERNAME and PASSWORD = @PASSWORD";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.Parameters.AddWithValue("@USERNAME", txtusername.Text);
            cmd.Parameters.AddWithValue("@PASSWORD", txtpassword.Text);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                if (CheckBox1.Checked)
                {                  
                    Response.Cookies["USERNAME"].Expires = DateTime.Now.AddDays(30);
                    Response.Cookies["PASSWORD"].Expires = DateTime.Now.AddDays(30);
                }
                else
                {
                    Response.Cookies["USERNAME"].Expires = DateTime.Now.AddDays(-1);
                    Response.Cookies["PASSWORD"].Expires = DateTime.Now.AddDays(-1);
                }
                Response.Cookies["USERNAME"].Value = txtusername.Text.Trim();
                Response.Cookies["PASSWORD"].Value = txtpassword.Text.Trim();
                Response.Redirect("Welcome.aspx");
            }
            else
            {
                Messagebox("USERNAME/PASSWORD DOES NOT EXIST");
            }
        }
        catch (Exception ex)
        {
        }

    }
    private void Messagebox(string Message)
    {
        Label lblMessageBox = new Label();

        lblMessageBox.Text =
            "<script language='javascript'>" + Environment.NewLine +
            "window.alert('" + Message + "')</script>";
        Page.Controls.Add(lblMessageBox);
    }

In VB (.aspx.vb)
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

  Private con As New SqlConnection(ConfigurationManager.ConnectionStrings("Connection").ToString())
    Protected Sub btnlogin_Click(sender As Object, e As System.EventArgs) Handles btnlogin.Click
        Try
            Dim query As String = "select * from USER_REGISTRATION where USERNAME = @USERNAME and PASSWORD = @PASSWORD"
            Dim cmd As New SqlCommand(query, con)
            cmd.Parameters.AddWithValue("@USERNAME", txtusername.Text)
            cmd.Parameters.AddWithValue("@PASSWORD", txtpassword.Text)
            Dim adp As New SqlDataAdapter(cmd)
            Dim dt As New DataTable()
            adp.Fill(dt)
            If dt.Rows.Count > 0 Then
                If CheckBox1.Checked Then
                    Response.Cookies("USERNAME").Expires = DateTime.Now.AddDays(30)
                    Response.Cookies("PASSWORD").Expires = DateTime.Now.AddDays(30)
                Else
                    Response.Cookies("USERNAME").Expires = DateTime.Now.AddDays(-1)
                    Response.Cookies("PASSWORD").Expires = DateTime.Now.AddDays(-1)
                End If
                Response.Cookies("USERNAME").Value = txtusername.Text.Trim()
                Response.Cookies("PASSWORD").Value = txtpassword.Text.Trim()
                Response.Redirect("Welcome.aspx")
            Else
                Messagebox("USERNAME/PASSWORD DOES NOT EXIST")
            End If
        Catch ex As Exception
        End Try
    End Sub

    Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
            If Request.Cookies("USERNAME") IsNot Nothing AndAlso Request.Cookies("PASSWORD") IsNot Nothing Then
                txtusername.Text = Request.Cookies("USERNAME").Value
                txtpassword.Attributes("value") = Request.Cookies("PASSWORD").Value
            End If
        End If
    End Sub
    Private Sub Messagebox(Message As String)
        Dim lblMessageBox As New Label()

        lblMessageBox.Text = "<script language='javascript'>" + Environment.NewLine & "window.alert('" & Message & "')</script>"
        Page.Controls.Add(lblMessageBox)
    End Sub


Run the project and check the result.

Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget