Dim Cols1() As String = {"单号", "品号", "品名", "数量", "单价", "金额", "下单日期", "交货日期", "迟交", "短交"}
Dim Cols2() As String = {"单号", "品号", "品名", "数量", "单价", "金额", "下单日期", "交货日期", "迟交", "短交"}
For Each tb As DataRow In ds.Tables("采购明细").Rows
For i As Integer = 0 To Cols2.Length - 1
com = New SqlClient.SqlCommand("insert into 采购明细( Cols1(i))values(tb(cols2(i)))", cn)
com.ExecuteNonQuery()
Next
Next
哪位高手能告诉我为啥空的就插入成功,有数据就说语法错误????