这是一个asp.net的全文教程.里面还有数据库的数据.对初学者有很大的帮助

				
				
				
				
				
				
				
				
				
				Ch15-03-02.aspx SELECT语句的筛选条件
				
				Sub Page_Load(Obj As Object, e As EventArgs)
				Dim DSN As String, tSQL As String
				' 设置使用联机字符串 
				DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
				     Server.MapPath("/ASP/Chap14/ASP.NET网页数据库.mdb") & ";"
				' 设置SQL语句
				tSQL = "SELECT UID As 编号, UserName As 姓名, " & _
				     "EMail As 电子邮件地址, UserAccount As 登录账号, " & _
				     "UserPWD As 密码 FROM UserDatas WHERE UID 				ShowResultSet(DSN, tSQL)
				End Sub