新闻分类显示.

来源：互联网发布：青海干部网络培训平台编辑：程序博客网时间：2024/05/17 03:43

<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';
  }
}
}

               </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();
    }