<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat=server>
void Page_Load(Object sender , EventArgs e)
{
SqlConnection conPubs;
SqlCommand mycmdSelect;
conPubs = new SqlConnection("server=IPROMISE//SQLEXPRESS;database=Show5new;uid=sa;password=;");
mycmdSelect = new SqlCommand("SELECT Username FROM Show5_ALLUser", conPubs);
conPubs.Open();
myDropDownList.DataSource = mycmdSelect.ExecuteReader();
myDropDownList.DataTextField = "Username"; // 没有这个绑定来的数据有问题
myDropDownList.DataBind();
conPubs.Close();
}
</Script>
<html>
<head><title>RepeaterTable.aspx</title></head>
<body>
<form Runat="Server">
<asp:Repeater
ID="rptAuthors"
Runat="Server">
<HeaderTemplate>
<table border=1 cellpadding=4>
<tr bgcolor="#eeeeee">
<th>Username</th>
<th>Password</th>
<th>Email</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%#DataBinder.Eval(Container.DataItem, "Username" ) %></td>
<td><%#DataBinder.Eval(Container.DataItem, "Password")%></td>
<td><%#DataBinder.Eval(Container.DataItem, "email" ) %></td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr bgcolor="lightyellow">
<td><%#DataBinder.Eval(Container.DataItem, "Username")%></td>
<td><%#DataBinder.Eval(Container.DataItem, "Password")%></td>
<td><%#DataBinder.Eval(Container.DataItem, "email")%></td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
<asp:DropDownList ID="myDropDownList" runat="server" />
</form>
</body>
其它控件方法一样 注意 DataTextField