📄 readnews.aspx

📁 ASP.NET Web Forms Techniques
💻 ASPX
字号:
<%@ Page Language="C#" EnableViewState="False" EnableSessionState="ReadOnly" SmartNavigation="True"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<%@Register TagPrefix="wcc" TagName="pagebanner" Src="ascx/pagebanner.ascx" %>
<%@Register TagPrefix="wcc" TagName="mainlink" Src="ascx/mainlink.ascx" %>
<%@Register TagPrefix="wcc" TagName="footerlinks" Src="ascx/footerlinks.ascx" %>

<script runat="server">
// -------------------------------------------------------------------

// page-level variable to style sheet size
String sStyleSize = "Standard";

// -------------------------------------------------------------------

void Page_Load() {

  // get style sheet size from Session
  sStyleSize = (String)Session["WccStyleSize"];

  // if no value, session has expired or user entered
  // site at page other than "Home" page
  if (sStyleSize == "") {
    Response.Clear();
    Response.Redirect("default.aspx");
  }

  // get news item ID and display the contents
  String sNewsID = Request.QueryString["id"];
  if (sNewsID != "" && sNewsID != null) {
    SqlDataReader dr = GetNewsItemDR(int.Parse(sNewsID));
    if (dr == null) {
      pNewsText.InnerHtml = "Could not read from database";
    }
    else {
      if (dr.Read()) {
        pNewsTitle.InnerHtml = "<b>" + dr.GetString(1) + "</b>";
        pNewsText.InnerHtml = dr.GetString(3);
      }
    }
  }
}

// -------------------------------------------------------------------

// function to get selected news item from database
SqlDataReader GetNewsItemDR(int iItemID) {
  try {
    String sConnect = ConfigurationSettings.AppSettings["XroxCarsConnectString"];
    SqlConnection sqlConnect = new SqlConnection(sConnect);
    String sProcName = "GetNewsItem";
    SqlCommand sqlComm = new SqlCommand(sProcName, sqlConnect);
    sqlComm.CommandType = CommandType.StoredProcedure;
    sqlComm.Parameters.Add("@ItemID", iItemID);
    sqlConnect.Open();
    return sqlComm.ExecuteReader(CommandBehavior.CloseConnection);
  }
  catch (Exception e) {
    return null;
  }
}

// -------------------------------------------------------------------
// -------------------------------------------------------------------
</script>


<!doctype html public "-//W3C//DTD HTML 3.2 Final//EN">
<html>
<head>
<basefont size="2" face="Tahoma,Arial,Helvetica,sans-serif">
<link rel="stylesheet" type="text/css" href="stylesheets/wcc<% = sStyleSize %>.css" />
<title>Xrox Car Company - News and Reviews</title>
</head>
<body leftmargin="0" rightmargin="0" topmargin="0"
      bgcolor="#ffffff" class="body-text"><div style="position:absolute;height:0px;"><font size="1" color=#ffffff">

<!-- skip link for aural page readers -->
<layer visibility="hidden">
<a href="#content" style="color:#ffffff;font-size:1px;text-decoration:none"><img width="1" height="1" hspace="0" vspace="0" src="images/_blnk.gif" border="0" alt="Skip to Content" /></a>
</layer>

</font></div><wcc:pagebanner runat="server" />
<br />
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tbody>
 <tr>
  <td valign="top" width="110px">
    <wcc:mainlink runat="server" />
  </td>
  <td align="left" class="body-text">
    <a name="content" />
    <font face="Arial,Helvetica,sans-serif" size="4" color="#b50055">
    <p id="pNewsTitle" class="large-red-text" runat="server" /></font>
    <font face="Tahoma,Arial,Helvetica,sans-serif" size="2">
    <p id="pNewsText" class="body-text" runat="server" /></font>
  </td>
 </tr>
</tbody>
</table>

<wcc:footerlinks runat="server" />

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -