<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http:///TR/xhtml1/DTD/">
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
ds = new ();
dataTable1 = new ("BlogUser");
dr;
(new ("UserId", typeof(System.Int32)));
(new ("UserName", typeof()));
= new [] { ["UserId"] };
for (int i = 0; i < 8; i++)
{
dr = ();
dr[0] = i;
dr[1] = "【Mencius Chapter E】" + ();
(dr);
}
dataTable2 = new ("BlogArticle");
(new ("ArticleId", typeof(System.Int32)));
(new ("Title", typeof()));
(new ("UserId", typeof(System.Int32)));
= new [] { ["ArticleId"] };
Random rd = new Random();
for (int i = 0; i < 20; i++)
{
dr = ();
dr[0] = i;
dr[1] = "Article Title" + ();
dr[2] = (0, 7);
(dr);
}
(dataTable1);
(dataTable2);
parentColumn = ["BlogUser"].Columns["UserId"];
childColumn = ["BlogArticle"].Columns["UserId"];
user_article = new ("UserId", parentColumn, childColumn);
(user_article);
this. = ["BlogArticle"].DefaultView;
this.();
}
</script>
<html xmlns="http:///1999/xhtml">
<head runat="server">
<title> Bind multiple tables in DataSet Author: Chapter E of Mencius</title>
</head>
<body>
<form runat="server">
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<table border="1">
<tr style="background:orange">
<th>Article Title</th>
<th>User ID</th>
<th>Username</th>
</tr>
</HeaderTemplate>
<FooterTemplate>
</table></FooterTemplate>
<ItemTemplate>
<tr>
<td><%#Eval("Title")%></td><td><%#Eval("UserId") %></td>
<td><%#( as ).("UserId")["UserName"]%>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>