datalist.aspx
来自「这是《ASP.NET编程实作教程》一书中的源文件 如果有此书的朋友不防下载过来参」· ASPX 代码 · 共 40 行
ASPX
40 行
<%@ 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=Northwind;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Products", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Product");
MyDataList.DataSource = ds.Tables["Product"].DefaultView;
MyDataList.DataBind();
}
</script>
<body>
<ASP:DataList id="MyDataList"
RepeatColumns="3"
RepeatDirection="Horizontal"
GridLines="Horizontal"
runat="server">
<ItemTemplate>
<div style="padding:15,15,15,15;font-size:10pt;font-family:Verdana">
<div style="font:12pt verdana;color:blue">
<i><b><%# DataBinder.Eval(Container.DataItem, "ProductName") %></i></b>
</div>
<br>
<b>计量单位: </b><%# DataBinder.Eval(Container.DataItem, "QuantityPerUnit") %><br>
<b>单价:</b><%# DataBinder.Eval(Container.DataItem, "UnitPrice") %><br>
</div>
</ItemTemplate>
</ASP:DataList>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?