title: asp.net multiple users?
body: <p>I have an asp.net c# web application where a user can log in and see his schedule for the last week, which is stored in a remote database. Logging into the site consists of just an SQL check to see if the username and password matches the uname &amp; pass records in the database.  Once logged in, they can manipulate the time entries for the schedule, etc.  While debugging, I logged in as two different users. User B had all of user A's stuff on his form. I wrote the program like I was writing a regular c# app, and didn't really give any thought to multiple people using the website at the same time.  I guess I thought that instance handling would be automatic?  I've only been working with asp.net for a week or so, and don't have much support.</p>
  
  <p><strong>My main question is, if I have multiple users on my site at the same time, how do I keep their sessions separate?</strong>  </p>
  
  <hr>
  
  <p>update - after adding Session variables</p>
  
  <p>This is my sql statement to get user information. Now, using session variables:</p>
  
  <pre><code>string sqlquery = "SELECT FirstName, LastName, OperatorID FROM operators WHERE EmpID = '" + sql + "'";
          using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["EobrConnectionString"].ConnectionString))
          {
              conn.Open();
              using (MySqlCommand comm = new MySqlCommand(sqlquery, conn))
              {
                  using (MySqlDataAdapter adapter = new MySqlDataAdapter(comm))
                  {
                      DataTable dt = new DataTable();
                      adapter.Fill(dt);
                      foreach (DataRow dr in dt.Rows)
                      {
                          Session["Fname"] = dr[1].ToString();
                          Session["Lname"] = dr[2].ToString();
                          Session["opID"] = dr[3].ToString();
                       }
                  }
              }
          }
  </code></pre>
  
  <p>In the main menu page I have this:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
  {
      firstname = Session["Fname"].ToString();
      lastname = Session["Lname"].ToString();
      lblwelcome.Text = "Welcome, " + firstname + " " + lastname + ", make your selection below.";
  }
  </code></pre>
  
  <p>When User A logs in, they see their name "Frank Drebbin".  When User B logs in they see their name, "Jake Gaston".  But now, if I reload the first users page, they see the name as "Jake Gaston".</p>