Imports System.Data Imports System.Data.SqlClient PartialClass text_defaultClass text_default Inherits System.Web.UI.Page Private _obj As Control =Nothing Private controlID AsString="" Sub GetChildControl()Sub GetChildControl(ByVal ParentControl As Control) If ParentControl.HasControls Then ForEach ct1 As Control In ParentControl.Controls IfNot (ct1.ID IsNothing) AndAlso ct1.ID.StartsWith(controlID, StringComparison.OrdinalIgnoreCase) Then _obj = ct1 Return EndIf GetChildControl(ct1) Next EndIf End Sub ProtectedSub Page_Load()Sub Page_Load(ByVal sender AsObject, ByVal e As System.EventArgs) HandlesMe.Load Dim classid AsInteger() = {7, 1, 8, 2, 4, 5} Dim columnname AsString() = {"hufu", "jiansheng", "liuxinqushi", "meifa", "meirong", "kexuegouyi"} Dim columntitle AsString() = {"护肤", "健身", "流行趋势", "美发", "美容", "科学购衣"} Dim conntxt AsNew SqlConnection conntxt.ConnectionString = Application("conn") conntxt.Open() GetChildControl(Form) Dim i AsInteger=0 While i <6 _obj =Nothing controlID ="textcontent"+ columnname(i) GetChildControl(Form) IfNot (_obj IsNothing) Then Dim contentUC As UserControl =CType(_obj, UserControl) Dim td As HtmlTableCell td =CType(contentUC.FindControl("contentfooter"), HtmlTableCell) td.InnerHtml ="<a href='#'>"+"<img src='images/more1.gif' alt='更多内容"+ columntitle(i) +"...'/></a>" Dim dl As DataList =CType(contentUC.FindControl("maincontent"), DataList) Dim sqltxt AsString="select top 8 newsid,news_title,news_edittime from news where news_classid="+ classid(i).ToString +"order by news_edittime desc" Dim cmdtxt As SqlCommand =New SqlCommand(sqltxt, conntxt) Dim drtxt As SqlDataReader = cmdtxt.ExecuteReader dl.DataSource = drtxt dl.DataBind() drtxt.Close() EndIf System.Math.Min(System.Threading.Interlocked.Increment(i), i -1) EndWhile conntxt.Close() conntxt.Dispose() End Sub End Class