|
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load(Sender as Object, e as EventArgs)
dim myConnection as new OleDbConnection( _
"PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
& "DATA SOURCE=" _
& Server.MapPath("EmployeeDatabase.mdb;"))
dim myCommand as new OleDbDataAdapter("select * from employee", myConnection)
dim ds as DataSet = new DataSet()
myCommand.Fill(ds, "employee")
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
sub DataList1_EditCommand(Sender as object, e as DataListCommandEventArgs)
DataList1.EditItemIndex = e.Item.ItemIndex
DataList1.DataBind()
end sub
sub DataList1_CancelCommand(Sender as object, e as DataListCommandEventArgs)
DataList1.EditItemIndex = -1
DataList1.DataBind()
end sub
sub DataList1_UpdateCommand(Sender as object, e as DataListCommandEventArgs)
DataList1.DataBind()
end sub
sub DataList1_DeleteCommand(Sender as object, e as DataListCommandEventArgs)
DataList1.DataBind()
end sub
</script>
<html><body>
<form runat="server">
<asp:DataList id="DataList1" runat="server"
SelectedItemStyle-BackColor="#cccc99"
repeatlayout="table"
repeatdirection="horizontal"
OnItemCommand="DataList1_ItemCommand"
OnEditCommand="DataList1_EditCommand"
OnCancelCommand="DataList1_CancelCommand"
OnUpdateCommand="DataList1_UpdateCommand"
OnDeleteCommand="DataList1_DeleteCommand"
DataKeyField="ID">
<ItemTemplate>
<asp:LinkButton id="button1" runat="server"
Text='<%# Container.DataItem("FirstName") & " " & _
Container.DataItem("LastName") %>'
CommandName="Edit" />
</ItemTemplate>
<SelectedItemTemplate>
<%# Container.DataItem("FirstName") & " " & _
Container.DataItem("LastName") %><br>
ID:
<%# Container.DataItem("ID") %>
<br>
</SelectedItemTemplate>
<EditItemTemplate>
<asp:LinkButton id="lbtCancel" runat="server"
CommandName="Cancel"
Text="Cancel" />
<asp:LinkButton id="lbtUpdate" runat="server"
CommandName="Update"
Text="Update" />
<asp:LinkButton id="lbtDelete" runat="server"
CommandName="Delete"
Text="Delete" />
</EditItemTemplate>
</asp:DataList>
</form>
</body></html>
|