一段显示论坛贴子的程序

///////////////////////////////////////////////////////////////////////////////
//
// File name:         showtopic.cs
//
// Description:       showtopic.aspx的后台代码
//
// date:              2000/11/01
//
// Programming:       Bigeagle
//
// History:           version 1.0
//                    start at 2000/11/01 11:00  finish at
//
////////////////////////////////////////////////////////////////////////////////

using BBS ;                           //my own namespace
using System;
using System.Data;
using System.Data.SQL;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Drawing ;
using System.Web.Security ;
using System.Collections ;
using System.Text.RegularExpressions ;


public class ShowTopic : Page
{

    public int ForumID ;
    public int ID ;

    public Label lblForumName ;              //板块名称
    public HyperLink linkMaster ;            //斑竹连接
    public Label lblTopicCounts ;            //论坛贴子数
    public HtmlImage imgNew1 ;               //是否新贴子图片
    public HtmlImage imgOICQ ;               //oicq图片
    public HyperLink linkForumName ;         //板块名称
    public HyperLink linkPrev ;              //上一主题
    public HyperLink linkPrev1 ;              //上一主题
    public HyperLink linkNext ;              //下一主题
    public HyperLink linkNext1 ;              //下一主题
    public Panel panReply ;                   //回复

    //本贴
    public HyperLink linkAuthor ;            //作者
    public Label lblTitle ;                  //主题
    public Label lblPostTime ;               //发表时间
    public Label lblHits ;                   //本贴点击数
    public HtmlGenericControl  divSignature ;     //用户签名
    public HtmlGenericControl  divContent ;     //内容
    public HtmlImage imgFace ;               //表情图片
  
    public void Page_Load(object sender , EventArgs e)
    {
        int m_intID = 0;
        //取页面参数
        try
        {
            m_intID = Request.QueryString["id"].ToInt32() ;
            ID = m_intID ;
        }
        catch(Exception exp)
        {
            Response.Write("[ln48]:" + exp.ToString());
         
        }     
        finally
        {
     
            Dictionary objUserList = (Dictionary)Application["User"] ;    //用户列表
     
            //取贴子
            SQLConnection myConnection = new SQLConnection("server=server1;uid=sa;pwd=;database=BBS");
            SQLCommand myCommand = new SQLCommand("up_GetTopics" , myConnection);

            myCommand.ActiveConnection = myConnection ;
            myCommand.CommandType = CommandType.StoredProcedure;
      
            SQLParameter workParam = null;

            //贴子id
            workParam = myCommand.Parameters.Add(new SQLParameter("@a_intID", SQLDataType.Int, 4));
            workParam.Direction = ParameterDirection.Input;
            workParam.Value = m_intID ;
        
            SQLDataReader myReader ;
          
            try
            {
                myConnection.Open();
                myCommand.Execute(out myReader);
          
                //首先取出上一主题、下一主题的id号
                if (myReader.Read())
                {    
                    linkPrev.NavigateUrl  = (int)myReader["ProvID"]==0 ? "" : "showtopic.aspx?id=" + myReader["ProvID"].ToString() ;
                    linkPrev1.NavigateUrl = linkPrev.NavigateUrl ;
                    linkNext.NavigateUrl  = (int)myReader["NextID"]==0 ? "" : "showtopic.aspx?id=" + myReader["NextID"].ToString() ;
                    linkNext1.NavigateUrl = linkNext.NavigateUrl ;
                }
                else
                {
                    Response.Redirect("default.aspx") ;
                }  
                
                
                //取出论坛信息             
                //if (myReader.NextResult() )
                //{
                    //myReader.Read() ;
                    //显示板块信息
                 
                    //Response.Write(myReader.FieldCount.ToString() );
                    //ShowForumInfo(5) ;
                /