Dim strSQL As String
Dim myBook As Variant
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str2 As String
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.ConnectionString = connstr
cnn.Open
rs.Open "SELECT * FROM to_repeat where yz_date between' " + Str(DTPicker1.Value) + "' and '" + Str(DTPicker2.Value) + "' order by yz_date", cnn
str2 = MsgBox("确定要删除查询到的数据?", vbOKCancel, "提示")
If str2 = vbOK Then
If (DTPicker1.Value <> "") Then
rs.Delete
rs.MoveNext
MsgBox "删除成功", vbOKOnly + vbInformation, "提示"
rs.Close
Set cnn = Nothing
End If
End If
为什么只删除一条数据呢??明明查到N条啊。。
Dim myBook As Variant
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str2 As String
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.ConnectionString = connstr
cnn.Open
rs.Open "SELECT * FROM to_repeat where yz_date between' " + Str(DTPicker1.Value) + "' and '" + Str(DTPicker2.Value) + "' order by yz_date", cnn
str2 = MsgBox("确定要删除查询到的数据?", vbOKCancel, "提示")
If str2 = vbOK Then
If (DTPicker1.Value <> "") Then
rs.Delete
rs.MoveNext
MsgBox "删除成功", vbOKOnly + vbInformation, "提示"
rs.Close
Set cnn = Nothing
End If
End If
为什么只删除一条数据呢??明明查到N条啊。。
解决方案 »
- 关于Socket Server 的问题
- vb 操作 excel 添加列问题
- 用VB如何实现获取网口的IP地址
- 用代码设置打印机默认纸张时出现 内存不能为read,急盼解决!
- (100分!!!)控件布局问题,大家进来!
- 菜鸟问题:怎么把动态图片(GIF)导入到VB程序中?怎么把图片封装到VB生成EXE中?
- PCL730输出
- 有沒有用VB寫OCX的高手﹖只能有回答在下的難道就有分﹐解決問題一定重謝+200分﹐很急﹐很急!!!!!!!!!!!!
- 请问一下不用winsock可不可以实现一组简单命令的发送?
- 如何让文本框只能输入两位小数?
- 调用directshow时实现全屏的问题
- 常量wdHorizontalPositionRelativeToPage 的数值是多少
If str2 = vbOK Then
If (DTPicker1.Value <> "") Then
Do While not rs.eof
rs.Delete
rs.MoveNext
loop
end if
end if