Foxtable(狐表)用户栏目专家坐堂 → 感觉这段代码执行起来很慢,是不是代码可以优化一下?请各位指点一下奥~~


  共有3950人关注过本帖平板打印复制链接

主题:感觉这段代码执行起来很慢,是不是代码可以优化一下?请各位指点一下奥~~

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


加好友 发短信
等级:五尾狐 帖子:1062 积分:9781 威望:0 精华:0 注册:2012/3/13 5:23:00
感觉这段代码执行起来很慢,是不是代码可以优化一下?请各位指点一下奥~~  发帖心情 Post By:2014/1/4 14:30:00 [只看该作者]

DataTables("newmoo_product").save()
DataTables("订单号").addnew()

Dim Cols1() As String = {"ID","leaderID","备注2","订货数量","大小颜色","档口名称"}
Dim Cols2() As String = {"productID","leaderID","weight","productNum","color","lable"}

For Each dr1 As DataRow In DataTables("newmoo_product").Select("[id] Is not Null")
  Dim dr2 As DataRow = DataTables("订单").AddNew()
 For i As Integer = 0 To Cols1.Length -1
       dr2(Cols2(i)) = dr1(Cols1(i))
     '   dr3(Cols3(i)) = dr1(Cols1(i))
 Next
Next
 DataTables("订单").Save()
 DataTables("订单号").Save()
'DataTables("hongfu").Save()


 回到顶部