Insert data in database multiple times dynamically by one-click-button

protected void ButtonArngeOffpk_Click(object sender, EventArgs e)
       {

           string value = DropDownList1.SelectedItem.Text;  // Get the dropdown value
           int count = 0;
           int.TryParse(value, out count);  // cast the value to integer

           for (int i = 0; i < count; i++)  // iterate it for the N times
           {

               SqlCommand insert = new SqlCommand("insert into TableAdvOffPeak(Adv_Name, Duration) values(@Adv_Name, @Duration)", con);
               insert.Parameters.AddWithValue("@Adv_Name", TextBoxCmpName.Text);
               insert.Parameters.AddWithValue("@Duration", TextBoxDrtion.Text);
               try
               {
                   con.Open();
                   insert.ExecuteNonQuery();
                   con.Close();

               }
               catch
               {

               }

           }
       }