我做的翻页-class.aspx,下面是CS文件里的部分代码:if(!Page.IsPostBack)
{
CurrentPage=0;
ViewState["CurrentPage"]=0;
string sk=SQL_Key;
switch(sk)
{
case "1":
sql_sum="select count(*) as co from products where ("+Key+") and active=0";
sql_main="select * from products where ("+Key+") and active=0 order by ID DESC";
break;
case "2":
sql_sum="select count(*) as co from products where ("+Key+") and grade=3 and active=0";
sql_main="select * from products where ("+Key+") and grade=3 and active=0 order by ID DESC";
break;
case "3":
sql_sum="select count(*) as co from products where ("+Key+") and grade=2 and active=0";
sql_main="select * from products where ("+Key+") and grade=2 and active=0 order by ID DESC";
break;
case "4":
sql_sum="select count(*) as co from products where ("+Key+") and grade=4 and active=0";
sql_main="select * from products where ("+Key+") and grade=4 and active=0 order by ID DESC";
break;
default:
sql_sum="select count(*) as co from products where ("+Key+") and active=0";
sql_main="select * from products where ("+Key+") and active=0 order by ID DESC";
break;
}
//sql_sum="select count(*) as co from products where category like '%"+Cate_Key+"%'";
ViewState["sql_sum"]=sql_sum;
RecordCount=jisuan(sql_sum);
jilushu.Text=RecordCount.ToString();
PageCount=(RecordCount-1-((RecordCount-1)%PageSize))/PageSize+1;
zongyeshu.Text=PageCount.ToString();
ViewState["PageCount"]=PageCount;
//sql_main="select * from products where category like '%"+Cate_Key+"%' order by ID DESC";
ViewState["sql_main"]=sql_main;
BindList(sql_main);
}
}
public int jisuan(string key_sum)
{
int shu;
OleDbCommand comm=new OleDbCommand(key_sum,conn);
OleDbDataReader rd=comm.ExecuteReader();
if(rd.Read())
{
shu=Int32.Parse(rd["co"].ToString());
}
else
{
shu=0;
}
rd.Close();
return shu;
}
ICollection Create_Source(string sql)
{
int PageIndex;
PageIndex=CurrentPage*PageSize;
OleDbDataAdapter adap=new OleDbDataAdapter(sql,conn);
DataSet ds=new DataSet();
adap.Fill(ds,PageIndex,PageSize,"products");
return ds.Tables["products"].DefaultView;
}
public void BindList(string SQL)
{
dll.DataSource=Create_Source(SQL);
dll.DataBind();
sy.Enabled=true;
xs.Enabled=true;
xx.Enabled=true;
my.Enabled=true;
if(CurrentPage==0)
{
sy.Enabled=false;
xs.Enabled=false;
}
if(CurrentPage==PageCount-1)
{
xx.Enabled=false;
my.Enabled=false;
}
dangqianye.Text=(CurrentPage+1).ToString();
conn.Close();
}
public void Page_OnClick(Object sender,CommandEventArgs e)
{
CurrentPage=(int)ViewState["CurrentPage"];
PageCount=(int)ViewState["PageCount"];
sql_main=ViewState["sql_main"].ToString();
string cmd=e.CommandName;
switch(cmd)
{
case "sy":
CurrentPage=0;
break;
case "xs":
CurrentPage--;
break;
case "xx":
CurrentPage++;
break;
case "my":
CurrentPage=PageCount-1;
break;
default:
CurrentPage=0;
break;
}
ViewState["CurrentPage"]=CurrentPage;
BindList(sql_main);
}直接带参数浏览class.aspx页的时候能够正常实现翻页,可是我用ajax调用以后就翻不了页了为什么?var keyid = document.getElementById("show_productsid_key").value;
var key = document.getElementById("show_products_key").value;
if ((key == null) || (key == "")) return;
var urlshow = "../iframe/class.aspx?keyID="+ escape(keyid)+"&key="+ escape(key) +"&sql_key=1";
xmlHttpshow.open("GET", urlshow, true);
xmlHttpshow.onreadystatechange = updatePageshow;
xmlHttpshow.send(null);请高手指点一下~只有20分了,谢谢~很急~在线等~
{
CurrentPage=0;
ViewState["CurrentPage"]=0;
string sk=SQL_Key;
switch(sk)
{
case "1":
sql_sum="select count(*) as co from products where ("+Key+") and active=0";
sql_main="select * from products where ("+Key+") and active=0 order by ID DESC";
break;
case "2":
sql_sum="select count(*) as co from products where ("+Key+") and grade=3 and active=0";
sql_main="select * from products where ("+Key+") and grade=3 and active=0 order by ID DESC";
break;
case "3":
sql_sum="select count(*) as co from products where ("+Key+") and grade=2 and active=0";
sql_main="select * from products where ("+Key+") and grade=2 and active=0 order by ID DESC";
break;
case "4":
sql_sum="select count(*) as co from products where ("+Key+") and grade=4 and active=0";
sql_main="select * from products where ("+Key+") and grade=4 and active=0 order by ID DESC";
break;
default:
sql_sum="select count(*) as co from products where ("+Key+") and active=0";
sql_main="select * from products where ("+Key+") and active=0 order by ID DESC";
break;
}
//sql_sum="select count(*) as co from products where category like '%"+Cate_Key+"%'";
ViewState["sql_sum"]=sql_sum;
RecordCount=jisuan(sql_sum);
jilushu.Text=RecordCount.ToString();
PageCount=(RecordCount-1-((RecordCount-1)%PageSize))/PageSize+1;
zongyeshu.Text=PageCount.ToString();
ViewState["PageCount"]=PageCount;
//sql_main="select * from products where category like '%"+Cate_Key+"%' order by ID DESC";
ViewState["sql_main"]=sql_main;
BindList(sql_main);
}
}
public int jisuan(string key_sum)
{
int shu;
OleDbCommand comm=new OleDbCommand(key_sum,conn);
OleDbDataReader rd=comm.ExecuteReader();
if(rd.Read())
{
shu=Int32.Parse(rd["co"].ToString());
}
else
{
shu=0;
}
rd.Close();
return shu;
}
ICollection Create_Source(string sql)
{
int PageIndex;
PageIndex=CurrentPage*PageSize;
OleDbDataAdapter adap=new OleDbDataAdapter(sql,conn);
DataSet ds=new DataSet();
adap.Fill(ds,PageIndex,PageSize,"products");
return ds.Tables["products"].DefaultView;
}
public void BindList(string SQL)
{
dll.DataSource=Create_Source(SQL);
dll.DataBind();
sy.Enabled=true;
xs.Enabled=true;
xx.Enabled=true;
my.Enabled=true;
if(CurrentPage==0)
{
sy.Enabled=false;
xs.Enabled=false;
}
if(CurrentPage==PageCount-1)
{
xx.Enabled=false;
my.Enabled=false;
}
dangqianye.Text=(CurrentPage+1).ToString();
conn.Close();
}
public void Page_OnClick(Object sender,CommandEventArgs e)
{
CurrentPage=(int)ViewState["CurrentPage"];
PageCount=(int)ViewState["PageCount"];
sql_main=ViewState["sql_main"].ToString();
string cmd=e.CommandName;
switch(cmd)
{
case "sy":
CurrentPage=0;
break;
case "xs":
CurrentPage--;
break;
case "xx":
CurrentPage++;
break;
case "my":
CurrentPage=PageCount-1;
break;
default:
CurrentPage=0;
break;
}
ViewState["CurrentPage"]=CurrentPage;
BindList(sql_main);
}直接带参数浏览class.aspx页的时候能够正常实现翻页,可是我用ajax调用以后就翻不了页了为什么?var keyid = document.getElementById("show_productsid_key").value;
var key = document.getElementById("show_products_key").value;
if ((key == null) || (key == "")) return;
var urlshow = "../iframe/class.aspx?keyID="+ escape(keyid)+"&key="+ escape(key) +"&sql_key=1";
xmlHttpshow.open("GET", urlshow, true);
xmlHttpshow.onreadystatechange = updatePageshow;
xmlHttpshow.send(null);请高手指点一下~只有20分了,谢谢~很急~在线等~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货