Private Sub cmdDelete_Click()
Dim SubConDel As ADODB.Recordset
Dim ContNum As String
Dim ConDate As String
If SubConRs.RecordCount <> 0 Then
SubConRs.MoveFirst
If Not SubConRs.EOF Or SubConRs.BOF Then
If MsgBox("Are you Sure?", vbQuestion + vbYesNo) = vbYes Then
Set SubConDel = New ADODB.Recordset
grdWork.Row = grdWork.Row
grdWork.Col = 1: ContNum = grdWork.Text
grdWork.Col = 2: ConDate = grdWork.Text
sqlString = "Select * from SubConWorkDetails where SubConNum=" & _
Trim(lstSubCon.SelectedItem.SubItems(1)) & _
" and ContractNo='" & Trim(ContNum) & "' and Date=#" & Format(ConDate, "m/d/yyyy") & "#"
SubConDel.Open sqlString, DB, adOpenStatic, adLockOptimistic
If SubConDel.RecordCount <> 0 Then
SubConDel.Delete
End If
ClearGrid
FromListUpdateRecord
End If
End If
End If
End Sub grdWork.Row = grdWork.Row
grdWork.Col = 1: ContNum = grdWork.Text
grdWork.Col = 2: ConDate = grdWork.Text这几句是什么意思?请教一下
Dim SubConDel As ADODB.Recordset
Dim ContNum As String
Dim ConDate As String
If SubConRs.RecordCount <> 0 Then
SubConRs.MoveFirst
If Not SubConRs.EOF Or SubConRs.BOF Then
If MsgBox("Are you Sure?", vbQuestion + vbYesNo) = vbYes Then
Set SubConDel = New ADODB.Recordset
grdWork.Row = grdWork.Row
grdWork.Col = 1: ContNum = grdWork.Text
grdWork.Col = 2: ConDate = grdWork.Text
sqlString = "Select * from SubConWorkDetails where SubConNum=" & _
Trim(lstSubCon.SelectedItem.SubItems(1)) & _
" and ContractNo='" & Trim(ContNum) & "' and Date=#" & Format(ConDate, "m/d/yyyy") & "#"
SubConDel.Open sqlString, DB, adOpenStatic, adLockOptimistic
If SubConDel.RecordCount <> 0 Then
SubConDel.Delete
End If
ClearGrid
FromListUpdateRecord
End If
End If
End If
End Sub grdWork.Row = grdWork.Row
grdWork.Col = 1: ContNum = grdWork.Text
grdWork.Col = 2: ConDate = grdWork.Text这几句是什么意思?请教一下
解决方案 »
- 用Shell32.DLL中的BrowseForFolder方法,浏览文件夹问题?立即结帐100分!!
- 初学者提问:模块(.bas) 类(.cls)有何区别?
- 求助(EXCEL中如何在不同的列中依次输出所要的数值) 万分感谢!
- 学vb有哪些比较好的书,请大虾们推荐几本
- 关于图片的反转和分辨率问题!
- 请帮帮小弟:台湾SQL Server数据库服务器+台湾的ASP空间,通过ASP页面可以查看及以简体中文来修改,但用VB编写的简体版程序直接连接数据库时
- 怎么提取combo的运算符
- 增分!PowerDesigner
- 读取GPRS数据
- 请问如何清空Table?
- 如何中断程序运行,另一窗口被打开,当这窗口被关闭后,返回一值,为真就继续允许,否则……
- 如何取得一个文件夹中的所有子文件夹的名称
然后取出这一行的第一列的内容(grdWork.Col = 1: ContNum = grdWork.Text)
取出这一行的第二列的内容(grdWork.Col = 2: ConDate = grdWork.Text)
grdWork.Col = 2: ConDate = grdWork.Text
取得当前行第一列和第二列的值.(0列起头)
grdWork.Col = 1: ContNum = grdWork.Text
grdWork.Col = 2: ConDate = grdWork.Text
将当前行第一列和第二列的数据放入变量中,不过第一句没用!!这三行代码可以用下面两句代码代替:ContNum = grdWork.TextMatrix (grdWork.Row, 1)
ConDate = grdWork.Text (grdWork.Row, 2)