<SCRIPT language=JavaScript type=text/javascript>
function getObject(objectId)
{
if(document.getElementById && document.getElementById(objectId))
{
return document.getElementById(objectId);
}
else if (document.all && document.all(objectId))
{
return document.all(objectId);
}
else if (document.layers && document.layers[objectId])
{
return document.layers[objectId];
}
else
{
return false;
}
}
function hbDiv(n,m,j)
{
var sum=0;
for(var i=1;i<=j;i++)
{
sum=i+m;
if (i==n)
{
getObject('Div'+sum).style.display='';
}
else
{
getObject('Div'+sum).style.display='none';
}
}
}
function hbTab(n,m,j)
{
//var bg1="url(hbbg1.gif)";
//var bg2="url(hbbg2.gif)";
var sum=0;
for(var i=1;i<=j;i++)
{
sum=i+m;
if (i==n)
{
getObject('hbTab'+sum).style.background='url(images/an'+sum+'_01.gif)';
getObject('hbTable'+sum).style.display='';
}
else
{
getObject('hbTab'+sum).style.background='url(images/an'+sum+'_02.gif)';
getObject('hbTable'+sum).style.display='none';
}
}
}
</script>
<table id="Table2" width="608" height="197" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="608" height="29">
<table id="Table3" width="608" height="29" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/index3_03_18_01_01.gif" width="11" height="29" alt=""></td>
<td id="hbTab1" style="CURSOR:pointer" οnmοuseοver="hbTab(1,0,3);" background="images/an1_01.gif" width="84" height="29"></td>
<td><img src="images/index3_03_18_01_03.gif" width="6" height="29" alt=""></td>
<td id="hbTab2" style="CURSOR:pointer" οnmοuseοver="hbTab(2,0,3);" background="images/an2_02.gif" width="84" height="29"></td>
<td><img src="images/index3_03_18_01_05.gif" width="6" height="29" alt=""></td>
<td id="hbTab3" style="CURSOR:pointer" οnmοuseοver="hbTab(3,0,3);" background="images/an3_02.gif" width="84" height="29"></td>
<td><img src="images/index3_03_18_01_07.gif" width="333" height="29" alt=""></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top">
<table id="hbTable1" width="608" height="168" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" style=" padding-top:10px;padding-left:8px">
<asp:DataList ID="DDLparent1" runat="server" RepeatDirection="Horizontal" RepeatColumns="3">
<ItemTemplate>
<table width="180px" border="0" cellpadding="0" cellspacing="0" style="font-size:9pt; color:#ff9900"><tr><td valign="top"><img src="images/dot_icon.gif" alt="" border="0" /> <a href="HtmlTradeList.aspx" target="_blank"><font color="#ff9900"><%# DataBinder.Eval(Container.DataItem, "Type")%></font></a></td></tr></table>
<table width="180px" cellpadding="0" cellspacing="0" height="50px">
<tr>
<td valign="top">
<asp:Repeater ID="Rptchild1" runat="server" datasource='<%# ((System.Data.DataRowView)Container.DataItem).Row.GetChildRows("myrelation") %>'>
<itemtemplate>
<a href="Htmltradenews.aspx?ID=<%# DataBinder.Eval(Container.DataItem, "[/"ID/"]")%>" target="_blank"><img src="images/arrow.gif" border="0"/> <span style="font-size:9pt;padding-left:5px"><%# DataBinder.Eval(Container.DataItem, "[/"title/"]")%></span></a><br />
</itemtemplate>
</asp:Repeater>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
</td>
</tr>
</table>
cs代码
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindPrinSubDll(DDLparent7, "select columntype from lawrule group by columntype", "select id,Columntype,(left(title,20)+'...') title from lawrule a where id in (select top 3 id from lawrule b where a.columntype=b.columntype and b.tradetype='房产法规' order by b.id desc) order by columntype , id desc", "columntype");
}
}
public void BindPrinSubDll(DataList ddl,string psql,string csql,string strfiled)
{
conn.Open();
SqlDataAdapter cmd1 = new SqlDataAdapter(psql,conn);
DataSet ds = new DataSet();
cmd1.Fill(ds, "parentTable");
SqlDataAdapter cmd2 = new SqlDataAdapter(csql,conn);
cmd2.Fill(ds, "childTable");
ds.Relations.Add("myrelation",
ds.Tables["parentTable"].Columns[strfiled],
ds.Tables["childTable"].Columns[strfiled]);
// 绑定Authors到父Repeater
ddl.DataSource = ds.Tables["parentTable"];
ddl.DataBind();
conn.Close();
}