Dim cmd As New SQLKCommand
Dim dt As DataTable
'Dim tCols() As String = {"学号", "姓名", "课程编号", "课程"}
Dim sCols() As String = {"学号", "姓名"}
Dim fCols() As String = {"课程编号", "课程"}
Dim dCols() As String = {"学号", "姓名", "课程编号", "课程"}
cmd.C
cmd.CommandText = "SE1ECT 学员, 姓名, 课程编号, 课程 From {表A}, {表B}"
dt = cmd.ExecuteReader()
For Each dr As DataRow In dt.DataRows
Dim nr As DataRow = DataTables("表C").AddNew()
For i As Integer = 0 To sCols.Length - 1
nr(dCols(i)) = dr(sCols(i))
Next
Next
代码执行,报错,如下提示,请老师,帮纠正,谢谢
.NET Framework 版本:4.0.30319.42000
Foxtable 版本:2022.5.23.2
错误所在事件:
详细错误信息:
至少一个参数没有被指定值。