<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.oledb" %>
<%@ Import Namespace="System.Web.UI" %>
<%@ Import Namespace="System.Web.UI.WebControls" %><html><script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim ds As DataSet
Dim MyConnection As OleDbConnection
Dim MyCommand As OleDbCommand
Dim da As OleDbDataAdapter
Dim message As Repeater
MyConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(".") + "..\\Data\\data.aspx")
MyConnection.open
ds = new DataSet()
da = new OleDbDataAdapter("Select * from GuestBook order by date DESC",MyConnection)
da.Fill(ds,1,1,"Message")
message.DataSource = ds
message.DataMember = "Message"
message.DataBind()
MyConnection.Close()
End Sub</script><body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
<ASP:Repeater id="Message" runat="server"> <HeaderTemplate> <table width="100%" style="font: 8pt verdana">
<tr style="background-color:DFA894">
<th>
Title
</th>
<th>
Title ID
</th>
<th>
Type
</th>
<th>
Publisher ID
</th>
<th>
Price
</th>
</tr> </HeaderTemplate> <ItemTemplate> <tr style="background-color:FFECD8">
<td>
<%# DataBinder.Eval(Container.DataItem,"Photo")%>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo", "$ {0}") %>
</td>
</tr> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </ASP:Repeater> </body>
</html>
<%@ Import Namespace="System.Data.oledb" %>
<%@ Import Namespace="System.Web.UI" %>
<%@ Import Namespace="System.Web.UI.WebControls" %><html><script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim ds As DataSet
Dim MyConnection As OleDbConnection
Dim MyCommand As OleDbCommand
Dim da As OleDbDataAdapter
Dim message As Repeater
MyConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(".") + "..\\Data\\data.aspx")
MyConnection.open
ds = new DataSet()
da = new OleDbDataAdapter("Select * from GuestBook order by date DESC",MyConnection)
da.Fill(ds,1,1,"Message")
message.DataSource = ds
message.DataMember = "Message"
message.DataBind()
MyConnection.Close()
End Sub</script><body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
<ASP:Repeater id="Message" runat="server"> <HeaderTemplate> <table width="100%" style="font: 8pt verdana">
<tr style="background-color:DFA894">
<th>
Title
</th>
<th>
Title ID
</th>
<th>
Type
</th>
<th>
Publisher ID
</th>
<th>
Price
</th>
</tr> </HeaderTemplate> <ItemTemplate> <tr style="background-color:FFECD8">
<td>
<%# DataBinder.Eval(Container.DataItem,"Photo")%>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo") %>
</td>
<td>
<%# DataBinder.Eval(Container.DataItem, "Photo", "$ {0}") %>
</td>
</tr> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </ASP:Repeater> </body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货