📄 listing0913.aspx
字号:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="VB" runat="server">
sub Page_Load(obj as Object, e as EventArgs)
'set up connection
dim myConnection as new OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=H:\ASPNET\data\banking.mdb")
'open connection
dim myCommand as new OleDbDataAdapter _
("select * from tblUsers", myConnection)
'fill dataset
dim ds as DataSet = new DataSet()
myCommand.Fill(ds, "tblUsers")
'select data view and bind to server control
DataGrid1.DataSource = ds.Tables("tblUsers").DefaultView
DataBind()
end sub
sub DataGrid1_ItemCommand(obj as object, e as _
DataGridCommandEventArgs)
DataGrid1.SelectedIndex = e.Item.ItemIndex
DataBind()
end sub
</script>
<body>
<form runat="server">
<asp:DataGrid id="DataGrid1" runat="server"
BorderColor="black"
GridLines="Vertical"
cellpadding="4"
cellspacing="0"
width="450"
Font-NameFont-Names="Arial"
Font-Size="8pt"
ShowFooter="True"
HeaderStyle-BackColor="#cccc99"
FooterStyle-BackColor="#cccc99"
ItemStyle-BackColor="#ffffff"
AlternatingItemStyle-Backcolor="#cccccc"
AutoGenerateColumns="false">
<Columns>
<asp:TemplateColumn HeaderText="Name">
<ItemTemplate>
<asp:Label id="Name" runat="server"
Text='<%# Container.DataItem("FirstName")& _
" " & Container.DataItem("LastName") %>'/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="Address"
DataField="Address"/>
<asp:BoundColumn HeaderText="City" DataField="City"/>
<asp:BoundColumn HeaderText="State"
DataField="State" />
<asp:BoundColumn HeaderText="Zip" DataField="Zip" />
<asp:HyperlinkColumn HeaderText="Edit" text="Edit"
NavigateURL="edit.aspx"/>
<asp:ButtonColumn HeaderText="Delete?" text="X"
CommandName="delete"
ButtonType="PushButton"/>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -