protected void GridView5_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridViewRow row = GridView5.SelectedRow;
        Session.Add("ProgID", row.Cells[1].Text);
    }

protected void Button1_Click(object sender, EventArgs e)
    {
       SqlConnection connection = new SqlConnection("Data Source=WKS-030\\SQLEXPRESS;Initial Catalog=webtv;Integrated Security=SSPI");
       try
       {
           string i = DropDownList1.SelectedValue;
           string queryString = "INSERT INTO Programmazione (PalinsestoID,ProgrammaID) VALUES (" + i + "," + Session["ProgID"] + ")";
           SqlCommand command = new SqlCommand(queryString, connection);
           command.Connection.Open();
           command.ExecuteNonQuery();
          }
       catch (SqlException err )
       {
Label7.Text = "Non è possibile inserire lo stesso programma nello stesso palinsesto";
           Console.Write(err.Message);
       }
        finally
        {
           connection.Close();
        }
        GridView6.DataBind();
         }