帮助：
'Dim cmd As New SQ-LCommand
'cmd.C
'Dim dt As DataTable
'Dim Cols1() As String = {"来源列一", "来源列二", "来源列三"}
'Dim Cols2() As String = {"接收列一", "接收列二", "接收列三"}
'cmd.CommandText = "SELEC-T * From {表A} Where 条件语句"
'dt = cmd.ExecuteReader()
'For Each dr1 As DataRow In dt.DataRows
' Dim dr2 As DataRow = DataTables("表B").AddNew()
' For i As Integer = 0 To Cols1.Length - 1
' dr2(Cols2(i)) = dr1(Cols1(i))
' Next
'Next
MYSQ-L
'Dim db = HySq-l.DataBaseFactory.CreateDatabase("my")
'Dim Sql = "Selec-t 产品编号, max(日期) as 日期 From {kcxb_tb} group by 产品编号"
'Dim Cols1() As String = {"来源列一", "来源列二", "来源列三"}
'Dim Cols2() As String = {"来源列一", "来源列二", "来源列三"}
'Dim dt As system.data.DataTable = db.ExecuteDataSet(Sq-l).Tables(0)
'dt.TableName = "kcb_tb"
'For Each dr1 As DataRow In dt.Rows
' Dim dr2 As DataRow = DataTables("登记窗口_Table1").AddNew()
' For i As Integer = 0 To Cols1.Length - 1
' dr2(Cols2(i)) = dr1(Cols1(i))
' Next
'Next
报错提：
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '} group by 产品编号' at line 1
加好友 
发短信
Post By：2023/11/6 10:53:00 [只看该作者]
