ch14-05-04.aspx
来自「这是一个asp.net的全文教程.里面还有数据库的数据.对初学者有很大的帮助」· ASPX 代码 · 共 41 行
ASPX
41 行
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<% Response.Expires = 0 %>
<Html>
<Head>
<Script Language="VB" Runat="Server">
Sub Page_Load(Obj As Object, e As EventArgs)
Dim TableName As String = "UserDatas"
Dim DSN As String, tSQL As String
DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("ASP.NET网页数据库.mdb") & ";"
' 设置SQL语言的内容
tSQL = "Select * From UserDatas"
DataBind(DSN, tSQL, TableName)
End Sub
' 将DataSet与DataGrid控件集合的Sub程序
Sub DataBind(Byval DSN As String, Byval tSQL As String , _
ByVal TableName As String )
myDataGrid.Visible = "True"
Dim OBJConn As OleDbConnection = New OleDbConnection(DSN)
Dim OBJDS as DataSet=New DataSet()
Dim OBJCmd as New OleDbDataAdapter(tSQL, OBJConn)
OBJCmd.Fill(OBJDS, TableName)
MyDataGrid.Datasource=OBJDS.Tables(TableName).DefaultView
MyDataGrid.DataBind()
OBJConn.Close()
End Sub
</Script>
</Head>
<Body>
<H2>用户注册信息</H2>
<Form Runat="Server">
<asp:Datagrid runat="server"
Id="MyDataGrid"
GridLines="Both"
BorderColor="Black">
</asp:DataGrid>
</Form>
</Body>
</Html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?