Reapter增删改查

最新推荐文章于 2016-01-11 20:45:12 发布

原创最新推荐文章于 2016-01-11 20:45:12 发布 · 置顶 · 2.7k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #textbox #module #cmd #class #insert

asp.net学习专栏收录该内容

20 篇文章

订阅专栏

该博客介绍了如何使用ASP.NET中的Repeater控件进行嵌套数据展示，并实现类别和模块的添加、删除和修改功能。通过在Repeater中嵌套Repeater，实现了类别下的模块管理，同时提供了TextBox和Button控件以交互式地更新数据。

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>