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的朋友接受……