Repeater嵌套,增删改查综合运用
最近写了个嵌套的例子,做为参考^.^
-----这是后置代码-----
CS代码：
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 _Default : System.Web.UI.Page
{
private const string connectionStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\QianTao\App_Data\db.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();
}
}
}
ASPX:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>嵌套RepeaterDEMO</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>
