这是一个单独的aspx文件
无须.cs,因为根本没有使用codebehind
无须.cs,因为根本没有使用codebehind
解决方案 »
- 网页中输入公式的解决方案
- 一个费解的问题,datalist不能修改数据项?
- 问一个TABLE布局的新手问题
- e.Item .FindControl ("lblFlag12")为什么抓不到绑定的值呢?请帮忙看看!!!
- 求取TabStrip1的CSS文件?
- iframe的数据绑定问题,重要请教?!?!
- asp.net1.1中,带单选框的treeview
- 我不想在页面上显示控件,因为控件里面全是数据库的类的处理,,我用不着将控件显示在页面上,只需要调用它的方法,我研究了webdiyer的控
- 在javascript里面怎么样给DropDownList赋值?
- SessionID的问题
- 一句话解决!
- 请问一下 DataGrid1_UpdateCommand 怎么样使用?
无须.cs,因为根本没有使用codebehind
那么应该怎么写呢?是不是下面的:
<%@ Page language="c#" Codebehind="board.aspx.cs" AutoEventWireup="false" Inherits="lwei.board" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<TITLE>主版块</TITLE>
</HEAD>
<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' "+"onfiltered="+
"'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>
<FONT face="宋体"></FONT>
</HTML>
谢谢!!!
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<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' "+"onfiltered="+
"'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>
<HTML>
<HEAD>
<TITLE>主版块</TITLE>
</HEAD>
<body>内容
</body>
</HTML>