codice:using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Net; using System.IO; using System.Data.OleDb; using System.Data; using System.Drawing.Drawing2D; using System.Drawing; using System.Drawing.Imaging; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) Seleziona_Record(); } //Estrae i record dal database public void Seleziona_Record() { //Apro la connessione al db, in questo caso mySQL String ConnString = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + Server.MapPath("App_Data/Immagini.mdb"); //OdbcConnection ob = new OdbcConnection("Driver={MySQL};Database=db;UID=user;PWD=pass;"); //String sql = "select * from TABELLA"; //String sql = "SELECT descrizione, immagine FROM Privata3"; String sql = "SELECT * FROM Privata3"; OleDbConnection cn = new OleDbConnection(ConnString); //OdbcDataAdapter Com = new OdbcDataAdapter(sql,ob); OleDbDataAdapter Com = new OleDbDataAdapter(sql, cn); DataSet ds = new DataSet(); //Calcolo i record da estrarre e riempio il dataset int startRecord = (int.Parse(Pagina.Value) - 1) * int.Parse(Record_Max.Value); Com.Fill(ds, startRecord, int.Parse(Record_Max.Value), "Tabella"); //datalist1.DataSource = ds.Tables[0]; //StreamReader sr = new StreamReader(Server.MapPath("image_insert/")); Grid.DataSource = ds.Tables[0]; Grid.DataBind(); //Conta i numero di record Totali OleDbCommand myCmd = new OleDbCommand("SELECT Count(*) FROM Privata3", cn); cn.Open(); Record_Tot.Value = myCmd.ExecuteScalar().ToString(); cn.Close(); //Controllo i Link if ((int.Parse(Pagina.Value) - 1) <= 0) { Prev.Enabled = false; } else { Prev.Enabled = true; } if ((int.Parse(Pagina.Value) * int.Parse(Record_Max.Value)) >= int.Parse(Record_Tot.Value)) { Next.Enabled = false; } else { Next.Enabled = true; } } //Controlla che link ha sollevato l'evento e aumenta o diminuisce la pagina corrente public void Paginazione(object sender, EventArgs e){ if(((LinkButton)sender).ID=="Prev"){ if((int.Parse(Pagina.Value)-1)>=0){ Pagina.Value = (int.Parse(Pagina.Value)-1).ToString() ; } } else if(((LinkButton)sender).ID=="Next"){ if((int.Parse(Pagina.Value)*int.Parse(Record_Max.Value))<int.Parse(Record_Tot.Value)){ Pagina.Value = (int.Parse(Pagina.Value)+1).ToString() ; } } Seleziona_Record(); } protected void Button1_Click(object sender, EventArgs e) { } }