protected void Page_Init(object sender, EventArgs e)
    {
        Query conn = new Query();
        if (!this.IsPostBack)
        {
            DataTable dtfoto = conn.GetDataTable("SELECT Id FROM Immagini WHERE Id_Album = " + Request.QueryString["id"].ToString());
            int pag = dtfoto.Rows.Count / 10;
            if ( (dtfoto.Rows.Count!=0) & (dtfoto.Rows.Count % 10) == 0)
            {
                pag--;
            }
            Session["Pag"] = pag;
            bool prot = false;
            MySqlCommand pass = conn.GetSqlCommand("SELECT Password From Album WHERE Id = "+Request.QueryString["id"].ToString());
            MySqlDataReader readp = pass.ExecuteReader();
            while (readp.Read()){
                if (!readp.IsDBNull(0)) prot = true;
            };
            readp.Close();
            if (prot)
            {
                try
                {

                    if (Session["AlbumAccess"].ToString() != "Garantito")
                    {
                        Response.Redirect("ErroreCredenziali.aspx");
                        conn.close_conn();
                    }
                }
                catch (Exception e2)
                {
                    Response.Redirect("ErroreCredenziali.aspx");
                    conn.close_conn();
                }
                }
                
            
        }

        if (Request.QueryString["StartP"].ToString() == "0")
        {
            LinkButton1.Visible = false;
            LinkButton2.Visible = false;
        }
        if (Request.QueryString["StartP"].ToString() == Session["Pag"].ToString())
        {
            LinkButton4.Visible = false;
            LinkButton3.Visible = false;
        }
        int startp = Convert.ToInt16(Request.QueryString["StartP"].ToString(), 10) * 10;
        MySqlCommand cmd = conn.GetSqlCommand("SELECT Id, Descrizione FROM Immagini WHERE Id_Album=?id LIMIT ?lim, 10");
        cmd.Parameters.Add("?id", MySqlDbType.Int32).Value = Request.QueryString["id"].ToString();
        cmd.Parameters.Add("?lim", MySqlDbType.Int32).Value = startp;
        MySqlDataReader foto = cmd.ExecuteReader();
        DataList1.DataSource = foto;
        DataList1.DataBind();
        foto.Close();
        conn.close_conn();

    }