nothing seems to be wrong

[hime]

hello all;

I am programming a webpage with .NET C# in which I want to display data from database and I am using custom paging
* (page size = 4)
* I am using imageuttons to navigate (next,prv,first,last) in which I make the decrement or increment but next will only take me to page no. 2, and prv takes me to page no 1. no matter where I am at that point
and here is the code for my entire page because I can't figure where the mistake occurs exactly

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;
using MySql.Data.Types;
 
namespace Yacoup
{
    /// <summary>
    /// Summary description for workgroup.
    /// </summary>
    public class workdetails : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Label result;
        protected System.Web.UI.WebControls.Label no1txt;
        protected System.Web.UI.WebControls.Label no2txt;
        protected System.Web.UI.WebControls.Label no3txt;
        protected System.Web.UI.WebControls.Label no4txt;
        protected System.Web.UI.WebControls.ImageButton first;
        protected System.Web.UI.WebControls.ImageButton previous;
        protected System.Web.UI.WebControls.ImageButton last;
        protected System.Web.UI.HtmlControls.HtmlTable resultt;
        protected System.Web.UI.HtmlControls.HtmlTableCell TD7;
        protected System.Web.UI.HtmlControls.HtmlTableCell TD6;
        protected System.Web.UI.HtmlControls.HtmlTableCell td00;
        protected System.Web.UI.HtmlControls.HtmlTableCell td10;
        protected System.Web.UI.HtmlControls.HtmlTableCell td20;
        protected System.Web.UI.HtmlControls.HtmlTableCell td30;
        protected System.Web.UI.HtmlControls.HtmlTableCell TD3;
        public int pcount=0;
        public int pagesize=4;
        public int npage=1;
        public int srow,erow,rcount;
        private DataSet ds=new DataSet();
        private MySqlConnection con=new MySqlConnection("Server=localhost;Database=yacoup;Uid=root;Pwd=root;");
        private MySqlDataAdapter da=new MySqlDataAdapter();
        string TableName="employee";
        string actionpg="workdetails.aspx";
        protected System.Web.UI.WebControls.Table Table1;
        protected System.Web.UI.WebControls.HyperLink h1;
        protected System.Web.UI.WebControls.HyperLink h2;
        protected System.Web.UI.WebControls.HyperLink h3;
        protected System.Web.UI.WebControls.HyperLink h4;
        protected System.Web.UI.WebControls.HyperLink h5;
        int xc=0;
        int i;
        protected System.Web.UI.WebControls.ImageButton next;
 
 
 
 
 
private void Page_Load(object sender, System.EventArgs e)
        {
 
 
h1.NavigateUrl="workdetails.aspx?s=1";
h2.NavigateUrl="workdetails.aspx?s=2";
h3.NavigateUrl="workdetails.aspx?s=3";
h4.NavigateUrl="workdetails.aspx?s=4";
h5.NavigateUrl="workdetails.aspx?s=5";
 
i = Convert.ToInt32("0"+Request.QueryString["s"]);
 
 
 
TareefInit(i,npage);    
}
 
 
 
private void TareefInit(int x,int page)
{
#region ProcessInit
 
if(page==0)
page=1;
 
 
if(x==5)
{da=new MySqlDataAdapter("select * from employee order by empid asc ",con);}
else
{da=new MySqlDataAdapter("select * from employee order by expyear desc",con);}
da.Fill(ds,TableName);
 
rcount=Convert.ToInt32(ds.Tables[TableName].Rows.Count);
 
if(rcount%pagesize==0)
{
pcount=rcount/pagesize;
 
}
else
{
pcount=rcount/pagesize;
pcount++;
 
 
}
 
 
#endregion
TareefSERow();
TareefShow();
 
 
}
 
private void TareefSERow()
{
#region startrow and endrow
if(npage==0 || npage==1)
{
srow=0;
erow=pagesize;
if(rcount<4)
erow=rcount;
//Response.Write(rcount+"<-");
 
}
else
{
int mpage = npage;
srow=(mpage-1)*pagesize;
erow=npage*pagesize;
if(erow>rcount)
erow=rcount;
if(srow<0)
srow=0;
    }
    #endregion
}
 
 
private void TareefShow()
{
xc=0;
#region Show Database Result
for(int i=srow;i<erow;i++)
{
xc++;
if(xc==1)
{  
//cell2
no1txt.Text="&nbsp;&nbsp;";
no1txt.Text+="<font color='#336699'>Employee Name: </font>"+ds.Tables[TableName].Rows[i][1];
no1txt.Text+="<font color='#336699'><br>&nbsp;&nbsp;Employee Work: &nbsp;&nbsp;</font>"+ds.Tables[TableName].Rows[i][2];
 
}            
if(xc==2)
{
 
//cell2
no2txt.Text="&nbsp;&nbsp;";
no2txt.Text+="<font color='#336699'>Employee Name: </font>"+ds.Tables[TableName].Rows[i][1];
no2txt.Text+="<font color='#336699'><br>&nbsp;&nbsp;Employee Work: &nbsp;&nbsp;</font>"+ds.Tables[TableName].Rows[i][2];
 
}
 
if(xc==3)
{
 
    //cell2
no3txt.Text="&nbsp;&nbsp;";
no3txt.Text+="<font color='#336699'>Employee Name: </font>"+ds.Tables[TableName].Rows[i][1];
no3txt.Text+="<font color='#336699'><br>&nbsp;&nbsp;Employee Work: &nbsp;&nbsp;</font>"+ds.Tables[TableName].Rows[i][2];
 
 
 }
 
    if(xc==4)
 {
 
//cell2
no4txt.Text="&nbsp;&nbsp;";
no4txt.Text+="<font color='#336699'>Employee Name: </font>"+ds.Tables[TableName].Rows[i][1];
no4txt.Text+="<font color='#336699'><br>&nbsp;&nbsp;Employee Work: &nbsp;&nbsp;</font>"+ds.Tables[TableName].Rows[i][2];
                }
 
 
result.Text="Page :"+npage+" out "+pcount;
 
            }
 
        #endregion
 
        TareefClear();
        }
 
        private void TareefClear()
        {
        int z=erow-srow;
 
        for(int y=4;y>z;y--)
        {
        #region TareefRemoveControls
        if(y==4)
        {
        td30.Controls.Clear();
        td30.Attributes.Clear();
        }
        if(y==3)
        {
        td20.Controls.Clear();
        td20.Attributes.Clear();
        }
        if(y==2)
        {
        td10.Controls.Clear();
        td10.Attributes.Clear();
        }
        if(y==1)
        {
        td00.Controls.Clear();
        td00.Attributes.Clear();
        }
 
                #endregion
            }
 
    if(no1txt.Text=="")
            {
        TD3.Controls.Clear();
        result.Text="No Data Found";
            }
        }
 
        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
 
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
    this.Load += new System.EventHandler(this.Page_Load);
        }
        #endregion
 
            public void nxt_prv(object sender, CommandEventArgs x)
        {
 
            if (x.CommandName == "next" && x.CommandArgument.ToString() == "next")
            {
                if(!(npage>=pcount))
                {                    
                   npage++;                    
 
 
                    ds.Clear();
 
                   TareefInit(i,npage);
 
 
            }
 
 
            }
            else if(x.CommandName == "prv" && x.CommandArgument.ToString() == "prv")
            {
                if(!(npage<=1))
                {
                    npage++;                
                    ds.Clear();
 
                    TareefInit(i,npage);
                }
            }
            else if(x.CommandName == "first" && x.CommandArgument.ToString() == "first")
            {
                npage=1;
 
                ds.Clear();
 
               TareefInit(i,npage);
            }
 
            else if(x.CommandName == "last" && x.CommandArgument.ToString() == "last")
            {
 
                npage=pcount;    
                ds.Clear();    
                TareefInit(i,npage);
            }
 
        }
 
        private void next_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
 
        }
 
        private void previous_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
 
        }
 
        private void first_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
 
        }
 
        private void last_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
 
        }
 
 
 
 
 
    }
}
 
 

[enreil]

Have you considered using a DataGrid? If you enable paging for your datagrid in the Property Builder, you'll still have paging functionality and avoid lots of debugging headaches.

[nmsreddi]

hello

You said you want to display data from database .but from your code i dint get where you are displaying your data.

if its grid you can have display it with paging option and if any reports you are using for display then you have properties directly

[hime]

hello all

thank u for replying to my question, as for my data I am showing it in the function TareefShow(), using labels we used this way because we thought it would be the best way to control the way it will appear on the screen.

as for my question that when I click the next button or any other button the value of (npage//the page we r standing in at that point) wont keep the change it will always go back to the initial value which is 1.

now how we solved that problem

we used cache object to save the change in the npage with each click and here is the code with some explanation I hope it is helpful

 
public void nxt_prv(object sender, CommandEventArgs x)
    {
  if (x.CommandName == "next" && x.CommandArgument.ToString() == "next")
{
 
if(!(npage>=pcount))   //pcount: No. of pages ,npage: the page we r showing now
    {    
                  //npagecache: the cache opject to save the value of npage in 
      if (Cache.Get("npagecache") != null) 
    {
                 //  we retreive the value from the npagecache and asign it to n page 
      npage = Convert.ToInt32( Cache.Get("npagecache"));        
    }
    npage++;
                /*after the increment to npage we stored the new value in npagecache  to be able to retreive this value as needed in the program */
    Cache.Insert("npagecache",npage);            
    ds.Clear();                   
    TareefInit(i,npage);                    
    }                
}
 
else if(x.CommandName == "prv" && x.CommandArgument.ToString() == "prv")
{
   if (Cache.Get("npagecache") != null)
    {
      npage = Convert.ToInt32( Cache.Get("npagecache"));        
    }
    if(!(npage<=1))
    {
    npage--;
    Cache.Insert("npagecache",npage);
    ds.Clear();                    
    TareefInit(i,npage);
    }
    }
else if(x.CommandName == "first" && x.CommandArgument.ToString()== "first")
{
 if (Cache.Get("npagecache") != null)
 {
  npage = Convert.ToInt32( Cache.Get("npagecache"));        
 }
 npage=1;
Cache.Insert("npagecache",npage);
 ds.Clear();
 TareefInit(i,npage);
}
 
else if(x.CommandName == "last" && x.CommandArgument.ToString() == "last")
{
if (Cache.Get("npagecache") != null)
{
npage = Convert.ToInt32( Cache.Get("npagecache"));        
}
npage=pcount;
Cache.Insert("npagecache",npage);
ds.Clear();    
TareefInit(i,npage);
}
 
}    
 
 

and off cores the in page load we used IsPostBack to empty the page for each post back now for the page load code

private void Page_Load(object sender, System.EventArgs e)
{
h1.NavigateUrl="workdetails.aspx?s=1";
h2.NavigateUrl="workdetails.aspx?s=2";
h3.NavigateUrl="workdetails.aspx?s=3";
h4.NavigateUrl="workdetails.aspx?s=4";
h5.NavigateUrl="workdetails.aspx?s=5";
 
i = Convert.ToInt32("0"+Request.QueryString["s"]);
 
     TareefInit(i,npage);    
 
    if(!Page.IsPostBack)
    {
                  //When ever the page is redirected the cache opject will be emptied
      Cache.Remove("npagecache");            
     }                
}        
 

and finally if there is any question or comment please send a reply and if there is any other way to solve the npage problem I would be glad to hear and try it.

[enreil]

Did you consider stashing the page number in a session variable? That may result in less overhead.

I still don't quite get why you chose to not use the DataGrid. It is quite customizable and makes things a whole lot easier for you as a developer. Just some advice for future projects - you can take it or leave it.

[hime]

thank u alot, but the reason we are not considering the change to a datagrid is that we have more than one page with the same design and we are trying to keep it this way as for the future we will use the datagrid :)

about the session variable we r gonna try it for the page

thank u again