Private Sub Command2_Click()
Dim i As Integer
Dim n As Integer
n = 0With ListView1
For i = 1 To .ListItems.Count
If .ListItems(i) = "√" Then
n = n + 1
id = i
End If
NextIf n = 1 Then
If MsgBox("真的要删除 [序号" & id & "] 的数据吗?", vbQuestion + vbYesNo + vbDefaultButton2, "提示") = vbNo Then
Exit Sub
End If
End If
If n > 1 Then
If MsgBox("真的要删除这[" & n & "]条数据吗?", vbQuestion + vbYesNo + vbDefaultButton2, "提示") = vbNo Then
Exit Sub
End If
End IfFor i = 1 To .ListItems.Count
If .ListItems(i) = "√" Then
Set rs = Adodc1.Recordset
rs.ActiveConnection.Execute "Delete From ServerData Where 文件='" & 这里怎么写啊?谢谢 & "'"
rs.ActiveConnection.Execute "Delete From ServerData Where 文件='" & Trim(MSHFlexGrid1.TextMatrix(i, 1)) & "'"以前用MSHFlexGrid是这样listview不知道怎么删了
End If
Next i
End With
End Sub
Dim i As Integer
Dim n As Integer
n = 0With ListView1
For i = 1 To .ListItems.Count
If .ListItems(i) = "√" Then
n = n + 1
id = i
End If
NextIf n = 1 Then
If MsgBox("真的要删除 [序号" & id & "] 的数据吗?", vbQuestion + vbYesNo + vbDefaultButton2, "提示") = vbNo Then
Exit Sub
End If
End If
If n > 1 Then
If MsgBox("真的要删除这[" & n & "]条数据吗?", vbQuestion + vbYesNo + vbDefaultButton2, "提示") = vbNo Then
Exit Sub
End If
End IfFor i = 1 To .ListItems.Count
If .ListItems(i) = "√" Then
Set rs = Adodc1.Recordset
rs.ActiveConnection.Execute "Delete From ServerData Where 文件='" & 这里怎么写啊?谢谢 & "'"
rs.ActiveConnection.Execute "Delete From ServerData Where 文件='" & Trim(MSHFlexGrid1.TextMatrix(i, 1)) & "'"以前用MSHFlexGrid是这样listview不知道怎么删了
End If
Next i
End With
End Sub
解决方案 »
- 为什么toolbar和imagelist关联起来确还是不会显示图片?有什么属性会限制吗?
- 关闭windows进程的问题
- 我想用VB写一个FTP的上传程序,具体情况如下!
- 求助图片移动的小程序例题??
- 请问如何将屏幕操作录制成AVI呢?
- 如何对PDF文件进行版面分析?
- 急需用VB编写的跑马灯网页
- VB6 插入图片到excel的指定的单元格中,调整图片大小后无法释放进程问题
- RichText中如何画表格???
- ADO与access??????????????????????????????????????????????????????????????
- 如何在自绘控件显示中文输入法的文字显示窗口
- 网络问题
Dim i As Integer
Dim n As Integer
Dim selStr as String'加上这一句n = 0
selStr=""With ListView1
For i = .ListItems.Count To 1 Step -1
If .ListItems(i) = "√" Then
n = n + 1
selStr=selStr & "," & .ListItems(i).Text & "'"'加上这一句
End If
Next If n = 1 Then
If MsgBox("真的要删除 [序号" & 这里怎么写?别用.SelectedItem.Index啊,因为这个是按选择的行而不是.ListItems(i) = "√" 里某行的序号 & "] 的数据吗?", vbQuestion + vbYesNo + vbDefaultButton2, "提示") = vbNo Then
Exit Sub
End If
End If If n > 1 Then
If MsgBox("真的要删除这[" & n & "]条数据吗?", vbQuestion + vbYesNo + vbDefaultButton2, "提示") = vbNo Then
Exit Sub
End If
End If selStr="('" & Mid(selStr,2) & ")"'加上这一句,用于sql中作为in语句的条件rs.ActiveConnection.Execute "Delete From ServerData Where " & Adodc1.Recordset.Fields(0).Name & " in " & selStr
End With
End Sub