老师,帮我看下代码有点问题,
Dim cmd As New SQLCommand
cmd.C
For Each r As Row In Tables("滑道构成_Table3").Rows
If r IsNot Nothing Then
For i As Integer = 1 To r("amount")
cmd.commandtext ="Insert Into {part} ([partNo],[gelcoatColor],[thickness],[thickness2],[area],[size],[drawingNo],[partTemplateId],[productId],[remark,model],[state]) _
Values( '" &r("partNo")&"','"&r("gelcoatColor")&"','"&r("backColor")&"','"&r("thickness")&"', '"&r("thickness2")&", _
'"&r("area")&"','"&r("size")&"','"&r("drawingNo")&"','"&r("partTemplateId")&"','"&r("productId")&"','"&r("remark")&"','"&r("model")&"',"ll")"
cmd.ExecuteNonQuery
Next
End If
Next