大家都是程序员!我会继续开源我的程序!加油吧!我爱你们!祝大家新年快乐!呵呵!都不要改行啊!!!
存储过程
读取新闻
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();
}
}
}
}