tree + datalist 分页问题

Question

where is the source code?

Answer 1

不好意思， 原码忘贴了， 重贴
public partial class menulink_product : System.Web.UI.Page
{
    public string tvvalues;
    protected void Page_Load(object sender, EventArgs e)
    {        if (!IsPostBack)
        {            //getproductimg();
            getproducttype("peidian");
        }    }    private void getproducttype(string type)    {
        
        int number = Convert.ToInt32(this.lbl_productpage.Text);        PagedDataSource ps = new PagedDataSource();
        ps.AllowPaging = true;        ps.PageSize = 12;
    
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["news"].ConnectionString);
        string sqlstr = "select * from product where producttype='"+type+"'";
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter(sqlstr,sqlcon);
        
        sda.Fill(ds,type);
        ps.DataSource = ds.Tables[type].DefaultView;
           ps.CurrentPageIndex = number - 1;        this.btn_productprv.Enabled = true;
        this.btn_productnext.Enabled = true;        if (number == ps.PageCount)
        {
            this.btn_productnext.Enabled = false;
        }
        else if (number == 1)
        {
            this.btn_productprv.Enabled = false;
        }      
        this.dlt_product.DataSource = ps;
        this.dlt_product.DataBind();        }
     
    private void getproductimg()
    {
       // throw new NotImplementedException();        //DB dbx = new DB();
        //this.dlt_product.DataSource = dbx.getproduct();
        //this.dlt_product.DataBind();        int number = Convert.ToInt32(this.lbl_productpage.Text);        PagedDataSource ps = new PagedDataSource();
        ps.AllowPaging = true;        ps.PageSize = 12;
    
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["news"].ConnectionString);
        string sqlstr = "select * from product";
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter(sqlstr,sqlcon);
        sda.Fill(ds,"temp");
        ps.DataSource = ds.Tables["temp"].DefaultView;
           ps.CurrentPageIndex = number - 1;        this.btn_productprv.Enabled = true;
        this.btn_productnext.Enabled = true;        if (number == ps.PageCount)
        {
            this.btn_productnext.Enabled = false;
        }
        else if (number == 1)
        {
            this.btn_productprv.Enabled = false;
        }      
        this.dlt_product.DataSource = ps;
        this.dlt_product.DataBind();        }
    protected void tv_product_SelectedNodeChanged(object sender, EventArgs e)
    {        string tv_value = this.tv_product.SelectedNode.Value.ToString();
        //Response.Write(tv_value);
        DB dbx = new DB();        switch(tv_value)
        {            case "peidian":
                this.tvvalues = "peidiang";
                this.getproducttype(tv_value);
            
                break;
            case "wujin":
                
                this.getproducttype(tv_value);
                break;
            case "wenjian":
                this.getproducttype(tv_value); ;
                break;
            case "jixang":
                this.getproducttype(tv_value);
                break;
            case "zixun":
                this.getproducttype(tv_value);
                break;
            case "tueiche":
                this.getproducttype(tv_value);
                break;
            case "ganzhao":
                this.getproducttype(tv_value);
                break;        }    }
    protected void btn_productprv_Click(object sender, EventArgs e)
    {
        switch (tvvalues)
        {            case "peidian":
                this.tvvalues = "peidiang";                this.getproducttype(tvvalues);
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) - 1));
                this.getproducttype(tvvalues);                break;
            case "wujin":
                this.tvvalues = "wujin";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) - 1));
                this.getproducttype(tvvalues);
                break;
            case "wenjian":
                this.tvvalues = "wenjian";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) - 1));
                this.getproducttype(tvvalues); ;
                break;
            case "jixang":
                this.tvvalues = "jixang";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) - 1));
                this.getproducttype(tvvalues);
                break;
            case "zixun":
                this.tvvalues = "zixun";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) - 1));
                this.getproducttype(tvvalues);
                break;
            case "tueiche":
                this.tvvalues = "tueiche";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) - 1));
                this.getproducttype(tvvalues);
                break;
            case "ganzhao":
                this.tvvalues = "ganzhao";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) - 1));
                this.getproducttype(tvvalues);
                break;        }
    }
    protected void btn_productnext_Click(object sender, EventArgs e)
    {
       
        switch (tvvalues)
        {            case "peidian":
                this.tvvalues = "peidiang";
                this.getproducttype(tvvalues);
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) + 1));
             
                this.getproducttype(tvvalues);                break;
            case "wujin":
                this.tvvalues = "wujin";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) + 1));  
                this.getproducttype(tvvalues);
                break;
            case "wenjian":
                this.tvvalues = "wenjian";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) + 1));  
                this.getproducttype(tvvalues); ;
                break;
            case "jixang":
                this.tvvalues = "jixang";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) + 1));  
                this.getproducttype(tvvalues);
                break;
            case "zixun":
                this.tvvalues = "zixun";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) + 1));  
                this.getproducttype(tvvalues);
                break;
            case "tueiche":
                this.tvvalues = "tueiche";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) + 1));  
                this.getproducttype(tvvalues);
                break;
            case "ganzhao":
                this.tvvalues = "ganzhao";
                this.lbl_productpage.Text = Convert.ToString((Convert.ToInt32(this.lbl_productpage.Text) + 1));  
                this.getproducttype(tvvalues);
                break;        }    }
}