📄 dataview.aspx

📁 聊天聊天聊天聊天聊天聊天

💻 ASPX

字号:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="VB" runat="server">
Sub readDs(Sender As Object, E As EventArgs)
	Dim dv as DataView
	Dim i as integer
	Dim myConnection As OleDbConnection
	Dim myCommand    As OleDbDataAdapter
	Dim ds           As New DataSet
	Dim ConnStr      As String
	Dim SQL          As String
	
	ConnStr = "Provider=SQLOLEDB; Data Source=(local); Initial Catalog=ASPNET;User ID=sa;"
	myConnection = New OleDbConnection(ConnStr)    
	SQL = "select  * from groups "
	myCommand = New OleDbDataAdapter(SQL, myConnection)
	myCommand.Fill(ds, "groups")
	dv = new DataView(ds.Tables("groups"))
	'// Sort the view based on the code_display column
	dv.Sort = "code_display"
	'// Filter the dataview to only show customers with the lastname = Smith
	dv.RowFilter = "code_value = '700'"
	for i = 0 to dv.Count -1
		Response.Write(dv(i)("code_display").ToString + " - " + dv(i)("code_value").ToString())
	next
end sub
</script>
    <body>
       <h3><font face="Verdana">DataView</font></h3>
        <form  runat=server>
	 <asp:button text="Read DataView" Onclick="readDs" runat=server/>
        </form>
    </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -