%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e) {
SqlConnection myConnection = new SqlConnection("server=(local);database=pubs;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Titles", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "书名");
MyDataList.DataSource = ds.Tables["书名"].DefaultView;
MyDataList.DataBind();
}
</script>
<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
<!-- #include virtual="header.inc" -->
<ASP:DataList id="MyDataList" RepeatColumns="3" RepeatDirection="Horizontal" runat="server" HorizontalAlign="Center">
<FooterStyle HorizontalAlign="Center"></FooterStyle>
<ItemTemplate>
<div style="padding:15,15,15,15;font-size:10.5pt;font-family:宋体">
<div style="font:12pt 宋体;color:darkred">
<i><b><%# DataBinder.Eval(Container.DataItem, "title") %></i></b>
</div>
<br>
<b>书名 ID：</b><%# DataBinder.Eval(Container.DataItem, "title_id") %><br>
<b>类别：</b><%# DataBinder.Eval(Container.DataItem, "type") %><br>
<b>出版商 ID：</b><%# DataBinder.Eval(Container.DataItem, "pub_id") %><br>
<b>价格：</b><%# DataBinder.Eval(Container.DataItem, "price", "$ {0}") %><p>
</div>
</ItemTemplate>
</ASP:DataList>
<!-- #include virtual="footer.inc" -->
</body>
</html>
