I have a login page that leads to a homepage, the login page pulls from a view in the database to verify username and password (the view has 3 columns, username, password, and name) it selects all the data including the name but only uses the username and password.

This is the login code:

```
  protected void LoginButton_Click(object sender, EventArgs e)
    {
        lblerror.Visible = false;     
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SurveySystemConnectionString"].ConnectionString);
        conn.Open();
        string queryString = "SELECT * FROM [Users] WHERE Username=@username AND Password= @password";
        SqlCommand command = new SqlCommand(queryString, conn);
        command.Parameters.AddWithValue("@username", UserNameTextBox.Text);
        command.Parameters.AddWithValue("@password", PasswordTextBox.Text);

        SqlDataReader reader = null;
        reader = command.ExecuteReader();

        if (reader.Read())
        {
            Session["Username"] = UserNameTextBox;
            Session["Password"] = PasswordTextBox;
            Response.Redirect("Home.aspx");
           }
          else
            {
                lblerror.Visible = true;
                lblerror.Text = "Incorrect Username/Password Combination";
            }
            conn.Close();
 }

```

What i want to do is display a welcome message on the homepage, "Welcome (The name of the user whose id was just used)". How can this be done so that the homepage will always have the person's name until he/she logs out, meaning even if they go into other pages back and forth while logged in. I'm using Sql server for my database.