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
,