Hi kankon,
Refer below code.
HTML
Home
<div>
Welcome<asp:LoginName ID="LoginName1" runat="server" Font-Bold="true" />
<br /><br />
<asp:Label ID="lblEmail" runat="server" />
<asp:Label ID="lblLastLoginDate" runat="server" />
<asp:LoginStatus ID="LoginStatus1" runat="server" />
</div>
Code
Home
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.User.Identity.IsAuthenticated)
{
FormsAuthentication.RedirectToLoginPage();
}
else
{
string name = this.Page.User.Identity.Name;
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Users WHERE Username = @Name"))
{
cmd.Parameters.AddWithValue("@Name", name);
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
lblLastLoginDate.Text = dt.Rows[0]["LastLoginDate"].ToString();
lblEmail.Text = dt.Rows[0]["Email"].ToString();
}
}
}
}
}
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.Page.User.Identity.IsAuthenticated Then
FormsAuthentication.RedirectToLoginPage()
Else
Dim name As String = Me.Page.User.Identity.Name
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand("SELECT * FROM Users WHERE Username = @Name")
cmd.Parameters.AddWithValue("@Name", name)
Using sda As SqlDataAdapter = New SqlDataAdapter()
cmd.Connection = con
sda.SelectCommand = cmd
Using dt As DataTable = New DataTable()
sda.Fill(dt)
lblLastLoginDate.Text = dt.Rows(0)("LastLoginDate").ToString()
lblEmail.Text = dt.Rows(0)("Email").ToString()
End Using
End Using
End Using
End Using
End If
End Sub
Rest code will remain same as in the sample.