• .net中点击button按钮显示下一条记录(上一条 下一条)


    /// <summary>
       
    /// 取出前后新闻,产生连接,如果前后都有则占2行.
       
    /// </summary>
       
    /// <param name="articleid">目前记录id</param>
       
    /// <returns></returns>
        public string _4S_article_link(string articleid, string page)
        {
            StringBuilder str
    = new StringBuilder("");
            con.SetDefaultConnection(constr);
           
    string sql = "SELECT classname FROM db_article WHERE (articleid = @articleid)";
            SqlParameter[] prams
    = new SqlParameter[1];
            prams[
    0] = new SqlParameter("@articleid", articleid);
            DataRow row
    = con.Row(sql, prams);
           
    string classname = row["classname"].ToString();
            sql
    = "SELECT TOP 1 articleid FROM db_article WHERE (articleid < @articleid) AND (classname = '" + classname + "') ORDER BY articleid DESC";
            prams[
    0].ParameterName = "@articleid";
            prams[
    0].Value = articleid;

            row
    = con.Row(sql, prams);
           
    if (row != null)
            {
                str.Append(
    "<a href='"+page+"?id=" + classname.Substring(5) +"&articleid=");
                str.Append(row[
    "articleid"].ToString());
                str.Append(
    "'><span style='color: #000099'>上一条");
                str.Append(
    "</span></a>");
            }
            sql
    = "SELECT TOP 1 articleid FROM db_article WHERE (articleid > @articleid) AND (classname = '" + classname + "') ORDER BY articleid";
            row
    = con.Row(sql, prams);
           
    if (row != null)
            {
                str.Append(
    "&nbsp;&nbsp;&nbsp;&nbsp;<a href='"+page+"?id=" + classname.Substring(5) + "&articleid=");
                str.Append(row[
    "articleid"].ToString());
                str.Append(
    "'><span style='color: #000099'>下一条");
                str.Append(
    "</span></a>&nbsp;&nbsp;&nbsp;&nbsp;");
            }
           
    else
                str.Append(
    "&nbsp;&nbsp;&nbsp;&nbsp;");
           
    return str.ToString();
        }
  • 相关阅读:
    关于hql执行带有case when 的语句问题,另:数据表的倒置
    xslt 转换 xml
    xsd校验xml
    java 调用存储过程
    js return无效,表单自动提交
    bat 启动java程序
    Delphi 窗体拖动,无边框,透明的设置
    installshield实例(三)发布,补丁,升级
    Installshield实例(二)创建自定义界面
    InstallShield 实例(一)检测JDK,MYSQL,创建数据库
  • 原文地址:https://www.cnblogs.com/liufei88866/p/1293515.html
Copyright © 2020-2023  润新知