主窗体代码:
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection con =DB.creatcon();
System.Data.SqlClient.SqlDataAdapter sdr=new System.Data.SqlClient.SqlDataAdapter();
sdr.SelectCommand=new System.Data.SqlClient.SqlCommand("select *from users ",con);
DataSet ds=new DataSet();
sdr.Fill(ds,"users");
this.Repeater1.DataSource=ds.Tables["users"];
this.Repeater1.DataBind();
}
连接类代码:
public static SqlConnection creatcon()
{
SqlConnection con =new SqlConnection("server=.;database=test;uid=sa;pwd=;");
return con;
}
html页代码:
<asp:Repeater id="Repeater1" runat="server">
<AlternatingItemTemplate>
<%# DataBinder.Eval
</font>
</AlternatingItemTemplate>
<FooterTemplate>
<br>
</FooterTemplate>
<ItemTemplate>
姓名:
<%# DataBinder.Eval(Container.DataItem,"username") %>
性别:<%# DataBinder.Eval(Container.DataItem,"sex") %>
<br>
</ItemTemplate>
<SeparatorTemplate>
<hr>
</SeparatorTemplate>
<HeaderTemplate>
<font color="#00ccff">表头</font>
</HeaderTemplate>
</asp:Repeater></FONT>