温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:汽车配件公司网站(VB.net+Access数据库)源码
当前文件:
VbNetCompany/top/dismemo.aspx.vb,打开代码结构图
VbNetCompany/top/dismemo.aspx.vb,打开代码结构图1Imports System 2
Imports System.Data 3
Imports System.Configuration 4
Imports System.Collections 5
Imports System.Web 6
Imports System.Web.Security 7
Imports System.Web.UI 8
Imports System.Web.UI.WebControls 9
Imports System.Web.UI.WebControls.WebParts 10
Imports System.Web.UI.HtmlControls 11
Imports System.Data.OleDb 12
13
Public Partial Class top_dismemo 14
Inherits System.Web.UI.Page 15
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) 16
Using oleconn As New OleDbConnection() 17
oleconn.ConnectionString = ConfigurationManager.ConnectionStrings("oleConnectionString").ConnectionString 18
oleconn.Open() 19
Dim strSQL As String = "Select * From data where id=" + Request("id") 20
Dim command As New OleDbCommand(strSQL, oleconn) 21
Dim dataReader As OleDbDataReader = command.ExecuteReader() 22
If dataReader.Read() Then 23
Label1.Text = dataReader("name").ToString() 24
Label2.Text = dataReader("time").ToString() 25
Label3.Text = dataReader("neirong").ToString() 26
End If 27
dataReader.Close() 28
oleconn.Close() 29
oleconn.Dispose() 30
End Using 31
End Sub 32
End Class






