发布一个文章读取模块，有前一篇和后一篇文章的功能，存储过程我直接贴上来了，大家自己改吧！

本文链接：https://blog.csdn.net/onkinsen/article/details/42323761

大家都是程序员！我会继续开源我的程序！加油吧！我爱你们！祝大家新年快乐！呵呵！都不要改行啊！！！

存储过程

读取新闻

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

------------------------------------
--用途：得到实体对象的详细信息 
--项目名称：
--说明：
--时间：2014/12/15 4:05:16
------------------------------------
ALTER PROCEDURE [dbo].[cnews_GetModel]
@nid int
 AS 
	SELECT 
	nid,ntime,nauthor,nname,ntype1,ntype2,ncontent,nimage
	 FROM [cnews]
	 WHERE nid=@nid

读取上一篇

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--用途：查询上一条新闻
--项目名称：
--说明：
--时间：2014/12/28 1:40:34
------------------------------------
ALTER PROCEDURE [dbo].[cnews_top]
@nid int
AS
	DECLARE @TempID int
	SELECT TOP(1) nid,nname FROM cnews WHERE (nid<@nid) and  (ntype2='cchrbig')  ORDER BY nid DESC
	IF @TempID = 0
		RETURN 0
	ELSE
		RETURN 1

读取下一条

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--用途：查询下一条新闻
--项目名称：
--说明：
--时间：2014/12/28 1:40:34
------------------------------------
ALTER PROCEDURE [dbo].[cnews_down]
@nid int
AS
	DECLARE @TempID int
SELECT TOP(1) nid,nname FROM cnews WHERE (nid>@nid)and (ntype2='cchrbig') ORDER BY nid ASC	
IF @TempID = 0
		RETURN 0
	ELSE
		RETURN 1

页面前台

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="news.aspx.cs" Inherits="news" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
     <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
        <br />
        <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
        <br />
        <br />
        前一篇文章<asp:HyperLink ID="HyperLink1" runat="server">HyperLink</asp:HyperLink>
        后一篇文章<asp:HyperLink ID="HyperLink2" runat="server">HyperLink</asp:HyperLink>
    
    </div>
    </form>
</body>
</html>

页面后台

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class news : System.Web.UI.Page
{
    //初始化一个连接开关
    SqlConnection myConn = DBClass.GetConnection();
    protected void Page_Load(object sender, EventArgs e)
    {
        string id = Request.QueryString["id"];
        int nid = Convert.ToInt32(id);
        if (!IsPostBack)
        {
            myConn.Open();

            SqlCommand cmd2 = new SqlCommand("cnews_GetModel", myConn);
            cmd2.CommandType = CommandType.StoredProcedure;
            SqlParameter nid2 = new SqlParameter("@nid", SqlDbType.Int, 4);
            nid2.Value = nid.ToString();
            cmd2.Parameters.Add(nid2);
            SqlDataReader dr = cmd2.ExecuteReader();
            dr.Read();
            this.Page.Title = dr["nname"].ToString();
            Label1.Text = dr["nname"].ToString();
            Label2.Text = dr["ncontent"].ToString();
            myConn.Close();
           

            try
            {
                myConn.Open();
                SqlCommand cmd3 = new SqlCommand("cnews_top", myConn);
            cmd3.CommandType = CommandType.StoredProcedure;
            SqlParameter nid3 = new SqlParameter("@nid", SqlDbType.Int, 4);
            nid3.Value = nid.ToString();
            cmd3.Parameters.Add(nid3);
            SqlDataReader dr3 = cmd3.ExecuteReader();
            dr3.Read();
            HyperLink1.Text=dr3["nname"].ToString();
            string aaaa = dr3["nid"].ToString();
            HyperLink1.NavigateUrl = "news.aspx?id=" + aaaa;
           }

            catch (Exception)
            {
                Response.Redirect("default.aspx");
            }
            finally
            {
                myConn.Close();
            }
            myConn.Open();

            try
            {
                SqlCommand cmd4 = new SqlCommand("cnews_down", myConn);
                cmd4.CommandType = CommandType.StoredProcedure;
                SqlParameter nid4 = new SqlParameter("@nid", SqlDbType.Int, 4);
                nid4.Value = nid.ToString();
                cmd4.Parameters.Add(nid4);
                SqlDataReader dr4 = cmd4.ExecuteReader();
                dr4.Read();
                HyperLink2.Text = dr4["nname"].ToString();
                string aaaa1 = dr4["nid"].ToString();
                HyperLink2.NavigateUrl = "news.aspx?id=" + aaaa1;
            }

            catch (Exception)
            {
                Response.Redirect("default.aspx");
            }
            finally
            {
                myConn.Close();
            }
        }
    }
}