using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;

public partial class f1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        cc2(sender, e);
    }
    protected void cc2(object sender1, EventArgs e)
    {
        SqlConnection con;
        SqlCommand checkuser2;
        string cmdsg2, name, name1;
        name = Session["new5"].ToString();
        Label2.Text = name;
        con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        con.Open();
        cmdsg2 = "Select Email from registration where UserName='" + name + "'";
        checkuser2 = new SqlCommand(cmdsg2, con);
        name1 = checkuser2.ExecuteScalar().ToString();
        Label3.Text = name1;
        cmdsg2 = "Select Country from registration where UserName='" + name + "'";
        checkuser2 = new SqlCommand(cmdsg2, con);
        name1 = checkuser2.ExecuteScalar().ToString();
        Label4.Text = name1;
        con.Close();
        }
}