particular.aspx.vb

《ASP.NET C#程序设计案例教程》

Imports System
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Data
Imports System.Data.OleDb

Public Class Particular: Inherits Page
	Public message As Label

	Sub Page_Load(Sender As Object, E As EventArgs)
		Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("address.mdb"))							'建立Connection对象
	   '建立SQL语句，请注意要获取传递过来的id的值
		Dim strSql As String
		strSql="Select * From users Where id=" & Request.QueryString("id")   
		Dim cmd As New OleDbCommand(strSql, conn)				'建立Command对象
		conn.Open()                                            
		Dim dr As OleDbDataReader = cmd.ExecuteReader()			'建立DataReader对象
		'下面开始显示数据
		dr.Read()												'dr.Read()就会读取当前记录
		message.Text = "姓名：" & dr.Item("name") 
		message.Text &= "<br>电话：" & dr.Item("tel")
		message.Text &= "<br>email：<a href='mailto:" & dr.Item("email") & "' target='_blank'>" & dr.Item("email") & "</a>" 
		message.Text &= "<br>简介：" & dr.Item("intro") 
		message.Text &= "<br>提交时间：" & dr.Item("submit_date") 
		conn.Close()                                              
	End Sub
End Class