版主

我从SQL上用以下代码下载数据后，产品相同的有重复的，可以不可以下载后把所有相同产品代码的数量相加。只要一条记录一个产品。

谢谢。

Dim cmd As New SQLCommand
Dim dt As DataTable
DataTables("QC").datarows.clear
cmd.C
Dim Cols1() As String = {"FFullNumber","FName","FQty","FQcheckQty"}
Dim Cols2() As String = {"FFullNumber","FName","FQty","FQcheckQty"}

dt = cmd.ExecuteReader()
For Each dr1 As DataRow In dt.DataRows
    Dim dr2 As DataRow = DataTables("BOm").AddNew()
    For i As Integer = 0 To Cols1.Length -1
        dr2(Cols2(i)) = dr1(Cols1(i))
         Next
Next

Tables("QC").ResumeRedraw()

Tables("QC").Sort = "FBOMNumber"
DataTables.save

中间这段代码传不上来，不知道为什么，只能用截图