ManageBoard.aspx页面代码： <%@ Page Language="C#" CodeFile="ManageBoard.aspx.cs" Inherits="Admin_ManageBoard" %> <%@ Import Namespace="System.Data" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>无标题页</title> </head> <body> <form id="form1" runat="server"> <asp:Repeater ID="rpt_Class" runat="server" onitemcommand="rpt_Class_ItemCommand"> <HeaderTemplate> <table cellpadding="3" cellspacing="1" style ="font-size:9px;font-family:Verdana;"> <tr> <td> 新建分类<asp:TextBox ID ="tb_NewClassName" runat="server"></asp:TextBox> <asp:Button ID ="btn_AddClass" runat="server" CommandName="AddClass" Text="O添加分类" /> </td`> </tr> </HeaderTemplate> <ItemTemplate> <tr style ="background-color:#f0f0f0"> <td> <asp:Button ID ="btn_DelClass" runat ="server" CommandArgument="<%#eval_r("ClassName") %>' CommandName="DelClass" Text="×删除分类" OnClientClick="return confirm("确定删除分类吗？删除分类会清楚分类下所有版块以及版块下的所有帖子！')" /> <asp:TextBox ID ="tb_ClassName" runat ="server" Text="<%#eval_r("ClassName") %>' /> <asp:Button ID ="btn_ModifyClass" runat ="server" CommandArgument="<%#eval_r("ClassID") %>' CommandName="ModifyClass" Text="√修改分类" /> </td> </tr> <tr> <td> 在此分类下添加版块<asp:TextBox ID ="tb_NewBoardName" runat ="server"></asp:TextBox> <asp:Button ID="btn_AddBoard" runat ="server" CommandArgument="<%#eval_r("ClassID") %>' CommandName="AddBoard" Text="○添加版块" /> </td> </tr> <asp:Repeater ID="rpt_Board" runat ="server" DataSource="<%# ((DataRowView)Container.DataItem).Row.GetChildRows("RelationBetweenClassAndBoard") %>' OnItemCommand="rpt_Board_ItemCommand"> <ItemTemplate> <tr> <td> |---------------------------- <asp:Button ID="btn_DelClass" runat="server" CommandArgument="<%# eval_r("["BoardID"]") %>' CommandName="DelBoard" Text="×删除版块" OnClientClick="return confirm("确实删除版块吗？删除版块会清除版块下的所有帖子！')"/> <asp:TextBox ID="tb_BoardName" runat="server" Text="<%# eval_r("["BoardName"]") %>'></asp:TextBox> <asp:Button ID="btn_ModifyBoard" runat="server" CommandArgument="<%# eval_r("["BoardID"]")%>' CommandName="ModifyBoard" Text="√修改版块" /> </td> </tr> </ItemTemplate> </asp:Repeater> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:Repeater> <%-- <asp:Repeater ID="rpt_Class" runat="server" OnItemCommand="rpt_Class_ItemCommand"> <HeaderTemplate> <table> <tr> <td> <asp:TextBox ID="tb1" runat="server" /> <asp:Button ID="bt1" runat="server" Text="√新建分类" CommandName="AddClass" /> <br /> ^_^ -------------------------------------------------- (⊙o⊙) ---------------------------------------------------- ^_^ </td> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td> <asp:Button ID="bt2" runat="server" Text="×删除分类" CommandName="DelClass" CommandArgument="<%# eval_r("ClassID")%>' OnClientClick="return confirm("确定删除吗?删除分类会清除此分类下的所有的版块和帖子!')" /> <asp:TextBox ID="tb2" runat="server" Text="<%# eval_r("ClassName")%>'></asp:TextBox> <asp:Button ID="bt3" runat="server" Text="0修改分类" CommandName="XgClass" CommandArgument="<%# eval_r("ClassID")%>'/> → 在此分类下添加板块<asp:TextBox ID="tb3" runat="server"></asp:TextBox> <asp:Button ID="bt4" runat="server" Text="√添加板块" CommandName="AddBoard" CommandArgument="<%# eval_r("ClassID")%>' /> </td> </tr> <asp:Repeater ID="rpt_Board" runat="server" DataSource="<%# ((DataRowView)Container.DataItem).Row.GetChildRows("RelationBetweenClassAndBoard")%>'> <ItemTemplate> <tr> <td> 丨----------<asp:Button ID="bt5" runat="server" Text="×删除版块" CommandName="DelBoard" OnClientClick="return confirm("确定删除?删除版块会清除此版块下的所有帖子!')" CommandArgument="<%# eval_r("["BoardID"]")%>' /> <asp:TextBox ID="tb3" runat="server" Text="<%# eval_r("["BoardName"]")%>'></asp:TextBox> <asp:Button ID="bt6" runat="server" Text="0修改板块" CommandName="ModifyBoard" CommandArgument="<%# eval_r("["BoardID"]")%>' /> </td> </tr> </ItemTemplate> <FooterTemplate><tr><td><hr /></td></tr></FooterTemplate> </asp:Repeater> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:Repeater>--%> </form> </body> </html> ManageBoard .aspx.cs页面代码： using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class Admin_ManageBoard : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SetBind(); } } private string sConnectionString=ConfigurationManager .ConnectionStrings["ForumConnString"].ToString(); protected void rpt_Class_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "AddClass") { RepeaterItem ri = e.Item; TextBox tb = ri.FindControl("tb_NewClassName") as TextBox; using (SqlConnection conn = new SqlConnection(sConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("insert into tbClass(ClassName) values (@ClassName)", conn)) { cmd.Parameters.AddWithValue("@ClassName", tb.Text); cmd.ExecuteNonQuery(); SetBind(); } } } if (e.CommandName == "DelClass") { using (SqlConnection conn = new SqlConnection(sConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("delete tbTopic where TopicBoardID in (select BoardID from tbBoard wwhere BoardClass where BoardClassID=@CLassID);detele tbBoard where BoardClassID=@CLassID;detele tbClass where ClassID=@ClassID", conn)) { cmd.Parameters.AddWithValue("@ClassID", e.CommandArgument); cmd.ExecuteNonQuery(); SetBind(); } } } if (e.CommandName == "ModifyClass") { RepeaterItem ri = e.Item; TextBox tb = ri.FindControl("tb_ClassName") as TextBox; using (SqlConnection conn = new SqlConnection(sConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("Update tbClass set ClassName=@ClassName where ClassID=@ClassID", conn)) { cmd.Parameters.AddWithValue("@ClassName", tb.Text); cmd.Parameters.AddWithValue("@ClassID", e.CommandArgument); cmd.ExecuteNonQuery(); SetBind(); } } } } protected void rpt_Board_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "AddBoard") { RepeaterItem ri = e.Item; TextBox tb = ri.FindControl("tb_NewBoardName") as TextBox; using (SqlConnection conn = new SqlConnection(sConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("insert into tbBoard(BoardName,BoardClassID) values (@BoardName,@BoardClassID)", conn)) { cmd.Parameters.AddWithValue("@BoardName", tb.Text); cmd.Parameters.AddWithValue("@BoardClassID", e.CommandArgument); cmd.ExecuteNonQuery(); SetBind(); } } } if (e.CommandName == "DelBoard") { using (SqlConnection conn = new SqlConnection(sConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("delete tbTopic where TopicBoardID in(select BoardID from tbBoard where BoardClassID=@BoardID);delete tbBoard where BoardID=@BoardID", conn)) { cmd.Parameters.AddWithValue("@BoardID", e.CommandArgument); cmd.ExecuteNonQuery(); SetBind(); } } } if (e.CommandName == "ModifyBoard") { RepeaterItem ri = e.Item; TextBox tb = ri.FindControl("tb_NewBoardName") as TextBox; using (SqlConnection conn = new SqlConnection(sConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("updata tbBoard set BoardName=@BoardName where BoardID=@BoardID", conn)) { cmd.Parameters.AddWithValue("@BoardName", tb.Text); cmd.Parameters.AddWithValue("@BoardClassID", e.CommandArgument); cmd.ExecuteNonQuery(); SetBind(); } } } } private void SetBind() { DataSet ds = new DataSet(); using (SqlConnection conn = new SqlConnection(sConnectionString)) { SqlDataAdapter da = new SqlDataAdapter("select * from tbCLass;select *from tbBoard", conn); da.Fill(ds); //tbClass是类别表，tbBoard是版块表。如果说tbClass是计算机系，那tbBoard就是计算机网络专业、计算机软件等等，在tbClass中根据类别ID可以再tbBoard中找到多条几率的 //而，ds.relation 是关联父子表的，你可以看他们的字段，classid和boardclassid，之前就是根据boardclassid在classid中找不到所以才报错。在页面上面都是显示父子关系的 //就好比时，在数据库中找到计算机网络专业，但是却找不到他属于哪个系的。 我在到sql数据库中做个例子给你瞧瞧 } ds.Relations .Add("RelationBetweenClassAndBoard",ds.Tables [0].Columns ["ClassID"],ds.Tables [1].Columns ["BoardClassID"]); rpt_Class.DataSource = ds; rpt_Class.DataBind(); } } web.config页面代码： <?xml version="1.0"?> <!-- 注意: 除了手动编辑此文件以外，您还可以使用 Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的 “网站”->“Asp.Net 配置”选项。 设置和注释的完整列表在 machine.config.comments 中，该文件通常位于 \Windows\Microsoft.Net\Framework\v2.x\Config 中 --> <configuration> <configSections> <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"> <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"> <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"> <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/> <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/> </sectionGroup> </sectionGroup> </sectionGroup> </configSections> <appSettings> <add key="ForumName" value="简易论坛" /> <add key="FileUploadSizeLimit" value="10240" /> </appSettings> <connectionStrings> <add name="ForumConnString" connectionString="server=TSONG;database=Forum;Trusted_Connection=True" /> </connectionStrings > <system.web> <!-- 设置 compilation debug="true" 可将调试符号插入 已编译的页面中。但由于这会 影响性能，因此只在开发过程中将此值 设置为 true。 --> <compilation debug="true"> <assemblies> <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/> </assemblies> </compilation> <!-- 通过 <authentication> 节可以配置 ASP.NET 用来 识别进入用户的 安全身份验证模式。 --> <authentication mode="Windows"/> <!-- 如果在执行请求的过程中出现未处理的错误， 则通过 <customErrors> 节可以配置相应的处理步骤。具体说来， 开发人员通过该节可以配置 要显示的 html 错误页 以代替错误堆栈跟踪。 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors> --> <pages> <controls> <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> </controls> </pages> <httpHandlers> <remove verb="*" path="*.asmx"/> <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/> </httpHandlers> <httpModules> <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> </httpModules> </system.web> <system.codedom> <compilers> <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <providerOption name="CompilerVersion" value="v3.5"/> <providerOption name="WarnAsError" value="false"/> </compiler> <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" warningLevel="4" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <providerOption name="CompilerVersion" value="v3.5"/> <providerOption name="OptionInfer" value="true"/> <providerOption name="WarnAsError" value="false"/> </compiler> </compilers> </system.codedom> <!-- 在 Internet 信息服务 7.0 下运行 ASP.NET AJAX 需要 system.webServer 节。对早期版本的 IIS 来说则不需要此节。 --> <system.webServer> <validation validateIntegratedModeConfiguration="false"/> <modules> <remove name="ScriptModule"/> <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> </modules> <handlers> <remove name="WebServiceHandlerFactory-Integrated"/> <remove name="ScriptHandlerFactory"/> <remove name="ScriptHandlerFactoryAppServices"/> <remove name="ScriptResource"/> <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> </handlers> </system.webServer> <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/> </dependentAssembly> </assemblyBinding> </runtime> </configuration>
2578
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
