各位大哥,我VB6编程时往access的一个表插入数据后,adodc引用了此表,同时datagrid绑定了此adodc,但表中的数据始终与datagrid显示的数据相差一条,请问怎样设定可以及时刷新显示啊access表中的数据datagrid中的数据
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 SubPublic Sub CloseConn()
Conn.Close
Set Conn = Nothing
End SubPrivate 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
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 SubPublic Sub CloseConn()
Conn.Close
Set Conn = Nothing
End SubPrivate 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
解决方案 »
- 请问怎么同时打开Form1和Form的窗口?
- 初学者:VB6+ADO访问Oracle数据库 连接串怎么写
- 大家帮帮忙,我用vb6的inet控件编写了一个自动下载程序,可是运行一段时间就出错了,急死人了!!!!! 是不是微软的inet控件不稳定呀?
- 很急很急--查讯的代码()格式是什么!!!有了答案立刻结帖。最好有例句
- ADODB.Stream的问题
- 班竹,各位大侠,帮帮忙唉!
- 高分请教字符数据转换显示,分不够可以再加,急急急!(个人有7310分)
- 请大家帮帮忙!
- 请问用数组作为传入参数调用vb做的dll中的函数总报错?请指教,谢谢!
- 请教关于MSCOMM控件的问题,请编过这方面软件的‘前辈’们回答~~
- 链接access
- 一些问题 +求vba的资料啊
Adodc2.Recordset.Requery
你在access表中插入数据后,按向上箭头,或者关闭acess表,然后再运行你的代码试试