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 + -
显示快捷键?