listing1505.aspx
来自「asp入门到精通的源代码」· ASPX 代码 · 共 38 行
ASPX
38 行
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load(obj as object, e as eventargs)
dim objDatabase as new TYASPNET.Database
objDatabase.ConnectionString = "Provider=" & _
"Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\ASPNET\data\banking.mdb"
dim objReader as OleDbDataReader
objReader = objDatabase.SelectSQL _
("Select * from tblUsers")
if not objReader is nothing then
DataGrid1.DataSource = objReader
DataGrid1.DataBind()
objReader.Close
end if
end sub
</script>
<html><body>
<asp:Label id="lblMessage" runat="server" />
<asp:DataGrid id="DataGrid1"
runat="server" BorderColor="black"
GridLines="Vertical" cellpadding="4"
cellspacing="0" width="100%"
Font-Name="Arial" Font-Size="8pt"
HeaderStyle-BackColor="#cccc99"
ItemStyle-BackColor="#ffffff"
AlternatingItemStyle-Backcolor="#cccccc" />
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?