protected void LoadDDLprogetto()
    {
        conn.Open();
        string sqlCmd;

        // visualizza solo progetti del manager
        if (!Auth.ReturnPermission("MASTERDATA", "PROJECT_ALL"))
        {
            sqlCmd = "Select Projects_id, ProjectCode + ' ' + left(Name,20) as iProgetto from Projects where ActivityOn = 1 and active = 1 AND ClientManager_id = " + CurrentSession.Persons_id + " ORDER BY iProgetto";
        }
        else
        {
            sqlCmd = "Select Projects_id, ProjectCode + ' ' + left(Name,20) as iProgetto from Projects where ActivityOn = 1 and active = 1  ORDER BY iProgetto";
        }

        SqlCommand cmd = new SqlCommand(sqlCmd, conn);

        SqlDataReader dr      = cmd.ExecuteReader();
        DropDownList  ddlList = (DropDownList)FVattivita.FindControl("DDLprogetto");

        ddlList.DataSource = dr;
        ddlList.Items.Clear();
        ddlList.Items.Add(new ListItem("--Seleziona progetto--", ""));

        ddlList.DataTextField  = "iProgetto";
        ddlList.DataValueField = "Projects_Id";
        if (Request.QueryString["Projects_id"] != null)       // in caso di update seleziona il valore nella dropdown list
        {
            ddlList.SelectedValue = Request.QueryString["Projects_id"].ToString();
        }
        ddlList.DataBind();
        conn.Close();
    }
    protected void ItemInserting_FVattivita(object sender, FormViewInsertEventArgs e)
    {
//      Forza i valori da passare alla select di insert. essendo le dropdown in
//      dipendenza non si riesce a farlo tramite un normale bind del controllo

        DropDownList ddlList = (DropDownList)FVattivita.FindControl("DDLprogetto");

        e.Values["Projects_id"] = ddlList.SelectedValue;

        DropDownList ddlList1 = (DropDownList)FVattivita.FindControl("DDLFase");

        e.Values["Phase_id"] = ddlList1.SelectedValue;
    }
    public void Bind_ddlFase()
    {
        conn.Open();

        DropDownList ddlprogetto = (DropDownList)FVattivita.FindControl("DDLProgetto");

        SqlCommand    cmd = new SqlCommand("select Phase_id, PhaseCode + '  ' + left(Name,20) AS iFase FROM Phase where Projects_id='" + ddlprogetto.SelectedValue + "' ORDER BY iFase", conn);
        SqlDataReader dr  = cmd.ExecuteReader();

        DropDownList ddlList = (DropDownList)FVattivita.FindControl("DDLFase");

        ddlList.DataSource = dr;
        ddlList.Items.Clear();
        ddlList.Items.Add(new ListItem("--Seleziona fase--", ""));
        ddlList.DataTextField  = "iFase";
        ddlList.DataValueField = "Phase_id";
        if (Request.QueryString["Phase_Id"] != null && !IsPostBack)   // in caso di update seleziona il valore nella dropdown list
        {
            ddlList.SelectedValue = Request.QueryString["Phase_Id"];
        }
        ddlList.DataBind();
        conn.Close();
    }