论坛公告数据表

ForumNotice

ID OleDbType.Integer 
ForumID OleDbType.Integer 讨论区ID
UserName OleDbType.VarWChar(20) 用户名
NoticeTitle OleDbType.VarWChar(50) 公告标题
NoticeData OleDbType.VarWChar 公告内容
AddTime OleDbType.Date 添加时间

添加存储过程
AddData_ForumNotice
INSERT INTO ForumNotice ( ForumID, NoticeTitle, NoticeData )
VALUES ([@ForumID], [@NoticeTitle], [@NoticeData]);

获取指点定版块所有公告
GetDataOnForumID_ForumNotice
SELECT ForumNotice.ID, ForumNotice.ForumID, ForumNotice.UserName, ForumNotice.NoticeTitle, ForumNotice.AddTime
FROM ForumNotice
WHERE (((ForumNotice.ForumID)=[@ForumID]))
ORDER BY ForumNotice.ID DESC;

根据ID获取数据
GetDataOnID_ForumNotice
SQL:
SELECT ForumNotice.ForumID, ForumNotice.UserName, ForumNotice.NoticeTitle, ForumNotice.NoticeData, ForumNotice.AddTime
FROM ForumNotice
WHERE ForumNotice.ID = @ID;

根据ID删除公告
DelOnID_ForumNotice
SQL:
DELETE *
FROM ForumNotice
WHERE ID=[@ID];

根据ID修改公告
UpdateOnID_ForumNotice
SQL:
UPDATE ForumNotice
SET ForumID = @ForumID,NoticeTitle = @NoticeTitle,NoticeData = @NoticeData
WHERE ID = @ID