62,243
社区成员
发帖
与我相关
我的任务
分享下面这一段连接数据库的代码有问题吗?
myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\test\db1.mdb;"
Dim myConnection As New OleDbConnection(myConnectionString)
myConnection.Open()
myCommand.Connection.Close()
Dim myConnection As New OleDbConnection(myConnectionString)
myConnection.Open()
myCommand.Connection.Close()
...全文
请发表友善的回复…
发表回复
adminyao 2004-11-04
- 打赏
- 举报
Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("" & db & ""))
Dim MyCommand As OleDbCommand
MyCommand = New OleDbCommand("Select studid,userid,userpwd,locked from student where userid='" & membername & "'", conn)
MyCommand = New OleDbCommand(strsql, conn)
conn.Open()
Dim drr As OleDbDataReader = MyCommand.ExecuteReader
.
.
.
MyCommand1.Dispose()
drr.Close()
conn.Close()
Dim MyCommand As OleDbCommand
MyCommand = New OleDbCommand("Select studid,userid,userpwd,locked from student where userid='" & membername & "'", conn)
MyCommand = New OleDbCommand(strsql, conn)
conn.Open()
Dim drr As OleDbDataReader = MyCommand.ExecuteReader
.
.
.
MyCommand1.Dispose()
drr.Close()
conn.Close()
