📄 datalist.aspx
字号:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.ADO" %>
<html>
<script language="VB" runat="server">
sub Page_Load(obj as Object, e as EventArgs)
'set up connection
dim myConnection as ADOConnection = new ADOConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=H:\ASPNET\data\banking.mdb")
'open connection
dim myCommand as ADODataSetCommand = new ADODataSetCommand _
("select * from tblUsers", myConnection)
'fill dataset
dim ds as DataSet = new DataSet()
myCommand.FillDataSet(ds, "tblUsers")
'select data view and bind to server control
DataList1.DataSource = ds.Tables("tblUsers"). _
DefaultView
DataList1.DataBind()
end sub
sub DataList1_ItemCommand(obj as object, e as DataListCommandEventArgs)
DataList1.SelectedIndex = e.Item.ItemIndex
DataList1.DataBind()
end sub
sub DataList1_EditCommand(obj as object, e as DataListCommandEventArgs)
DataList1.EditItemIndex = e.Item.ItemIndex
DataList1.DataBind()
end sub
sub DataList1_CancelCommand(obj as object, e as DataListCommandEventArgs)
DataList1.EditItemIndex = -1
DataList1.DataBind()
end sub
sub DataList1_UpdateCommand(obj as object, e as DataListCommandEventArgs)
DataList1.EditItemIndex = -1
DataList1.DataBind()
end sub
</script>
<body>
<form runat="server">
<asp:DataList id="DataList1" runat="server"
SelectedItemStyle-BackColor="#cccc99"
repeat-layout="table"
repeat-direction="horizontal"
OnItemCommand="DataList1_ItemCommand"
OnEditCommand="DataList1_EditCommand"
OnUpdateCommand="DataList1_UpdateCommand"
OnCancelCommand="DataList1_CancelCommand" >
<template name="ItemTemplate">
<asp:LinkButton id="button1" runat="server"
Command="edit"
Text='<%# Container.DataItem("FirstName") & " " & _
Container.DataItem("LastName") %>' />
<p>
<asp:Button id="btnEdit" runat="server"
command="edit"
text="Edit" />
</template>
<template name="SelectedItemTemplate">
<%# Container.DataItem("FirstName") & " " & _
Container.DataItem("LastName") %><br>
Phone:
<%# Container.DataItem("Phone") %>
<br>
Address:
<%# Container.DataItem("Address") %>
<br>
<%# Container.DataItem("City") %>,
<%# Container.DataItem("State") %>
<%# Container.DataItem("ZIP") %>
<br>
</template>
<template name="EditItemTemplate">
<asp:Button id="btnCancel" runat="server"
command="cancel"
text="Cancel" />
<asp:Button id="btnUpdate" runat="server"
command="update"
text="Update" />
<asp:Button id="btnDelete" runat="server"
command="delete"
text="Delete" />
</template>
</asp:DataList>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -