listing1001.aspx
来自「asp入门到精通的源代码」· ASPX 代码 · 共 39 行
ASPX
39 行
<%@ 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 objConn as new OleDbConnection _
' ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
' "Data Source=H:\ASPNET\data\banking.mdb")
dim objConn as new OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;DSN=21DaysBanking")
dim objCmd as new OleDbDataAdapter _
("select * from tblUsers", objConn)
dim ds as DataSet = new DataSet()
objCmd.Fill(ds, "tblUsers")
dim dTable as DataTable = ds.Tables("tblUsers")
Dim CurrRows() as DataRow = dTable.Select(Nothing, _
Nothing, DataViewRowState.CurrentRows)
Dim I, J as integer
Dim strOutput as string
For I = 0 to CurrRows.Length - 1
For J = 0 to dTable.Columns.Count - 1
strOutput = strOutput & dTable.Columns(J). _
ColumnName & " = " & CurrRows(I)(J).ToString & _
"<br>"
next
next
Response.write(strOutput)
end sub
</script>
<html><body>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?