How to update mutiple values with while loop before updating the databse with C#

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Collections.Generic;
using System.Text;

public partial class Nampak_AddFal : System.Web.UI.Page
{
    string selectSQL, selectSQL1, selectSQL5;
    string updateSQL, updateSQL1, updateSQL5, updateSQL6, updateSQL2;
    SqlCommand cmd = new SqlCommand();
    SqlCommand cmd1 = new SqlCommand();
    SqlCommand cmd2 = new SqlCommand();
    SqlCommand cmd3 = new SqlCommand();
    SqlCommand cmd5 = new SqlCommand();
    SqlCommand cmd6 = new SqlCommand();
    SqlCommand cmd9 = new SqlCommand();
    SqlConnection dbConn = new SqlConnection();
    SqlConnection dbConn1 = new SqlConnection();
    SqlConnection dbConn2 = new SqlConnection();
    SqlConnection dbConn3 = new SqlConnection();
    SqlConnection dbConn4 = new SqlConnection();
    SqlConnection dbConn5 = new SqlConnection();
    SqlConnection dbConn6 = new SqlConnection();
    SqlDataReader dr, dr1, dr2, dr3, dr5, dr8;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void SetSS_Click(object sender, EventArgs e)
    {
        Session["YY"] = DropDownList1.SelectedItem.Text;
        int Q = Convert.ToInt32(TextBox1.Text);
        


        selectSQL = "select id, RTicket from Staff WHERE Jobtype ='Contract'";
        dbConn.ConnectionString = "Data Source=LAPTOP\\SQLEXPRESS; Initial         Catalog=Namh;Integrated Security=True;";
        cmd.Connection = dbConn;
        cmd.CommandText = selectSQL;
        cmd.CommandType = CommandType.Text;

        try
        {
            dbConn.Open();
         
            dr = cmd.ExecuteReader();
           while (dr.Read())
            {
                Session["FT"] = dr["Rticket"].ToString();
                 int W = Convert.ToInt32(Session["FT"]);
                int S = W + Q;
                string P = S.ToString();
                Session["PP"] = S.ToString();
             


              updateSQL1 = "update Staff set  Rticket='" + Session["PP"].ToString() + "' where  Jobtype ='Contract' ";
              // Response.Write(updateSQL1);
               dbConn1.ConnectionString = "Data Source=LAPTOP\\SQLEXPRESS; Initial Catalog=Namh;Integrated Security=True;";

               cmd1.Connection = dbConn1;
               cmd1.CommandText = updateSQL1;
               cmd1.CommandType = CommandType.Text;
               try
               {

                   dbConn1.Open();
                   int updated1 = cmd1.ExecuteNonQuery();
                   if (updated1 == 1)
                   {
                      Response.Write("well done");
                       


                   }
                   else
                   {
                     Response.Write("double");
                       


                       
                       } 
                       
                      
                   
               }
               catch (Exception err)
               {
                   Label6.Text = "Error  Logging in 2 ";
                   Label6.Text += err.ToString();
               }
               finally
               {
                   dbConn1.Close();
               }

            }
           
            dr.Close();
        }
        catch (Exception err)
        {
            Label6.Text = "Error  Logging in 2 ";
            Label6.Text += err.ToString();
        }
        finally
        {
            dbConn.Close();
        }



    }
}