Imports System.Data
'读取,Select
Dim Conn As New OleDb.OleDbConnection '相当于server.CreateObject("adodb.connection")
Dim Comm As New OleDb.OleDbCommand
Dim Reader As OleDb.OleDbDataReader '相当于server.CreateObject("adodb.recordset")
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("app_data/database.mdb") & ";user id=;password=;persist security info=true;" '设置ConnectionString
Conn.Open() '相当于ASP里的Conn
Comm.Connection = Conn 'ASP.Net必须的步骤,绑定连接组件
Comm.CommandText = "select * from members where username='" & username & "'" '设定sql命令
Reader = Comm.ExecuteReader '相当于rs.open sql,conn,1,1
Reader.Read '必须要先读才能使用Reader.Item("")
Reader.Item("xx") '相当于rs("xx")
Reader.Read '相当于rs.movenext
'最后:
Reader.Close
Conn.Close
'Comm不用关闭,Comm只是传达命令的中转站
'执行命令
Dim Conn As New OleDb.OleDbConnection '相当于server.CreateObject("adodb.connection")
Dim Comm As New OleDb.OleDbCommand
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("app_data/database.mdb") & ";user id=;password=;persist security info=true;" '设置ConnectionString
Conn.Open() '相当于ASP里的Conn
Comm.Connection = Conn 'ASP.Net必须的步骤,绑定连接组件
Comm.CommandText = "update等语句"
Comm.ExecuteNonQuery() '相当于conn.execute sql
这些ASP.Net读取数据库代码是于ASP读取数据库最相似的代码,最容易被刚从ASP转入ASP.Net的朋友接受……