woyaodubo 2012-06-11 06:18:50

网上找的一个方法,试了下不行的.

出来的结果,源代码: <a href=''></a>

news.aspx:

上一篇:<a href='<%# preurl %>'><%# pretitle %></a>

news.aspx.cs:

        //上一篇,下一篇

        protected void pre_next()

        {

            int now_id;

            try

            {

                now_id = Convert.ToInt32(Request.QueryString["id"].ToString());



            }

            catch

            {

                now_id = 0;

            }



            

            string pre_Sql = "select top 1 title,max(id) from news where id < now_id";

            

            string next_Sql = "select top 1 title,min(id) from news where id > now_id";

            cn.Open();

            SqlCommand cmd1 = new SqlCommand(pre_Sql, cn);

            SqlDataReader sdr1 = cmd1.ExecuteReader();



            if (sdr1.Read())

            {

                pretitle = sdr1["title"].ToString().Trim();

                preurl = "Article.aspx?id=" + sdr1["id"].ToString() + " ";

            }

            else

            {

                pretitle = "第一篇了。";

            }



            cmd1.Dispose();

            sdr1.Close();



            SqlCommand cmd2 = new SqlCommand(next_Sql, cn);

            SqlDataReader sdr2 = cmd2.ExecuteReader();



            if (sdr2.Read())

            {

                nexttitle = sdr2["title"].ToString().Trim();

                nexturl = "Article.aspx?id=" + sdr2["id"].ToString() + " ";

            }

            else

            {

                nexttitle = "最后一篇了";

            }

            sdr2.Close();

            cmd2.Dispose();

            cn.Close();

        }

...全文

86 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

woyaodubo 2012-06-11

打赏
举报

[Quote=引用 11 楼的回复:]
你新建一个页面，把我那些代码拷过去运行下。错误应该不再我这个代码。
[/Quote]

有点搞不懂了,
先送分.

licai1210 2012-06-11

打赏
举报

你新建一个页面，把我那些代码拷过去运行下。错误应该不再我这个代码。

woyaodubo 2012-06-11

打赏
举报

[Quote=引用 9 楼的回复:]
HTML code
<form id="form1" runat="server">
<div>
<a id="A1" runat="server">
<%# pretitle %></a>
</div>
</form>

C# code
public string pretitle = stri……
[/Quote]

有错,

错误 34 类、结构或接口成员声明中的标记“=”无效

licai1210 2012-06-11

打赏
举报

    <form id="form1" runat="server">

    <div>

        <a id="A1" runat="server">

            <%# pretitle %></a>

    </div>

    </form>

    public string pretitle = string.Empty;

    protected void Page_Load(object sender, EventArgs e)

    {

        pretitle = "标题";

        A1.DataBind();

    }

woyaodubo 2012-06-11

打赏
举报

[Quote=引用 6 楼的回复:]
string pre_Sql = "select top 1 title,max(id) from news where id < now_id";

string next_Sql = "select top 1 title,min(id) from news where id > now_id";

这两句有错了..

string pre_Sql = "select……
[/Quote]

改过来了, 还是没出结果.

woyaodubo 2012-06-11

打赏
举报

csover8 2012-06-11

打赏
举报

string pre_Sql = "select top 1 title,max(id) from news where id < now_id";

string next_Sql = "select top 1 title,min(id) from news where id > now_id";

这两句有错了..

string pre_Sql = "select top 1 title,max(id) from news where id < " + now_id;

string next_Sql = "select top 1 title,min(id) from news where id > " + now_id;

woyaodubo 2012-06-11

打赏
举报

[Quote=引用 2 楼的回复:]
news.aspx.cs代码贴全一些..
[/Quote]

protected void pre_next()
这个函数放在Page_Load里面的.

woyaodubo 2012-06-11

打赏
举报

[Quote=引用 2 楼的回复:]
news.aspx.cs代码贴全一些..
[/Quote]

//Page_Load外面定义了四个变量,一个数据库链接:

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["new_conn"].ConnectionString);

//这个连接没错的, 一直都在用它.



        public string pretitle;

        public string preurl;

        public string nexttitle;

        public string nexturl;