Login with Email and Password and retrieve login user details using C# in ASP.Net

Hi micah,

I have created sample please check.

SQL

CREATE PROCEDURE [dbo].[Validat_UserTable]
      @Email NVARCHAR(20),
      @Password NVARCHAR(20)
AS
BEGIN
      SET NOCOUNT ON;
      DECLARE @UserId INT, @LastLoginDate DATETIME
      
      SELECT @UserId = ID, @LastLoginDate = LastLogin
      FROM Usertable WHERE [Email] = @Email AND [Password] = @Password
  
      IF @UserId IS NOT NULL
      BEGIN
            SELECT UserName 
            FROM Usertable
            WHERE ID = @UserId
      END
      ELSE 
      BEGIN
            SELECT 'Unknown'
      END
END
GO

CREATE PROCEDURE [dbo].[GetUSERPROFILE1]
    @UserName NVARCHAR(50)    
AS
BEGIN
 
    SELECT ID,Email,Name,Country,CONVERT(VARCHAR (20),RegisterDate, 106) RegisteredDate,CONVERT(VARCHAR (20),LastLogin, 106) LastLogin 
    FROM [Usertable]
    WHERE Name = @UserName
   
END

HTML

Login.aspx

<asp:Login ID="ctlLogin" runat="server" OnAuthenticate="OnAuthenticate" UserNameLabelText="Email ID">
</asp:Login>

Default.aspx (LandingPage)

<asp:GridView runat="server" ID="userprofile">
</asp:GridView>

Code

Login.aspx

protected void OnAuthenticate(object sender, AuthenticateEventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    string userName;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("Validat_UserTable"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Email", ctlLogin.UserName.Trim());
                cmd.Parameters.AddWithValue("@Password", ctlLogin.Password.Trim());
                cmd.Connection = con;
                con.Open();
                userName = cmd.ExecuteScalar().ToString();
                Session["UserName"] = userName;
                con.Close();
            }
            switch (userName)
            {
                case "Unknown":
                    ctlLogin.FailureText = "Username or password not correct.";
                    break;
                default:
                    Response.Redirect("~/Default.aspx");
                    break;
            }
        }
    }
}

Default.aspx (LandingPage)

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["UserName"] != null && Session["UserName"].ToString() != string.Empty)
    {
        string userName = Session["UserName"].ToString();
        GetProfile(userName);
    }
}

public void GetProfile(string userName)
{
    string str = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    string getADPOST = "GetUSERPROFILE1";
    using (SqlConnection con = new SqlConnection(str))
    {
        con.Open();
        using (SqlCommand cmd = new SqlCommand(getADPOST, con))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@UserName", userName);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable ds = new DataTable();
            da.Fill(ds);
            userprofile.DataSource = ds;
            userprofile.DataBind();
        }
    }
}

Screenshot