title: Not able to edit the textbox in asp.net
body: <p>I have below code running on page_load</p>
  
  <pre><code> using (SqlConnection conn = new SqlConnection("myconnectionString"))
          {
              conn.Open();
              using (SqlCommand cmmnd = new SqlCommand("", conn))
              {
  
  
  
                  cmmnd.CommandText = "SELECT * FROM addsetting;";
  
  
                  SqlDataReader rdr = cmmnd.ExecuteReader();
                  while (rdr.Read())
                  {
                      count++;
                      param = Convert.ToString(rdr["rowno"]);
                      TextBox1.Text = Convert.ToString(rdr["tostudent"]);
                      TextBox2.Text = Convert.ToString(rdr["tofaculty"]);
                      TextBox3.Text = Convert.ToString(rdr["studentday"]);
                      TextBox4.Text = Convert.ToString(rdr["facultyday"]);
                      TextBox5.Text = Convert.ToString(rdr["firstweek"]);
                      TextBox6.Text = Convert.ToString(rdr["secondweek"]);
                      TextBox7.Text = Convert.ToString(rdr["thirdweek"]);
  
                  }
                  rdr.Close();
              }
              conn.Close();}
  </code></pre>
  
  <p>and now after this form is filled, i am changing the values and have a "save" button.</p>
  
  <p>strangly on Button2_Click, when i try to access the edited values from the textbox, i am not getting new values. the textbox is having old values.</p>
  
  <p>why textbox is not having the edited values.</p>
  
  <p>below is the code which i am using to acces the values.</p>
  
  <pre><code> using (SqlConnection conn = new SqlConnection("myconnectionstring"))
              {
                  conn.Open();
  
  
  
                  using (SqlCommand cmd = new SqlCommand("", conn))
                  {
                      cmd.Parameters.Add("@rowno", SqlDbType.VarChar).Value = param; 
  
                      cmd.Parameters.AddWithValue("@tostudent", TextBox1.Text); 
                      cmd.Parameters.AddWithValue("@tofaculty", TextBox2.Text);
                      cmd.Parameters.AddWithValue("@studentday", TextBox3.Text);
                      cmd.Parameters.AddWithValue("@facultyday", TextBox4.Text);
                      cmd.Parameters.AddWithValue("@firstweek", TextBox5.Text);
                      cmd.Parameters.AddWithValue("@secondweek", TextBox6.Text);
                      cmd.Parameters.AddWithValue("@thirdweek", TextBox7.Text);
  
  
                      cmd.CommandText = "UPDATE addsetting SET tostudent=@tostudent,tofaculty=@tofaculty,studentday=@studentday,facultyday=@facultyday,firstweek=@firstweek,secondweek=@secondweek,thirdweek=@thirdweek WHERE rowno=@rowno";
                      cmd.ExecuteNonQuery();
  
                  }
  
                  conn.Close();
  </code></pre>