这个问题，平时很少看到，一般在数据绑定之前，数据都是放在一个表中的，实际上，如果表之间存在关系，绑定多个表也是可以的。下面就是 dataset中两个表进行绑定的例子。
<%@ 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">
protected void page_load(object sender, eventargs e)
{
system.data.dataset ds = new system.data.dataset();
system.data.datatable datatable1 = new system.data.datatable("bloguser");
system.data.datarow dr;
datatable1.columns.add(new system.data.datacolumn("userid", typeof(system.int32)));
datatable1.columns.add(new system.data.datacolumn("username", typeof(system.string)));
datatable1.primarykey = new system.data.datacolumn[] { datatable1.columns["userid"] };
for (int i = 0; i < 8; i++)
{
dr = datatable1.newrow();
dr[0] = i;
dr[1] = "【孟子e章】" + i.tostring();
datatable1.rows.add(dr);
}
system.data.datatable datatable2 = new system.data.datatable("blogarticle");
datatable2.columns.add(new system.data.datacolumn("articleid", typeof(system.int32)));
datatable2.columns.add(new system.data.datacolumn("title", typeof(system.string)));
datatable2.columns.add(new system.data.datacolumn("userid", typeof(system.int32)));
datatable2.primarykey = new system.data.datacolumn[] { datatable1.columns["articleid"] };
random rd = new random();
for (int i = 0; i < 20; i++)
{
dr = datatable2.newrow();
dr[0] = i;
dr[1] = "文章标题" + i.tostring();
dr[2] = rd.next(0, 7);
datatable2.rows.add(dr);
}
ds.tables.add(datatable1);
ds.tables.add(datatable2);
system.data.datacolumn parentcolumn = ds.tables["bloguser"].columns["userid"];
system.data.datacolumn childcolumn = ds.tables["blogarticle"].columns["userid"];
system.data.datarelation user_article = new system.data.datarelation("userid", parentcolumn, childcolumn);
ds.relations.add(user_article);
this.repeater1.datasource = ds.tables["blogarticle"].defaultview;
this.repeater1.databind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="head1" runat="server">
<title> asp.net 绑定dataset中的多个表 作者：孟子e章</title>
</head>
<body>
<form id="form1" runat="server">
<asp:repeater id="repeater1" runat="server">
<headertemplate>
<table border="1">
<tr style="background:orange">
<th>文章标题</th>
<th>用户id</th>
<th>用户名</th>
</tr>
</headertemplate>
<footertemplate>
</table></footertemplate>
<itemtemplate>
<tr>
<td><%#eval("title")%></td><td><%#eval("userid") %></td>
<td><%#(container.dataitem as system.data.datarowview).row.getparentrow("userid")["username"]%>
</td>
</tr>
</itemtemplate>
</asp:repeater>
</form>
</body>
</html>
如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！
点击进行留言回复
我要评论
网友评论