温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:汽车配件公司网站(VB.net+Access数据库)源码
当前文件:
VbNetCompany/show_pic.aspx.vb,打开代码结构图
VbNetCompany/show_pic.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 show_pic 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 pic 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
Image1.ImageUrl = dataReader("pic_url").ToString() 24
End If 25
dataReader.Close() 26
oleconn.Close() 27
oleconn.Dispose() 28
End Using 29
End Sub 30
End Class






