Private Sub cmddel_Click()
Call Conndata
Set conn = New ADODB.Connection
conn.open connstr
Set rs = New ADODB.Recordset
sqlstr = "select * from class"
rs.Open sqlstr, conn, 1, 3
Dim msg As String
msg = MsgBox("确定要删除吗?", vbYesNo, "提示")
If msg = vbYes Then
Do While rs.EOF
If rs.Fields("classid") = DataGrid1.Columns(0) Then
rs.Delete
End If
rs.MoveNext
Loop
DataGrid1.Refresh
MsgBox "删除成功", , "提示"
Else
Exit Sub
End If
End Sub//以下是call conndata部分,写在模块里
Public Sub Conndata()
Connstr = "PROVIDER = Microsoft.Jet.OLEDB.4.0;Data Source= " + App.Path + "\product.mdb;"
End Sub
Call Conndata
Set conn = New ADODB.Connection
conn.open connstr
Set rs = New ADODB.Recordset
sqlstr = "select * from class"
rs.Open sqlstr, conn, 1, 3
Dim msg As String
msg = MsgBox("确定要删除吗?", vbYesNo, "提示")
If msg = vbYes Then
Do While rs.EOF
If rs.Fields("classid") = DataGrid1.Columns(0) Then
rs.Delete
End If
rs.MoveNext
Loop
DataGrid1.Refresh
MsgBox "删除成功", , "提示"
Else
Exit Sub
End If
End Sub//以下是call conndata部分,写在模块里
Public Sub Conndata()
Connstr = "PROVIDER = Microsoft.Jet.OLEDB.4.0;Data Source= " + App.Path + "\product.mdb;"
End Sub
解决方案 »
- 求一个IP端口重新定向例子
- 谁可以用比较通俗的语言或者自己的使用心得 说下Sleep与DoEvents使用区别?
- 问几个关于webbrowser制作浏览器的问题。
- 为什么回答问题,只长专家分,可用分却不长?
- 大家帮帮我,一个关于dll调用的参数问题
- 如何实现动态添加输入框?
- 吓了一跳,放分,VBREZQ反编译VB6的。
- 如何把Edit的内容转成整型??
- 如何将已有的水晶报表添加到现有的工程?(立刻给分)
- 如何在局域网上搜索代理?
- 在VB中打开一个WORD或 EXCEL对象后,如何动态的得到WORD或 EXCEL的操作信息?其实根本的目的就是想打开WORD对象后,实现WORD对象和VB程序的
- 怎样向treeview中添加和删除节点?
Private Sub cmddel_Click()
Call Conndata
Set conn = New ADODB.Connection
conn.open connstr
conn.execute "delete from class where classid='"& datagrid1.columns(0) &"'"
MsgBox "删除成功", , "提示"
End Sub
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB;Persist Security Info=False
Dim ask As String
ask = MsgBox("是否删除分类?", vbYesNo, "提示")
If ask = vbYes Then
rs.Delete
rs.Update
Else
Exit Sub
End If
End Sub这样能删除
用一个classno的变量来记录分类的IDPrivate Sub cmddel_Click()
classno = DataGrid1.Columns(0).Text
Dim ask As String
ask = MsgBox("是否删除分类?", vbYesNo, "提示")
If ask = vbYes Then
sqlstr = "delete from class where classid=" & classno
conn.Execute (sqlstr)
DataGrid1.Refresh
Else
Exit Sub
End If
End Sub=======================问题请教:在删除后刷新不了,有什么方法在删除后刷新呢?
Call Conndata
Set conn = New ADODB.Connection
conn.open connstr
Set rs = New ADODB.Recordset
sqlstr = "select * from class"
rs.Open sqlstr, conn, 1, 3
Dim msg As String
msg = MsgBox("确定要删除吗?", vbYesNo, "提示")
If msg = vbYes Then
rs.Delete
MsgBox "删除成功", , "提示"
Else
Exit Sub
End If
End Sub要刷新DataGria的话介意把数据库的连接和 DataGrid.DataSource=Rs等语句写到一个过程里面
要刷新的话 调用此过程就行了