Display Logged in user details from another table and display fullname in ASP.Net

Hi rishidevmsb,

Please share the code you have tried to logged in.

Or which code you are refering please share.

C#

Default

protected void Login(object sender, EventArgs e)
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT Origin FROM Users WHERE Username = @UserName AND Password = @Password", con))
        {
            cmd.Parameters.AddWithValue("@Username", txtUserName.Text.Trim());
            cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());
            con.Open();
            string origin = Convert.ToString(cmd.ExecuteScalar());
            con.Close();
            if (!string.IsNullOrEmpty(origin))
            {
                Session["Origin"] = origin;
                Response.Redirect("Home.aspx");
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Invalid UserName or Password.')", true);
            }
        }
    }
}

Home

protected void Page_Load(object sender, EventArgs e)
{
    if(!this.IsPostBack)
    {
        string origin = Session["Origin"].ToString();
        string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(conString))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM [tblStation] WHERE Origin = @Origin ", con))
            {
                cmd.Parameters.AddWithValue("@Origin", origin);
                con.Open();
                gvCustomers.DataSource = cmd.ExecuteReader();
                gvCustomers.DataBind();
                con.Close();
            }
        }
    }
}



Iam Using This Code sir,,,THis code works perfect but i want to display logged username also after login screen Welcome User ...Please help me sir

C#

Default

protected void Login(object sender, EventArgs e)
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT Origin FROM Users WHERE Username = @UserName AND Password = @Password", con))
        {
            cmd.Parameters.AddWithValue("@Username", txtUserName.Text.Trim());
            cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());
            con.Open();
            string origin = Convert.ToString(cmd.ExecuteScalar());
            con.Close();
            if (!string.IsNullOrEmpty(origin))
            {
                Session["Origin"] = origin;
                Response.Redirect("Home.aspx");
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Invalid UserName or Password.')", true);
            }
        }
    }
}

Home

protected void Page_Load(object sender, EventArgs e)
{
    if(!this.IsPostBack)
    {
        string origin = Session["Origin"].ToString();
        string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(conString))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM [tblStation] WHERE Origin = @Origin ", con))
            {
                cmd.Parameters.AddWithValue("@Origin", origin);
                con.Open();
                gvCustomers.DataSource = cmd.ExecuteReader();
                gvCustomers.DataBind();
                con.Close();
            }
        }
    }
}

I am Using This Code sir

THis code works perfect but i want to display logged username also after login screen Welcome User.

Please help me sir

Will you please share your html of the page you want to display the details?

Are you using Master Page?

YES IAM USING MASTER PAGE