62,046
社区成员
发帖
与我相关
我的任务
分享
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<asp:Repeater ID="rp" runat="server">
<HeaderTemplate>
<table>
<tr>
<td>
ID</td>
<td>
Name</td>
<td>
Address</td>
<td>
Phone</td>
</tr>
</HeaderTemplate>
<AlternatingItemTemplate>
<tr>
<td>
<asp:CheckBox ID="ckb" runat="server" Text='<%#Eval("EmployeeID") %>' /></td>
<td>
<%#Eval("FirstName")%>
<%#Eval("LastName")%>
</td>
<td>
<%#Eval("Address")%>
</td>
<td>
<%#Eval("HomePhone")%>
</td>
</tr>
</AlternatingItemTemplate>
<ItemTemplate>
<tr>
<td>
<asp:CheckBox ID="ckb" runat="server" Text='<%#Eval("EmployeeID") %>' /></td>
<td>
<%#Eval("FirstName")%>
<%#Eval("LastName")%>
</td>
<td>
<%#Eval("Address")%>
</td>
<td>
<%#Eval("HomePhone")%>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>
</body>
</html>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection("server=.;uid=xxx;pwd=xxx;database=Northwind"))
{
SqlDataAdapter sdr = new SqlDataAdapter("select * from Employees ", conn);
DataSet ds = new DataSet();
sdr.Fill(ds, "Employees");
if (ds.Tables.Contains("Employees"))
{
rp.DataSource = ds.Tables["Employees"];
rp.DataBind();
}
}
}
}