1,216
社区成员
发帖
与我相关
我的任务
分享
Public Conn As New ADODB.Connection
Public Rs As New ADODB.Recordset
Public Sub OpenConn()
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\AlarmInf.mdb;Persist Security Info=False"
Conn.CursorLocation = adUseClient
Conn.Open
End Sub
Public Sub CloseConn()
Conn.Close
Set Conn = Nothing
End Sub
Private Sub Command1_Click()
Call OpenConn
Conn.Execute "insert into activealarm([SID],[Note]) select ID,Note from alarmlist where address='M5005'"
Adodc2.Refresh
Set DataGrid2.DataSource = Adodc2
'Adodc2.Refresh
DataGrid2.Refresh
Call CloseConn
End Sub