我是学asp.net的新手 ,那位高手能告诉我连数据库方法?

来源:百度知道 编辑:UC知道 时间:2024/05/16 10:14:24

<%@import namespace="system.data"%>
<%@import namespace="system.data.oledb"%>
<script language=vb runat=server>
sub page_load(sender as object,e as eventargs)
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" & Server.MapPath("data/test.mdb"))
Dim comm As New OleDbCommand
Dim reader As OleDbDataReader
comm.Connection = conn
conn.Open()
comm.Connection = conn
comm.command="select * from testdata"
reader = comm.ExecuteReader
while reader.read
lab1.text=lab1.text & reader("username") &"<br><hr>"
end while
reader.Close()
reader = Nothing
conn.Close()