用RS删除access表中的数据后,马上用另一个RS查询还有此记录?
用的是datagrid控件,选中一行后点删除命令,access表中的记录确已删除,但是显示时还在/再点一次删除上一次删除的记录会消失.
代码如下:
Private Sub del(x As String)
Dim conn_del As New ADODB.Connection
Dim rs_del As New ADODB.Recordset
Dim constr As String
Dim dstring As String
dstring = "delete * from p where 姓名='" & x & "'"
constr = "provider=Microsoft.Jet.OLEDB.4.0;Data source =" & App.Path & "/1.mdb"
conn_del.Open constr
rs_del.Open dstring, conn_del, 1, 2
Set rs_del = Nothing
conn_del.Close
Set conn_del = Nothing
End Sub
Private Sub Command_del_Click()
DataGrid1.AllowDelete = True
If rs_query.State = adStateOpen Then
rs_query.Close
del (dkey)
End If
If rs_query.State = 1 Then
MsgBox ("open")
End If
DataGrid1.AllowDelete = False
rs_query.Open str, conn_query, adOpenKeyset, adLockPessimistic
If rs_query.BOF = True And rs_query.EOF = True Then
label_statistic.Caption = ""
MsgBox ("没有查到你要找的信息")
Else
label_statistic.Caption = "总计有" + CStr(rs_query.RecordCount) + "记录"
Set DataGrid1.DataSource = rs_query
End If
End Sub
代码如下:
Private Sub del(x As String)
Dim conn_del As New ADODB.Connection
Dim rs_del As New ADODB.Recordset
Dim constr As String
Dim dstring As String
dstring = "delete * from p where 姓名='" & x & "'"
constr = "provider=Microsoft.Jet.OLEDB.4.0;Data source =" & App.Path & "/1.mdb"
conn_del.Open constr
rs_del.Open dstring, conn_del, 1, 2
Set rs_del = Nothing
conn_del.Close
Set conn_del = Nothing
End Sub
Private Sub Command_del_Click()
DataGrid1.AllowDelete = True
If rs_query.State = adStateOpen Then
rs_query.Close
del (dkey)
End If
If rs_query.State = 1 Then
MsgBox ("open")
End If
DataGrid1.AllowDelete = False
rs_query.Open str, conn_query, adOpenKeyset, adLockPessimistic
If rs_query.BOF = True And rs_query.EOF = True Then
label_statistic.Caption = ""
MsgBox ("没有查到你要找的信息")
Else
label_statistic.Caption = "总计有" + CStr(rs_query.RecordCount) + "记录"
Set DataGrid1.DataSource = rs_query
End If
End Sub
...全文
相关推荐
使用VB如何查询ACCESS数据库中的表
在VB(Visual Basic)编程环境中,查询ACCESS数据库中的表是一个常见的任务,这主要涉及到ADO(ActiveX Data Objects)技术。以下将详细介绍如何实现这一过程。
vb读取、写入、修改、删除access数据库
DAO可以直接操作表和查询,但ADODB提供了更广泛的数据库兼容性。9. **菜单文件**: - 提到的"Menu"可能是指VB程序中的菜单结构,用于触发上述数据库操作。
MFC对ACCESS数据库的增加、删除、查找、修改
接着,使用`CTable`或`CRecordset`类来操作数据。`CTable`直接映射到数据库表,而`CRecordset`提供了一个记录集,允许遍历和操作数据。
MFC中Access数据库的运用。可查询,删除,添加数据
在本文中,我们将深入探讨如何在Microsoft Foundation Class (MFC)框架中利用Access数据库进行数据操作,包括连接、查询、添加、修改和删除数据。
用ASP实现将ACCESS表中的数据记录导入到EXCEL文件中
首先,创建一个Recordset对象,然后通过Open方法执行SQL查询,将ACCESS表中的数据读取到Recordset中。


VB基础类
