Repeater控件,显示数据库信息
Repeater控件，显示数据库信息.aspx
Code<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet dset = new DataSet();
string conn = "server=(local);Database=test;Integrated Security=true";
string qry = "SELECT num,age,name,sex FROM students";
SqlDataAdapter sda = new SqlDataAdapter(qry, conn);
sda.Fill(dset);
Repeater1.DataSource = dset.Tables[0].DefaultView;
Repeater1.DataBind();
}
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" method="post" runat="server">
<span style="color: #ff00ff">
Repeater显示数据库中信息1:<br />
</span>
<asp:Repeater ID="Repeater1" runat="server" >
<HeaderTemplate>
<div class="header" id="header">test 学生（这是头）</div>
</HeaderTemplate>
<SeparatorTemplate> ---------------------------------------
</SeparatorTemplate>
<ItemTemplate>
<div class="row">
<%# ((DataRowView)Container.DataItem)["num"] %>，
<%# ((DataRowView)Container.DataItem)["age"] %>，
<%# ((DataRowView)Container.DataItem)["name"] %>，
<%# ((DataRowView)Container.DataItem)["sex"] %>
</div>
</ItemTemplate>
<AlternatingItemTemplate>
<div class="alternate">
<%# ((DataRowView)Container.DataItem)["num"] %>，
<%# ((DataRowView)Container.DataItem)["age"] %>，
<%# ((DataRowView)Container.DataItem)["name"] %>，
<%# ((DataRowView)Container.DataItem)["sex"] %>
</div>
</AlternatingItemTemplate>
<FooterTemplate>
<div class="footer">
<%# "总共"+((DataView)Repeater1.DataSource).Count + "个学生" %>（这是尾）
</div>
</FooterTemplate>
</asp:Repeater>
<br />
<br />
<br />
<asp:TextBox ID="TextBox1" runat="server" TextMode="MultiLine" Height="122px" Width="643px">
<HeaderTemplate>:头
<ItemTemplate>:记录
<AlternatingItemTemplate>:轮流的记录，可以定义上一条记录不同的样式，只能用一次！
<FooterTemplate>:尾
</asp:TextBox>
<br />
<br />
<span style="color: #ff0066">
Repeater显示数据库中信息2：</span><br />
<div>
<asp:Panel ID="divOfPlanBooks" runat="server">
<asp:Repeater ID="Repeater2" runat="server" DataSourceID="sourceOfPlanBooks">
<ItemTemplate><li><a href="Default.aspx?num=<%#Eval("num")%>"><%#Eval("name")%><%#Eval("age")%></a></li></ItemTemplate>
</asp:Repeater>
<asp:SqlDataSource ID="sourceOfPlanBooks" runat="server" ConnectionString="<%$ ConnectionStrings:SqlConnectionString1 %>"
SelectCommand="SELECT top 2 num, name,age,sex FROM students ORDER BY num DESC">
</asp:SqlDataSource>
</asp:Panel>
</div>
</form>
</body>
</html>
Web.Config:
Code<connectionStrings>
<add name="SqlConnectionString1" connectionString="Data Source=(local);Initial Catalog=test;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
浙公网安备 33010602011771号