📄 board.aspx
字号:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<title>欣欣在线论坛</title>
<style TYPE="text/css">
<!--
td{font-size:9pt;}
-->
</style>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e)
{
// 从Web.config文件中读取连接字符串
String strConn=ConfigurationSettings.AppSettings["eForum"];
// 创建Connection对象cnMain
SqlConnection cnMain=new SqlConnection(strConn);
// 打开cnMain
cnMain.Open();
// 构造SQL语句，该语句选择所有的主版
String strMain="select * from MainBoards";
// 创建Command对象cmMain
SqlCommand cmMain=new SqlCommand(strMain,cnMain);
// 执行ExecuteReader()方法得到drMain
SqlDataReader drMain=cmMain.ExecuteReader();
// 显示主版
Response.Write("<body leftmargin='5' bgcolor='#FFFFEB'>");
Response.Write("<center>");
Response.Write("<table border='1' cellpadding='0' cellspacing='0'"+
" bordercolor='#0B591E' bordercolorlight='#0B591E' "+
"bordercolordark='#0B591E'>");
Response.Write("<tr><td valign='top'>");
Response.Write("<table border='0' cellpadding='0' cellspacing='0'>");
Response.Write("<tr><td width='127' bgcolor='#0F986A' valign='top'>");
Response.Write("<p align='center'><strong><font color='white'>");
Response.Write("选择版块</font></strong>");
Response.Write("</td></tr>");
while(drMain.Read()) {
Response.Write("<tr><td id='item"+drMain["MainID"]+"' width='160'"+
" style=' cursor:hand;' language='javascript' "+"onMouseUp="+
"'openbrd(brd"+drMain["MainID"]+",img"+drMain["MainID"]+");'>"+
"<img src='./images/plus.gif' id='img"+drMain["MainID"]+"' "+
"width='12' height='12'>"+drMain["MainName"]);
Response.Write("</td></tr>");
Response.Write("<tr><td width='160' id='brd"+
drMain["MainID"]+"' style='Display:none;'>");
Response.Write("<table border='0' width='100%' "+
"cellpadding='0' cellspacing='0'>");
Response.Write("<tr><td width='100%'>");
// 创建Connection对象cnSub
SqlConnection cnSub=new SqlConnection(strConn);
// 打开cnSub
cnSub.Open();
// 构造SQL语句，该语句选择主版的所有子版
String strSub="select * from SubBoards where "+
"MainID='"+drMain["MainID"]+"'";
// 创建Command对象cmSub
SqlCommand cmSub=new SqlCommand(strSub,cnSub);
// 执行ExecuteReader()方法得到drSub
SqlDataReader drSub=cmSub.ExecuteReader();
// 显示子版
while(drSub.Read()) {
Response.Write("<a href='display.aspx?subid="+drSub["SubID"]+
"' target=thread><img src='./images/item1.gif' "+
"width=32 height=13 border=0 align='absmiddle'>"+
drSub["SubName"]+"</a><br>");
}
// 关闭cnSub
cnSub.Close();
Response.Write("</td></tr>");
Response.Write("</table>");
Response.Write("</td></tr>");
}
// 关闭连接
cnMain.Close();
Response.Write("</table>");
Response.Write("</table>");
Response.Write("</body>");
}
</script>
</html>
<script language="javascript">
function openbrd(brd,img)
{
if(brd.style.display=="none"){
brd.style.display="";
img.src="./images/negative.gif";
} else {
brd.style.display="none";
img.src="./images/plus.gif";
}
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -