留言栏代码

try
{
myConn.Open() ;
myCommand.ExecuteNonQuery() ;
//清场
myConn.Close() ;
}
catch(Exception e)
{
throw(new Exception( "取贴子失败: " + e.ToString())) ;
//
// date: 2000/06/06
//
// 作者： 天啦
/// ////////////////////////////////////////////////////////////////
/// <summary>
/// Summary description for notepage.
{
//
// TODO: Add Constructor Logic here
//
//读取数据库
myconn myConn = new myconn();
SQLCommand myCommand = new SQLCommand() ;
{
//定义一个forum数组做为返回值
ArrayList arrForumList =new ArrayList() ;
//从数据库中conn();
SQLCommand myCommand = new SQLCommand() ;
}
/// <summary>
///
/// 目的：将留言的内容入库
///
/// 利用构造函数来传递信息
///
/// </summary>
/// <param name= "n_Topic "> </param>
public bool AddTopic(notepage n_Topic)
myCommand.Parameters.Add(new SQLParameter( "@a_strTitle " , SQLDataType.VarChar,100)) ;
myCommand.Parameters[ "@a_strTitle "].Value = n_Topic.Title ;
}
set
{
n_intID = value;
}
}
public string Title
{
get
{
return n_strTitle ;
}
set
{
n_strTitle = value;
}
}
public string Author
set
{
n_strContent = value ;
}
}
public DateTime adddate
{
get
{
return n_dateTime;
}
set
{
n_dateTime = value;
}
}
//构造函数
private string n_strContent ; //留言内容
private DateTime n_dateTime ; //留言时间
//属性
public int ID
{
get
{
return n_intID ;
myCommand.ActiveConnection = myConn ;
mandText = "n_addTopic " ; //调用存储过程
mandType = CommandType.StoredProcedure ;
public notepage()
{
//
// TODO: Add Constructor Logic here
//
this.n_intID = 0 ;
this.n_strTitle = " " ;
this.n_strAuthor = " " ;
/// </summary>
public class notepage
{
//私有变量
private int n_intID ; //ID编号
private string n_strTitle ; //主题
private string n_strAuthor ; //留言人
objItem.Author = myReader[ "Author "].ToString() ;
objItem.adddate = myReader[ "adddate "].ToString().ToDateTime();
objItem.Content = myReader[ "Content "].ToString();
myCommand.Execute(out myReader) ;
if (myReader.Read())
{
objNp.ID = (int)myReader[ "ID "] ;
objNp.Title = (string)myReader[ "Title "] ;
myCommand.ActiveConnection = myConn ;
mandText = "n_GetTopicList " ; //调用存储过程
mandType = CommandType.StoredProcedure ;
try
{
myConn.Open() ;
SQLDataReader myReader ;
myCommand.Execute(out myReader) ;
for (int i = 0 ; myReader.Read() ; i++)
{
notepage objItem = new notepage() ;
objItem.ID = myReader[ "ID "].ToString().ToInt32() ;
objItem.Title = myReader[ "Title "].ToString() ;
myCommand.Parameters.Add(new SQLParameter( "@a_strAuthor " , SQLDataType.VarChar,50)) ;
myCommand.Parameters[ "@a_strAuthor "].Value = n_Topic.Author ;
mandType = CommandType.StoredProcedure ;
myCommand.Parameters.Add(new SQLParameter( "@a_intTopicID " , SQLDataType.Int)) ;
}
//清场
myReader.Close();
myConn.Close() ;
}
catch(Exception e)
{
throw(new Exception( "取贴子失败: " + e.ToString())) ;
}
return objNp;
using System.Collections ;
////////////////////////////////////////////////////////////////////
//
// Class Name : 留言板
//
// Description: 构造一个留言板对象
myCommand.Parameters.Add(new SQLParameter( "@a_strContent " , SQLDataType.VarChar,2000)) ;
myCommand.Parameters[ "@a_strContent "].Value = n_Topic.Content ;
this.n_strContent = " " ;
this.n_dateTime = System.DateTime.Now;
}
/// <summary>
///
/// 取得留言的内容
///
/// </summary>
/// <param name= "a_intID "> </param>
objNp.Author = (string)myReader[ "Author "] ;
objNp.Content = (string)myReader[ "Content "];
objNp.adddate = (DateTime)myReader[ "adddate "];
{
get
{
return n_strAuthor ;
}
set
{
n_strAuthor = value ;
}
}
public string Content
{
get
{
return n_strContent ;