vb6.0连接数据库的方法VB6.0中mdb数据库经典连接

导读DimconAsNewADODB.ConnectionDimrsAsNewADODB.RecordsetDimconnstrf3AsStringIfrs.S....

Dim con As New ADODB.Connection Dim rs As New ADODB.RecordsetDim connstrf3 As StringIf rs.State = adStateOpen Then rs.CloseIf con.State = adStateOpen Then con.Close，接下来我们就来聊聊关于vb6.0连接数据库的方法?以下内容大家不妨参考一二希望能帮到您!

vb6.0连接数据库的方法

Dim con As New ADODB.Connection Dim rs As New ADODB.RecordsetDim connstrf3 As String

If rs.State = adStateOpen Then rs.CloseIf con.State = adStateOpen Then con.Close

connstrf3 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\数据库名.mdb;Persist Security Info=False"con.ConnectionString = connstrf3con.Opencon.CursorLocation = adUseClient

rs.Open "SELECT * FROM 老师 WHERE 教师编号=" & Text9.Text & "", con, , adLockOptimisticSet DataGrid1.DataSource = rs