110,500
社区成员
发帖
与我相关
我的任务
分享
class User
{
public string Name { get; set; }
public Int32 Age { get; set; }
}
IList<User> userList = new List<User>();
using (SqlConnection conn = new SqlConnection(sqlConnection))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from tableName";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
User user = new User();
user.Name = (string)reader["Name"];
user.Age = (Int32)reader["Age"];
userList.Add(user);
}
}
}
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
public class user
{
public String Name { set; get; }
public int Age { set; get; }
}
protected void Page_Load(object sender, EventArgs e)
{
IList<user> myTable = new List<user>();
user a = new user() { Name = "A", Age = 12 };
myTable.Add(a);
user b = new user() { Name = "b", Age = 12 };
myTable.Add(a);
Repeater1.DataSource = myTable;
Repeater1.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<h1><%#Eval("Name") %>:<%#Eval("Age") %></h1>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>