How Do I Populate All Rows In A Table With A Single Value

See more:

ASP.NET

string con_str = @"Data Source=DATABASE;Initial Catalog=abc;Integrated Security=True";
        
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                DropDownList1.Items.Clear();
                DropDownList1.Items.Add("");
                SqlConnection con = new SqlConnection(con_str );
                con.Open();

                string es = "select year from table1";
                SqlCommand ees = new SqlCommand(es, con);
                SqlDataReader rdr = ees.ExecuteReader();

                while (rdr.Read())
                {
                    DropDownList1.Items.Add(rdr.GetString(0));

                }
      
                DropDownList1.DataBind();
    }

        }

now i want to add this dropdown value to another table in a new column

for example

dropdownselected--(2011)

sql roll name year(new column added)
1 222 abx 2011
2 333 eeqa 2011
3 342 bdh 2011


i will select 2011 and this will populate in the table in all the rows