title: Database not storing information properly, stores info on different rows
body: <p>The database is not storing information all on the same row. On the first page, when I click the button it records it and that's fine, it's stored. Then on the next page, when i click the button, it stores the information, but on a different row? Any solutions? Heres the problem, and code below.</p>
  
  <hr>
  
  <p><img src="https://i.stack.imgur.com/YVbS5.png" alt="enter image description here"></p>
  
  <p><strong>PAGE 1</strong></p>
  
  <pre><code>public void addInformationToDatabase()
      {
          string Sex = ddlGender.Text;
          string Name = tbxName.Text;
          string DOB = tbxDOB.Text;
  
          string connectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  
          SqlConnection Con = new SqlConnection(connectionString);
  
          SqlCommand command = new SqlCommand();
          command.Connection = Con;
          command.CommandType = CommandType.Text;
          command.CommandText = "INSERT INTO [User] (GenderID,Name,DOB) VALUES(@Sex,@Name,@DOB)";
  
          command.Parameters.AddWithValue("@Sex", Sex);
          command.Parameters.AddWithValue("@Name", Name);
          command.Parameters.AddWithValue("@DOB", DOB);
  
          try
          {
              Con.Open();
              command.ExecuteNonQuery();
  
          }
          catch (Exception ex)
          {
              Response.Write(ex.Message);
          }
          finally
          {
              Con.Close();
          }
      }
  </code></pre>
  
  <hr>
  
  <p><strong>2ND PAGE</strong></p>
  
  <pre><code>public void save()
      {
  
          string checkboxSelection = CheckBoxList1.SelectedItem.ToString();
  
          string connectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  
          SqlConnection Con = new SqlConnection(connectionString);
  
          SqlCommand c = new SqlCommand();
          c.Connection = Con;
          c.CommandType = CommandType.Text;
          c.CommandText = "INSERT INTO [User] (Ans1) VALUES(@Ans1)";
  
          c.Parameters.AddWithValue("@Ans1", checkboxSelection);
  
          try
          {
              Con.Open();
              c.ExecuteNonQuery();
  
          }
          catch (Exception ex)
          {
              Response.Write(ex.Message);
          }
          finally
          {
              Con.Close(); 
          }
      }
  </code></pre>
  
  <hr>
  
  <p><em>Any help appreciated</em></p>