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

The link to your reply is wrong. It doesn't point to my with question 

Yes you can login with Email, UserName, Phone. But this should be unique for each user. After login fetch the record by the login details.

Please any example? 

Change your procedure like below. As you have done in your code you have to do like that only. But in place of userName you have to use either email/phoneno with password. After successfully login fetch the record as per your requirement by calling the GetProfilemethod like below.

SQL

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

Code

Login Page

protected void OnAuthenticate(object sender, AuthenticateEventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    int UserID;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("Validate_User"))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.CommandType = CommandType.StoredProcedure;
                Session["Email"] = ctlLogin.UserName;
                cmd.Parameters.AddWithValue("@Email", ctlLogin.UserName);
                cmd.Parameters.AddWithValue("@Password", ctlLogin.Password);
                cmd.Connection = con;
                con.Open();
                UserID = Convert.ToInt32(cmd.ExecuteScalar());
                con.Close();
            }
            switch (UserID)
            {
                case -1:
                    ctlLogin.FailureText = "Username or password not correct.";
                    break;
                case -2:
                    ctlLogin.FailureText = "Account has not been activated.";
                    break;
                case -3:
                    ctlLogin.FailureText = "Your Password.";
                    break;
                default:
                    Response.Redirect("~/Default.aspx?Email=" + Session["Email"].ToString());
                    break;
            }
        }
    }
}

Landing Page

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

public void GetProfile(string email)
{
    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("@Email", email);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable ds = new DataTable();
            da.Fill(ds);
            userprofile.DataSource = ds;
            userprofile.DataBind();
        }
    }
}