📄 ch16-02-01.aspx
字号:
<%@ Page Language="VB" Debug="true" %>
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<% Response.Expires = 0 %>
<Html>
<Head>
<Title>Ch16-02-01.aspx DataTable对象的Select方法</Title>
<Script Language="VB" Runat="Server">
' 在这里设置联机字符串的内容
Sub Page_Load(Obj As Object, e As EventArgs)
' 声明DataSet对象
Dim OBJDataSet As DataSet = New DataSet()
Dim TableName As String = "UserDatas"
Dim tSQL As String = "Select * From " & TableName
GetDataSet(OBJDataSet , tSQL)
ShowDataSet(OBJDataSet, TableName )
Dim OBJDataRow As DataRow
Dim OBJDataColumn As DataColumn
Dim SelectedRows() As DataRow
SelectedRows = OBJDataSet.Tables("UserDatas").Select( _
"UserAccount = 'Colin1'","UserName", _
DataViewRowState.CurrentRows)
Response.Write("<Center><H2>执行Select方法之后的数据列</H2>")
Response.Write("<Table Border=1>")
For Each OBJDataRow In SelectedRows
Response.Write("<TR>")
' 显示在数据列之中的每一个数据行
For Each OBJDataColumn In OBJDataSet.Tables("UserDatas").Columns
Response.Write("<TD>" & OBJDataRow(OBJDataColumn.ColumnName) & "</TD>" )
Next OBJDataColumn
Response.Write("</TR>")
Next OBJDataRow
Response.Write("</Table>")
End Sub
</Script>
<!-- #Include Virtual="DataSetOP.inc" -->
</Head>
<Body>
</Body>
</Html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -