Pass Multiple attributes (objects) using Session in ASP.Net using C#

kellyfer...

SOLVED CLOSED ACTIVE ANSWERED
User: kellyfergus
Posted: on Mar 19, 2024 12:37 PM
Forum: Data Controls
Answer: 1
Views: 666

I have an asp login page connected to sql database. user logs in based on information matching the sql table. I have also got a session functioning. I am very early days of my project.

so after i log the user in they are redirected to a Dashboard page and i can display their user id which was assigned to the session.

The next step is i want to display other attributes from the database table like name and age etc.

Can i pass multiple attributes to the session? I dont want to open another sql connection on the dashboard page.

Can anyone help me with the code?

I would like to show user email and full name on the dash board.

so this is the code i have on the login page:

protected void Button1_Click(object sender, EventArgs e)
{
    try
    {
        string uid = TextBox1.Text;
        string pass = TextBox2.Text;

        myCon.Open();
        string qry = "select userId from users where userId='" + uid + "' and Password='" + pass + "'";
        SqlCommand cmd = new SqlCommand(qry, myCon);
        SqlDataReader sdr = cmd.ExecuteReader();
        if (sdr.Read())
        {
            Session["userId"] = uid.Trim();
            Response.Redirect("Dashboard.aspx");
        }
        else
        {
            Label4.Text = "UserId & Password Is not correct Try again..!!";
        }
        myCon.Close();
    }
    catch(Exception ex){
        Response.Write(ex.Message);
    }
}

On the dashboard page i have the following:

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["userId"] == null)
        Response.Redirect("Login.aspx");
    SessionLabel.Text = "Username : " + Session["userId"];
}

protected void ButtonLogout_Click(object sender, EventArgs e)
{
    Session.Abandon();
    Response.Redirect("Login.aspx");
}

thanks

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Mar 19, 2024 12:48 PM
Report

You can create a class and pass all the details using Session throug the class.

For more details refer our article.

Store (Save) Class Object in Session in ASP.Net using C# and VB.Net

Class

public class User
{
    public int UserId { get; set; } 
    public string Name { get; set; }       
    public int Age { get; set; }
}

Then set like below.

string uid = TextBox1.Text.Trim();
string pass = TextBox2.Text.Trim();
myCon.Open();
string qry = "SELECT UserName, Age FROM Users WHERE UserId=@UserId and Password=@Password";
SqlCommand cmd = new SqlCommand(qry, myCon);
cmd.Parameters.AddWithValue("@userId", uid);
cmd.Parameters.AddWithValue("@Password", pass);
SqlDataReader sdr = cmd.ExecuteReader();
if(sdr.Read())
{
    User user = new User()
    {
        UserId = uid,
        Name = sdr["UserName"].ToString(),
        Age = Convert.ToInt32(sdr["Age"])
    };
 
    Session["User"] = user;
}

Then retrieve like below.

protected void Page_Load(object sender, EventArgs e)
{
    if (Session["User"] == null)
    {
        Response.Redirect("Login.aspx");
    }
    else
    {
        User user = (User)Session["User"];
        SessionLabel.Text = "Username : " + user.UserId;
    }
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Pass Multiple attributes (objects) using Session in ASP.Net using C#

Store (Save) Class Object in Session in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us