Foxtable(狐表)用户栏目专家坐堂 → [求助]


  共有2282人关注过本帖树形打印复制链接

主题:[求助]

帅哥哟,离线,有人找我吗?
大红袍
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2015/10/22 22:00:00 [显示全部帖子]

Dim Cols1() As String = {"单号", "品号", "品名", "数量", "单价", "金额", "下单日期", "交货日期", "迟交", "短交"}
Dim Cols2() As String = {"单号", "品号", "品名", "数量", "单价", "金额", "下单日期", "交货日期", "迟交", "短交"}
For Each tb As DataRow In ds.Tables("采购明细").Rows
    Dim s1 As String = ""
    Dim s2 As String = ""
    For i As Integer = 0 To Cols2.Length - 1
        s1 &= cols1(0) & ","
        s2 &= "'" & tb(cols2(0)) & "',"
    Next
    com = New SqlClient.SqlCommand("insert into 采购明细(" & s1.trim(",") & ") values (" & s2.trim(",") & ")", cn)    
    com.ExecuteNonQuery()   
Next

 回到顶部
帅哥哟,离线,有人找我吗?
大红袍
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2015/10/28 19:14:00 [显示全部帖子]

什么不一样?出什么错?msgbox看一下sql是什么内容

 回到顶部