ASP.NET中repeater控件用法实例

程序员文章站 2024-02-16 23:01:07

本文实例讲述了asp.net中repeater控件用法。分享给大家供大家参考。具体实现方法如下： repeater绑定数据：复制代码代码如下:protected v...

本文实例讲述了asp.net中repeater控件用法。分享给大家供大家参考。具体实现方法如下：

repeater绑定数据：

protected void page_load(object sender, eventargs e)
{
if(!ispostback)
bindstudent();
}

private void bindstudent()
{
        string str = configurationmanager.connectionstrings["stucnn"].connectionstring;
        using (sqlconnection sqlcnn = new sqlconnection(str))
        {
            using (sqldataadapter da = new sqldataadapter("select * from student", sqlcnn))
            {
                dataset ds = new dataset();
                da.fill(ds);
                this.repeater1.datasource = ds;
                this.repeater1.databind();
            }
        }
}

删除数据：

复制代码代码如下:

protected void repeater1_itemcommand(object source, repeatercommandeventargs e)

{

        if (e.commandname == "delete")

        {

            string str = configurationmanager.connectionstrings["stucnn"].connectionstring;

            using (sqlconnection sqlcnn = new sqlconnection(str))

            {

                using (sqlcommand sqlcmm = sqlcnn.createcommand())

                {

                    sqlcnn.open();

                    sqlcmm.commandtext = "delete from student where sid=" 

                        + e.commandargument.tostring();

                    sqlcmm.executenonquery();

                }

            }

            this.bindstudent();

        }

        else if (e.commandname == "edit")

        {

            server.transfer("edit.aspx?sid=" + e.commandargument.tostring());

        }

}

前台：

复制代码代码如下:

<%@ 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">

        <asp:repeater id="repeater1" runat="server"
            onitemcommand="repeater1_itemcommand">
        <headertemplate><table>
        <tr><td style="width:100px">编号</td><td style="width:100px">姓名</td>
        <td style="width:100px">图片</td><td> </td><td> </td></tr>
        </headertemplate>
        <itemtemplate>
        <tr>
        <td><%# eval("sid") %></td><td><%# eval("sname") %></td>
        <td><img width="60px" height="60px" src='<%# "images/" + eval("photo") %>' /></td>
        <td><asp:linkbutton id="btndelete" runat="server" text="删除" commandname='delete' commandargument='<%# eval("sid") %>'></asp:linkbutton></td>
        <td><asp:linkbutton id="btnedit" runat="server" text="编辑" commandname='edit' commandargument='<%# eval("sid") %>'></asp:linkbutton></td>
        </tr>
        </itemtemplate>
        <alternatingitemtemplate>
        <tr style="
        <td><%# eval("sid") %></td><td><%# eval("sname") %></td>
        <td><img width="60px" height="60px" src='<%# "images/" + eval("photo") %>' /></td>
        <td><asp:linkbutton id="btndelete" runat="server" text="删除" commandname='delete' commandargument='<%# eval("sid") %>'></asp:linkbutton></td>
        <td><asp:linkbutton id="btnedit" runat="server" text="编辑" commandname='edit' commandargument='<%# eval("sid") %>'></asp:linkbutton></td>
        </tr>
        </alternatingitemtemplate>
        <separatortemplate>
        <tr><td colspan="5"><hr /></td></tr>
        </separatortemplate>
        <footertemplate></table></footertemplate>
        </asp:repeater>

</div>
</form>
</body>
</html>

启用，禁用：

复制代码代码如下:

protected void repeater1_itemcommand(object source, repeatercommandeventargs e)
{
        //string status = e.commandname;
        if ((e.commandname == "true")||(e.commandname == "false"))
        {
            string str = configurationmanager.connectionstrings["stucnn"].connectionstring;
            using (sqlconnection sqlcnn = new sqlconnection(str))
            {
                using (sqlcommand sqlcmm = sqlcnn.createcommand())
                {
                    sqlcnn.open();
                    sqlcmm.commandtext = "update student set status=@status where sid="
                        + e.commandargument.tostring();
                    sqlcmm.parameters.addwithvalue("@status",e.commandname);
                    sqlcmm.executenonquery();
                }
            }
            this.bindstudent();
        }
}

<%@ page language="c#" autoeventwireup="true" codefile="default2.aspx.cs" debug="true" 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="repeater1" runat="server"
            onitemcommand="repeater1_itemcommand">
        <headertemplate><table><tr><th>编号</th><th>姓名</th><th>状态</th><th> </th></tr></headertemplate>
        <itemtemplate>
        <tr><td><%# eval("sid") %></td>
        <td><%# eval("sname") %></td>
        <td><%# convert.toboolean(eval("status"))?"启用":"禁用" %></td>
        <td><asp:linkbutton id="btnsetstatus" runat="server" commandargument='eval("sid")' text='<%# convert.toboolean(eval("status"))?"禁用":"启用" %>' commandname='<%# convert.toboolean(eval("status"))?"false":"true" %>'></asp:linkbutton></td></tr>
        </itemtemplate>
        <footertemplate></table></footertemplate>
        </asp:repeater>
    </div>
    </form>
</body>
</html>

希望本文所述对大家的asp.net程序设计有所帮助。

上一篇： C#获取局域网MAC地址的简单实例

下一篇： c#生成站点地图（SiteMapPath）文件示例程序

ASP.NET中repeater控件用法实例

ASP.NET中repeater控件用法实例

c#中switch case的用法实例解析

实例详解php中session的三种用法

PHP中auto_prepend_file与auto_append_file用法实例分析，autoprependfile

asp.net中Repeart选中整行操作实例

asp.net使用Repeater控件中的全选进行批量操作实例

.NET中StringBuilder用法实例分析

jQuery中trigger()方法用法实例

smarty模板引擎中变量及变量修饰器用法实例，smarty模板_PHP教程

thinkphp3.x中display方法及show方法的用法实例