repeater中如何显示一对多

heshiquan 2003-12-11 10:20:01

datatable记录如下
马龙松树
马龙柏树
马龙梨树
...........

显示形式如下
_____________
|单位 |树种|
|------|----|
| |松树|
| |----|
| 马龙|柏树|
| |----|
| |梨树|
|------|----|
不知各位有何方法来实现,急,谢谢

...全文

35 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

lanyahuhu 2003-12-12

打赏
举报

mark

nnh 2003-12-12

打赏
举报

看看，这就是你想要的：
<%@ Page Language="vb" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="VB" runat="server">
dim MyConnection as OleDbConnection
dim cmdSelect as OleDbCommand
dim dtrReader as OleDbDataReader

Sub Page_load(sender as object,e as Eventargs)
MyConnection = New OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=c:\inetpub\wwwroot\nhonline\datagrid\kk.mdb")
if not IsPostBack() then
Mydatagrid_DataBind()
end if
End Sub

Sub Mydatagrid_DataBind()
Dim MyCommand As OleDbDataAdapter = new OleDbDataAdapter("select * from [class]", MyConnection)
Dim DS As DataSet = new DataSet()
MyCommand.Fill(DS,"board")
BigClassList.DataSource=DS.Tables("board").DefaultView
BigClassList.DataBind()
End Sub

Function SmallClass(BigClassID) as DataTable
dim SmallClassData as DataSet =new DataSet()
MyConnection.Open()
dim DataAdapter as OleDbDataAdapter = new OleDbDataAdapter("SELECT * FROM [board] WHERE class="& BigClassID &"",MyConnection)
DataAdapter.Fill(SmallClassData,"SmallClassData")
MyConnection.Close()
return SmallClassData.Tables("SmallClassData")
End Function

</script>
<html>
<head>
<title>NHONLINE_BBS_INDEX</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body>

<form Runat="server">
<asp:Repeater id="BigClassList" runat="server">
<ItemTemplate>
<TABLE style="BORDER-COLLAPSE: collapse" borderColor="#797979" BgColor="#CACACA" cellSpacing="0" cellPadding="4" width="700" height="30" align="center" border="1">
<TR>
<TD height="35" align="left"><B> <FONT COLOR="#CC0000"><%#Container.DataItem("class")%></FONT></B>
</TD>
</TR>
</TABLE>

<TABLE style="BORDER-COLLAPSE: collapse" borderColor="#797979" BgColor="#F9F9F9" cellSpacing="0" cellPadding="4" width="700" align="center" border="1">
<asp:Repeater id="SmallClassList" runat="server" DataSource='<%# SmallClass(Container.DataItem("id").ToString()) %>'>
<ItemTemplate>
<TR>
<TD valign="top">
<TABLE style="BORDER-COLLAPSE: collapse" borderColor="#797979" BgColor="#F9F9F9" cellSpacing="0" cellPadding="4" width="650" align="center" border="0">
<TR>
<TD width="250"><FONT COLOR="#330099">
<A HREF='<%#"List_5_5.aspx?BoardID="& Container.DataItem("boardid")%>'><%#Container.DataItem("boardtype")%></A> </FONT>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</ItemTemplate>
</asp:Repeater>
</TABLE>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>

heshiquan 2003-12-11