using
System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Default2 : System.Web.UI.Page
... {
private const string connectionStr = @"Data Source=.SQLEXPRESS;AttachDbFilename=D:QianTaoApp_Datadb.mdf;Integrated Security=True;User Instance=True";
protected void Page_Load(object sender, EventArgs e)
...{
if(!IsPostBack)
...{
SetBind();
}
}
protected void rptClass_ItemCommand(object source, RepeaterCommandEventArgs e)
...{
//判断是否添加类别
if (e.CommandName == "AddClass")
...{
TextBox tb = e.Item.FindControl("txtClassName") as TextBox;
using(SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using(SqlCommand cmd = new SqlCommand("insert into tb_Class(className) values(@className)", conn))
...{
cmd.Parameters.AddWithValue("@className", tb.Text);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否删除类别
if (e.CommandName == "DelClass")
...{
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("delete from tb_Module where classId=@classId;delete from tb_Class where id=@classId", conn))
...{
cmd.Parameters.AddWithValue("@classId", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否修改类别
if (e.CommandName == "UpdateClass")
...{
TextBox tb = e.Item.FindControl("txtClassName") as TextBox;
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("update tb_Class set className=@className where id=@id", conn))
...{
cmd.Parameters.AddWithValue("@className", tb.Text);
cmd.Parameters.AddWithValue("@id", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否添加模块
if (e.CommandName == "AddModule")
...{
TextBox tb = e.Item.FindControl("txtModuleName") as TextBox;
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("insert into tb_Module(classId,moduleName)values(@classId,@moduleName)", conn))
...{
cmd.Parameters.AddWithValue("@moduleName", tb.Text);
cmd.Parameters.AddWithValue("@classId", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
}
/**//**//**//**//**//**//**//// <summary>
/// 嵌套repeater的ItemCommand事件
/// </summary>
protected void rptModule_ItemCommand(object source, RepeaterCommandEventArgs e)
...{
//判断是否删除模块
if (e.CommandName == "DelModule")
...{
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("delete from tb_Module where id=@Id;", conn))
...{
cmd.Parameters.AddWithValue("@Id", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否修改模块
if (e.CommandName == "UpdateModule")
...{
TextBox tb = e.Item.FindControl("txtModuleName") as TextBox;
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("update tb_Module set moduleName=@Name where id=@id", conn))
...{
cmd.Parameters.AddWithValue("@Name", tb.Text);
cmd.Parameters.AddWithValue("@id", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
}
/**//**//**//**//**//**//**//// <summary>
/// 绑定Repeater
/// </summary>
private void SetBind()
...{
DataSet ds = new DataSet();
using(SqlConnection conn = new SqlConnection(connectionStr))
...{
SqlDataAdapter adapter =
new SqlDataAdapter("select * from tb_Class",conn);
adapter.Fill(ds);
}
rptClass.DataSource = ds;
rptClass.DataBind();
}
protected void rptClass_ItemDataBound(object sender, RepeaterItemEventArgs e)
...{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
...{
Repeater rpt = e.Item.FindControl("rptModule") as Repeater;
//找到分类Repeater关联的数据项
DataRowView rowv = (DataRowView)e.Item.DataItem;
//提取分类ID
int id = (int)rowv["id"];
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
SqlDataAdapter adapter =
new SqlDataAdapter("select * from tb_Module where classId="+ id +"", conn);
adapter.Fill(ds);
}
rpt.DataSource = ds;
rpt.DataBind();
}
}
}
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Default2 : System.Web.UI.Page
... {
private const string connectionStr = @"Data Source=.SQLEXPRESS;AttachDbFilename=D:QianTaoApp_Datadb.mdf;Integrated Security=True;User Instance=True";
protected void Page_Load(object sender, EventArgs e)
...{
if(!IsPostBack)
...{
SetBind();
}
}
protected void rptClass_ItemCommand(object source, RepeaterCommandEventArgs e)
...{
//判断是否添加类别
if (e.CommandName == "AddClass")
...{
TextBox tb = e.Item.FindControl("txtClassName") as TextBox;
using(SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using(SqlCommand cmd = new SqlCommand("insert into tb_Class(className) values(@className)", conn))
...{
cmd.Parameters.AddWithValue("@className", tb.Text);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否删除类别
if (e.CommandName == "DelClass")
...{
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("delete from tb_Module where classId=@classId;delete from tb_Class where id=@classId", conn))
...{
cmd.Parameters.AddWithValue("@classId", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否修改类别
if (e.CommandName == "UpdateClass")
...{
TextBox tb = e.Item.FindControl("txtClassName") as TextBox;
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("update tb_Class set className=@className where id=@id", conn))
...{
cmd.Parameters.AddWithValue("@className", tb.Text);
cmd.Parameters.AddWithValue("@id", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否添加模块
if (e.CommandName == "AddModule")
...{
TextBox tb = e.Item.FindControl("txtModuleName") as TextBox;
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("insert into tb_Module(classId,moduleName)values(@classId,@moduleName)", conn))
...{
cmd.Parameters.AddWithValue("@moduleName", tb.Text);
cmd.Parameters.AddWithValue("@classId", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
}
/**//**//**//**//**//**//**//// <summary>
/// 嵌套repeater的ItemCommand事件
/// </summary>
protected void rptModule_ItemCommand(object source, RepeaterCommandEventArgs e)
...{
//判断是否删除模块
if (e.CommandName == "DelModule")
...{
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("delete from tb_Module where id=@Id;", conn))
...{
cmd.Parameters.AddWithValue("@Id", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
//判断是否修改模块
if (e.CommandName == "UpdateModule")
...{
TextBox tb = e.Item.FindControl("txtModuleName") as TextBox;
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
conn.Open();
using (SqlCommand cmd = new SqlCommand("update tb_Module set moduleName=@Name where id=@id", conn))
...{
cmd.Parameters.AddWithValue("@Name", tb.Text);
cmd.Parameters.AddWithValue("@id", e.CommandArgument);
cmd.ExecuteNonQuery();
SetBind();
}
}
}
}
/**//**//**//**//**//**//**//// <summary>
/// 绑定Repeater
/// </summary>
private void SetBind()
...{
DataSet ds = new DataSet();
using(SqlConnection conn = new SqlConnection(connectionStr))
...{
SqlDataAdapter adapter =
new SqlDataAdapter("select * from tb_Class",conn);
adapter.Fill(ds);
}
rptClass.DataSource = ds;
rptClass.DataBind();
}
protected void rptClass_ItemDataBound(object sender, RepeaterItemEventArgs e)
...{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
...{
Repeater rpt = e.Item.FindControl("rptModule") as Repeater;
//找到分类Repeater关联的数据项
DataRowView rowv = (DataRowView)e.Item.DataItem;
//提取分类ID
int id = (int)rowv["id"];
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(connectionStr))
...{
SqlDataAdapter adapter =
new SqlDataAdapter("select * from tb_Module where classId="+ id +"", conn);
adapter.Fill(ds);
}
rpt.DataSource = ds;
rpt.DataBind();
}
}
}
<%
...
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2"
%>
<! 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" >
< div >
< asp:Repeater ID ="rptClass" runat ="server" OnItemCommand ="rptClass_ItemCommand" OnItemDataBound ="rptClass_ItemDataBound" >
< HeaderTemplate >
< table >
< tr style ="background-color:yellow" >
< td >
添加类别:
< asp:TextBox ID ="txtClassName" runat ="server" >
</ asp:TextBox >
< asp:Button ID ="btnAddClass" runat ="server" CommandName ="AddClass" Text ="添加" />
</ td >
</ tr >
</ HeaderTemplate >
< ItemTemplate >
< tr style ="background-color:#CCCCCC" >
< td >
< asp:Button ID ="btnDelClass" CommandArgument ='<%# Eval("id") % > ' CommandName="DelClass" runat="server" Text="删除类别" />
< asp:TextBox ID ="txtClassName" runat ="server" Text ='<%# Eval("className") % > '>
</ asp:TextBox >
< asp:Button ID ="btnUpdateClass" CommandArgument ='<%# Eval("id") % > ' CommandName="UpdateClass" runat="server" Text="修改类别" />
</ td >
</ tr >
< tr >
< td >
添加模块:
< asp:TextBox ID ="txtModuleName" runat ="server" >
</ asp:TextBox >
< asp:Button ID ="btnAddModule" runat ="server" CommandName ="AddModule" CommandArgument ='<%# Eval("id") % > ' Text="添加" />
</ td >
</ tr >
< tr >
< td >
< asp:Repeater ID ="rptModule" runat ="server"
OnItemCommand ='rptModule_ItemCommand' >
< ItemTemplate >
< tr >
< td >
-----------------
< asp:Button ID ="btnDeleteModule" CommandArgument ='<%# Eval("id") % > ' CommandName="DelModule" runat="server" Text="删除模块" />
< asp:TextBox ID ="txtModuleName" Text ='<%# Eval("moduleName") % > ' runat="server"> </ asp:TextBox >
< asp:Button ID ="btnUpdateModule" CommandArgument ='<%# Eval("id") % > ' CommandName="UpdateModule" runat="server" Text="修改模块" />
</ td >
</ tr >
</ ItemTemplate >
</ asp:Repeater >
</ td >
</ tr >
</ ItemTemplate >
< FooterTemplate >
</ table >
</ FooterTemplate >
</ asp:Repeater >
</ div >
</ form >
</ body >
</ html >
<! 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" >
< div >
< asp:Repeater ID ="rptClass" runat ="server" OnItemCommand ="rptClass_ItemCommand" OnItemDataBound ="rptClass_ItemDataBound" >
< HeaderTemplate >
< table >
< tr style ="background-color:yellow" >
< td >
添加类别:
< asp:TextBox ID ="txtClassName" runat ="server" >
</ asp:TextBox >
< asp:Button ID ="btnAddClass" runat ="server" CommandName ="AddClass" Text ="添加" />
</ td >
</ tr >
</ HeaderTemplate >
< ItemTemplate >
< tr style ="background-color:#CCCCCC" >
< td >
< asp:Button ID ="btnDelClass" CommandArgument ='<%# Eval("id") % > ' CommandName="DelClass" runat="server" Text="删除类别" />
< asp:TextBox ID ="txtClassName" runat ="server" Text ='<%# Eval("className") % > '>
</ asp:TextBox >
< asp:Button ID ="btnUpdateClass" CommandArgument ='<%# Eval("id") % > ' CommandName="UpdateClass" runat="server" Text="修改类别" />
</ td >
</ tr >
< tr >
< td >
添加模块:
< asp:TextBox ID ="txtModuleName" runat ="server" >
</ asp:TextBox >
< asp:Button ID ="btnAddModule" runat ="server" CommandName ="AddModule" CommandArgument ='<%# Eval("id") % > ' Text="添加" />
</ td >
</ tr >
< tr >
< td >
< asp:Repeater ID ="rptModule" runat ="server"
OnItemCommand ='rptModule_ItemCommand' >
< ItemTemplate >
< tr >
< td >
-----------------
< asp:Button ID ="btnDeleteModule" CommandArgument ='<%# Eval("id") % > ' CommandName="DelModule" runat="server" Text="删除模块" />
< asp:TextBox ID ="txtModuleName" Text ='<%# Eval("moduleName") % > ' runat="server"> </ asp:TextBox >
< asp:Button ID ="btnUpdateModule" CommandArgument ='<%# Eval("id") % > ' CommandName="UpdateModule" runat="server" Text="修改模块" />
</ td >
</ tr >
</ ItemTemplate >
</ asp:Repeater >
</ td >
</ tr >
</ ItemTemplate >
< FooterTemplate >
</ table >
</ FooterTemplate >
</ asp:Repeater >
</ div >
</ form >
</ body >
</ html >