For Each tab As Table In Tables '遍历Tables
If tab.Name.Contains("文档") '判断文档两字的表名
For i As Integer = 0 To Tables(tab.Name).Rows.Count -1 '从第一行开始到结束行
Select Case e.DataCol.Name
Case "品名","型号","规格","单价"
Dim Filter As String = "[产品编号] = '" & e.DataRow("产品编号") & "'"
DataTables(tab.Name).ReplaceFor(e.DataCol.Name, e.NewValue, Filter)
End Select
Next
End If
Next
对了,我更新的时候是用遍历同时对多个文档更新内容的,单是你现在这个只能单独解决一个文档的问题,不能像更新一样同时解决所有文档的问题,能不能改一下!谢谢!
还有:Dim Filter As String = "[产品编号] = '" & e.OldValue & "'"
Dim ss() As String ={"品名","型号","规格","单价"}
For Each s As String In ss
这2句是什么意思能解释下吗?
[此贴子已经被作者于2013-4-7 23:16:55编辑过]