数据库为stockinfo2k.mdb,表为userinfo,字段为name
listname为text控件
Private Sub del()
Dim cn As Connection
Dim rs As Recordset
Dim cnStr As String
Dim rsStr As String
cnStr = "provider=microsoft.jet.oledb.4.0;data source=" & App.Path & "\db\StockInfo2k.mdb"
rsStr = "delete * from userinfo where name=" & "'" & Trim(ListName.Text) & "'"
Set cn = New Connection
Set rs = New Recordset
cn.CursorLocation = adUseClient
cn.Open cnStr
rs.Open rsStr, cn
rs.Close-----------------------------这一句出错。
cn.Close
End Sub
*********************************************************************************
另外,这个表是连接到listbox控件的。
进行了delete,update,insert into 这些 sql语句,要怎么才能刷新listbox上显示的记录.
我连接listbox的方法哪下:
Private Sub listboxDisplay()
Dim cn As Connection
Dim rs As Recordset
Dim tempstr As String
Dim cnStr As String
Dim rsStr As String
cnStr = "provider=microsoft.jet.oledb.4.0;data source=" & App.Path & "\db\StockInfo2k.mdb"
rsStr = "select name from userinfo"
Set cn = New Connection
Set rs = New Recordset
cn.CursorLocation = adUseClient
cn.Open cnStr
rs.Open rsStr, cn
Do Until rs.EOF
tempstr = rs("name")
ListName.AddItem tempstr
rs.MoveNext
Loop
rs.Close
cn.Close
End Sub
listname为text控件
Private Sub del()
Dim cn As Connection
Dim rs As Recordset
Dim cnStr As String
Dim rsStr As String
cnStr = "provider=microsoft.jet.oledb.4.0;data source=" & App.Path & "\db\StockInfo2k.mdb"
rsStr = "delete * from userinfo where name=" & "'" & Trim(ListName.Text) & "'"
Set cn = New Connection
Set rs = New Recordset
cn.CursorLocation = adUseClient
cn.Open cnStr
rs.Open rsStr, cn
rs.Close-----------------------------这一句出错。
cn.Close
End Sub
*********************************************************************************
另外,这个表是连接到listbox控件的。
进行了delete,update,insert into 这些 sql语句,要怎么才能刷新listbox上显示的记录.
我连接listbox的方法哪下:
Private Sub listboxDisplay()
Dim cn As Connection
Dim rs As Recordset
Dim tempstr As String
Dim cnStr As String
Dim rsStr As String
cnStr = "provider=microsoft.jet.oledb.4.0;data source=" & App.Path & "\db\StockInfo2k.mdb"
rsStr = "select name from userinfo"
Set cn = New Connection
Set rs = New Recordset
cn.CursorLocation = adUseClient
cn.Open cnStr
rs.Open rsStr, cn
Do Until rs.EOF
tempstr = rs("name")
ListName.AddItem tempstr
rs.MoveNext
Loop
rs.Close
cn.Close
End Sub
解决方案 »
- 如果将焦点移动到Combobox控件上呢?在线等,谢谢!
- 一个很简单的问题,但是不知道如果解决????急急急急急急
- 如何与delphi编写的winsock客户端连接?
- 双网卡情况下,如何禁用和启用其中一块网卡!
- %%%向绝对高手征集将exe转换为activex dll的方案(500分)%%%
- winsock问题???
- 使用VBA在Excel中如何合并单元格
- 在98下安装,dataform和danim两个控件的注册错误,可是我已经将msvbvm60.dll打包了呀????没有人能解答吗????
- 请问如何实现对指定的图片进行背景某种颜色的透明处理??处理后的图片还能进行变换么(如放大)?
- VB中真的不能实现多线程吗???--我不信.....
- 回答问题被抗议,散分
- 关于公共对话框设置的问题,急救?!
Private Sub del()
Dim cn As Connection
Dim cnStr As String
Dim rsStr As String
cnStr = "provider=microsoft.jet.oledb.4.0;data source=" & App.Path & "\db\StockInfo2k.mdb"
rsStr = "delete * from userinfo where name=" & "'" & Trim(ListName.Text) & "'"
Set cn = New Connection
cn.CursorLocation = adUseClient
cn.Open cnStr
cn.Execute rsStr
cn.Close
Set cn=Nothing
End Sub
进行了delete,update,insert into 这些 sql语句,要怎么才能刷新listbox上显示的记录.
------------------------------
先清除List的内容(list1.Clear ),再调用一下listboxDisplay()过程(Call listboxDisplay )就是刷新了
--------
我问错了,本意是,要如何进行了delete,update,insert into 这些 sql语句?
都不用rs作为recordset可以进行吗?
都用cn作为connection并用execute??
----
我在公共模块有定义了一个g_conn作为connection!
但是g_conn.execute(sql语句)会出错.
所以我才改用重新定议了一个cn,rs.
"rs.Close-----------------------------这一句出错。"
这一句为什么会出错???
rs.Close-----------------------------这一句出错。因为rsStr是删除语句,所以执行后,rs的状态并不是打开的,所以关闭它时会出错,可以这样写:rs.Open rsStr, cn
If rs.State = adStateOpen Then rs.Close
Dim cn As Connection
Dim rs As Recordset
Dim cnStr As String
Dim rsStr As String
cnStr = "provider=microsoft.jet.oledb.4.0;data source=" & App.Path & "\db\StockInfo2k.mdb"
rsStr = "delete * from userinfo where name=" & "'" & Trim(ListName.Text) & "'"
Set cn = New Connection
cn.CursorLocation = adUseClient
cn.Open cnStr
cn.Execute rsStr
cn.Close
set cn = nothinglistboxDisplayEnd SubPrivate Sub listboxDisplay()
Dim cn As Connection
Dim rs As Recordset
Dim tempstr As String
Dim cnStr As String
Dim rsStr As String
cnStr = "provider=microsoft.jet.oledb.4.0;data source=" & App.Path & "\db\StockInfo2k.mdb"
rsStr = "select name from userinfo"
Set cn = New Connection
Set rs = New Recordset
cn.CursorLocation = adUseClient
cn.Open cnStr
rs.Open rsStr, cnListName.ClearDo Until rs.EOF
tempstr = rs("name")
ListName.AddItem tempstr
rs.MoveNext
Loop
rs.Close
set rs = nothing
cn.Close
set cn = nothing
End Sub