Remember Username and Password using Remember me checkbox during login in asp.net - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework 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.

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon