<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
sub Page_Load(Sender as Object, e as EventArgs)
'set up connection
dim myConnection as new OleDbConnection( _
"PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("EmployeeDatabase.mdb;"))
'open connection
dim myCommand as new OleDbDataAdapter _
("select * from employee", myConnection)
'fill dataset
dim ds as DataSet = new DataSet()
myCommand.Fill(ds, "employee")
'select data view and bind to server control
DataList1.DataSource = ds.Tables("employee").DefaultView
DataBind()
end sub
sub DataList1_ItemCommand(Sender as object, e as _
DataListCommandEventArgs)
DataList1.SelectedIndex = e.Item.ItemIndex
DataList1.DataBind()
end sub
repeatlayout="table"
repeatdirection="horizontal"
OnItemCommand="DataList1_ItemCommand"
DataKeyField="ID">
Container.DataItem("LastName") %>'
Command="select" />
<%# Container.DataItem("FirstName") & " " & _
Container.DataItem("LastName") %>
ID:
<%# Container.DataItem("ID") %>