📄 listing1001.aspx
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -