asp.net Repeater控件简单例子

最新推荐文章于 2022-01-12 22:11:14 发布

myqq874663394

最新推荐文章于 2022-01-12 22:11:14 发布

阅读量3k

点赞数 3

分类专栏： asp.net 文章标签： Repeater Repeater控件

本文链接：https://blog.csdn.net/myqq874663394/article/details/50993287

版权

asp.net 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

MessageOnline.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MessageOnline.aspx.cs" Inherits="WebApplication1.MessageOnline" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:Repeater ID="Repeater1" runat="server">
                <HeaderTemplate>
                    <table>
                        <tr>
                            <td>编号</td>
                            <td>用户名</td>
                            <td>用户密码</td>
                            <td>用户类型</td>
                        </tr>
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        <td><%#Eval("id") %></td>
                        <td><%#Eval("username") %></td>
                        <td><%#Eval("userpwd") %></td>
                        <td><%#Eval("usertype") %></td>
                    </tr>
                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
            </asp:Repeater>
        </div>
    </form>
</body>
</html>

上面代码Eval中string值为数据库中字段名
MessageOnline.aspx.cs

string connStr = "Data Source=.;Initial Catalog=webServer;Integrated Security=True";
string sql = string.Format("select * from [Admin]");
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);

Repeater1.DataSource = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
Repeater1.DataBind();