📄 datalist.aspx
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -