.NET社区
末页和尾页以及页数怎么实现？求代码求思路
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区[code=csharp]private int page = 1;
private int count = 3;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DrLB();
DrHD();
DrPP();
DrHS();
DrNMC();
}
}
public void DrLB() //类别
{
DB db = new DB();
string sqlstr = "SELECT CategoryID,Category FROM Category ";
DataTable dt = db.reDt(sqlstr);
LB.DataSource = dt;
LB.DataBind();
}
public void DrPP() //品牌
{
DB db = new DB();
string sqlstr = "SELECT VarietiesID,Varieties,VCID FROM Varieties ";
DataTable dt = db.reDt(sqlstr);
PP.DataSource = dt;
PP.DataBind();
}
public void DrHS() //花色
{
DB db = new DB();
string sqlstr = "SELECT ColorID,Color,CVID FROM Color ";
DataTable dt = db.reDt(sqlstr);
HS.DataSource = dt;
HS.DataBind();
}
public void DrNMC() //耐磨层
{
DB db = new DB();
string sqlstr = "SELECT LayerID,Layer,LCID FROM Layer ";
DataTable dt = db.reDt(sqlstr);
NMC.DataSource = dt;
NMC.DataBind();
}
public void DrHD() //厚度
{
DB db = new DB();
string sqlstr = "SELECT ThicknessID,Thickness,TLID FROM Thickness ";
DataTable dt = db.reDt(sqlstr);
HD.DataSource = dt;
HD.DataBind();
}
public void GVxs() //GridView显示
{
DB db = new DB();
string sqlstr = "select ID,category,varieties,type,color,layer,thickness,SPECIFICATION,METER,Square,Data,Number,Remark,Nmb FROM category,varieties,color,layer,thickness,kc where Category.CategoryID=kc.CategoryID and Varieties.VarietiesID=kc.VarietiesID AND Color.ColorID=kc.ColorID AND Layer.LayerID = kc.LayerID and Thickness.ThicknessID = kc.ThicknessID ORDER BY KC.ID ASC LIMIT " + (page - 1) * count + "," + count;
DataTable dt = db.reDt(sqlstr);
XS.DataSource = dt;
XS.DataBind();
}
//类别下拉框事件
protected void LB_SelectedIndexChanged(object sender, EventArgs e)
{
DB db = new DB();
string sqlstr = "SELECT VarietiesID,Varieties,VCID FROM Varieties where VCID ='" + this.LB.SelectedValue + "' ";
DataTable dt = db.reDt(sqlstr);
PP.DataSource = dt;
PP.DataBind();
}
//品牌下拉框事件
protected void PP_SelectedIndexChanged(object sender, EventArgs e)
{
DB db = new DB();
string sqlstr = "SELECT ColorID,Color,CVID FROM Color where CVID='" + this.PP.SelectedValue + "'";
DataTable dt = db.reDt(sqlstr);
HS.DataSource = dt;
HS.DataBind();
string sqlstr1 = "SELECT LayerID,Layer,typeID FROM Layer where typeID = '" + this.PP.SelectedValue + "'";
DataTable dt1 = db.reDt(sqlstr1);
NMC.DataSource = dt1;
NMC.DataBind();
NMC_SelectedIndexChanged(null,null);
}
//花色下拉框事件
protected void HS_SelectedIndexChanged(object sender, EventArgs e)
{
//DB db = new DB();
//string sqlstr = "SELECT LayerID,Layer,LCID FROM Layer where LCID = '" + this.HS.SelectedValue + "'";
//DataTable dt = db.reDt(sqlstr);
//NMC.DataSource = dt;
//NMC.DataBind();
}
//耐磨层下拉框事件
protected void NMC_SelectedIndexChanged(object sender, EventArgs e)
{
DB db = new DB();
string sqlstr = "SELECT ThicknessID,Thickness,TLID FROM Thickness where TLID = '" + this.NMC.SelectedValue + "' ";
DataTable dt = db.reDt(sqlstr);
HD.DataSource = dt;
HD.DataBind();
}
//查询按钮事件
protected void CX_Click(object sender, EventArgs e)
{
if (this.XH.Text == "" || this.XH.Text.Length == 0)
{
Response.Write("<script>alert('型号不能为空')</script>");
}
else
{
DB db = new DB();
string sqlstr = "select ID,category,varieties,type,color,layer,thickness,SPECIFICATION,METER,Square,Data,Number,Remark,Nmb FROM category,varieties,color,layer,thickness,kc where kc.CategoryID = '" + this.LB.SelectedValue + "'and kc.VarietiesID = '" + this.PP.SelectedValue + "' AND kc.ColorID = '" + this.HS.SelectedValue + "'AND kc.LayerID = '" + this.NMC.SelectedValue + "' and kc.ThicknessID = '" + this.HD.SelectedValue + "'and kc.type like '%" + this.XH.Text + "%' and kc.Number >= '" + this.KC1.Text + "'and Category.CategoryID=kc.CategoryID and Varieties.VarietiesID=kc.VarietiesID AND Color.ColorID=kc.ColorID AND Layer.LayerID = kc.LayerID and Thickness.ThicknessID = kc.ThicknessID ORDER BY KC.ID ASC LIMIT " + (page - 1) * count + "," + count;
DataTable dt = db.reDt(sqlstr);
XS.DataSource = dt;
XS.DataBind();
if (XS.Rows.Count == 0)
{
Response.Write("<script>alert('搜索不到资源')</script>");
}
}
}我上一页和下一页已经实现了.不过呢,我想在写个判断.就是没有上一页了点击上一页会弹出没有上一页的提示
//上一页
protected void last_Click(object sender, EventArgs e)
{
this.page = Convert.ToInt16(this.nowPage.Value);
this.page = this.page - 1;
if (this.page < 1)
{
this.page = 1;
}
this.nowPage.Value = Convert.ToString(this.page);
//这个if怎么判断呢？ 如何判断当前不能上一页
if()
{
}
GVxs();
CX_Click(null, null);
}
//下一页
protected void next_Click(object sender, EventArgs e)
{
this.page = Convert.ToInt16(this.nowPage.Value);
this.page = this.page + 1;
this.nowPage.Value = Convert.ToString(this.page);
//这个也是如何判断当前没有下一页了？
if(){}
GVxs();
CX_Click(null, null);
}首页和尾页 以及页数显示怎么写？
米有思路.
我数据库是mysql
把代码直接贴出来把,大神
...全文
相关推荐
纯JS前端实现分页代码
虽然这个例子可能并不完美，但它提供了一个基础的实现思路，开发者可以根据实际需求进行改进和扩展。
PHP和MYSQL实现分页导航思路详解
在代码实现中，如下这段代码展示了如何根据传递的页码参数和每页显示记录数来动态生成SQL查询语句：```php$start = ($page - 1) * $records_per_page;$sql =
浅谈分页思路
t) WHERE r > ?```这里，`?`表示参数占位符，第一个参数用于指定最大行号，第二个参数用于指定最小行号，这两个参数根据当前页数和每页数据条数计算得出。
Repeater全选删除和分页实现思路及代码
知识点：.NET Web开发中Repeater控件的全选删除和分页功能的实现思路和代码示例在.NET Web开发中，Repeater控件是一种用于数据绑定的服务器控件，它可以重复显示数据源中的信息。
仿javaeye的分页代码 非常经典 超级棒的分页代码 分页精华
### 知识点一：JavaScript分页插件的设计思路此段代码为一个简单的JavaScript分页插件，名为`showPages`。它通过自定义函数的方式实现了页面分页的功能。
