ASP.NET Web Forms DataList 控件

<HTML>
<HEAD></HEAD>
<FONT FACE="Verdana, Arial, Helvetica" SIZE=2>
<FONT COLOR=#ff0000><%@ Import Namespace="System.Data.OleDb" %></FONT>
<FONT COLOR=#0000ff><script  runat="server">
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("/db/northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
customers.DataSource=dbread
customers.DataBind()
dbread.Close()
dbconn.Close()
end sub
</script></FONT>
<!DOCTYPE html>
<html>
<body>
<form runat="server">
<asp:DataList
id="customers"
runat="server"
cellpadding="2"
cellspacing="2"
borderstyle="inset"
backcolor="#e8e8e8"
width="100%"
headerstyle-font-name="Verdana"
headerstyle-font-size="12pt"
headerstyle-horizontalalign="center"
headerstyle-font-bold="True"
itemstyle-backcolor="#778899"
itemstyle-forecolor="#ffffff"
footerstyle-font-size="9pt"
footerstyle-font-italic="True">
<HeaderTemplate>
Customers Table
</HeaderTemplate>
<ItemTemplate>
<FONT COLOR=#ff0000><%#Container.DataItem("companyname")%></FONT>  in
<FONT COLOR=#ff0000><%#Container.DataItem("address")%></FONT>, <FONT COLOR=#ff0000><%#Container.DataItem("city")%></FONT>
</ItemTemplate>
<FooterTemplate>
Source: Northwind Database
</FooterTemplate>
</asp:DataList>
</form>
</body>
</html>
</HTML>

Customers Table

Alfreds Futterkiste inObere Str. 57, Berlin

Berglunds snabbköp inBerguvsvägen 8, Luleå

Centro comercial Moctezuma inSierras de Granada 9993, México D.F.

Ernst Handel inKirchgasse 6, Graz

FISSA Fabrica Inter. Salchichas S.A. inC/ Moralzarzal, 86, Madrid

Galería del gastrónomo inRambla de Cataluña, 23, Barcelona

Island Trading inGarden HouseCrowther Way, Cowes

Königlich Essen inMaubelstr. 90, Brandenburg

Laughing Bacchus Wine Cellars in1900 Oak St., Vancouver

Magazzini Alimentari Riuniti inVia Ludovico il Moro 22, Bergamo

North/South inSouth House300 Queensbridge, London

Paris spécialités in265, boulevard Charonne, Paris

Rattlesnake Canyon Grocery in2817 Milton Dr., Albuquerque

Simons bistro inVinbæltet 34, København

The Big Cheese in89 Jefferson WaySuite 2, Portland

Vaffeljernet inSmagsløget 45, Århus

Wolski Zajazd inul. Filtrowa 68, Warszawa

Source: Northwind Database