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


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

主题:[求助]进度条

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


加好友 发短信
等级:五尾狐 帖子:1005 积分:5955 威望:0 精华:0 注册:2015/6/18 5:15:00
[求助]进度条  发帖心情 Post By:2015/8/31 17:41:00 [只看该作者]

老师,我要在窗口中设置一个进度条(导入其他表的数据)。
下面是按钮代码
Dim Cols1() As String = {"代码","名称","涨幅","现价","总手","现手","昨收"}
Dim Cols2() As String = {"代码","名称","涨幅","现价","总手","现手","昨收"}
For Each dr1 As DataRow In DataTables("当天收盘数据").Select("")
    Dim dr2 As DataRow = DataTables("数据库更新").AddNew()
    For i As Integer = 0 To Cols1.Length -1
        dr2(Cols2(i)) = dr1(Cols1(i))
    Next
Next

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


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2015/8/31 17:45:00 [只看该作者]

Dim Cols1() As String = {"代码","名称","涨幅","现价","总手","现手","昨收"}
Dim Cols2() As String = {"代码","名称","涨幅","现价","总手","现手","昨收"}

Dim drs As List(Of DataRow) = DataTables("当天收盘数据").Select("")
Dim p As WinForm.ProgressBar
p = e.Form.Controls("ProgressBar1")
p.Maximum =  drs.Count - 1 '设置最大值
p.Minimum = 0 '设置最小值
p.Value = 0 '设置当前值

For j As Integer = 0 To drs.count - 1
    Dim dr1 As DataRow = drs(j)
    Dim dr2 As DataRow = DataTables("数据库更新").AddNew()
    For i As Integer = 0 To Cols1.Length -1
        dr2(Cols2(i)) = dr1(Cols1(i))
    Next
    p.Value = j
Next


 回到顶部
帅哥哟,离线,有人找我吗?
江南小城
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:五尾狐 帖子:1005 积分:5955 威望:0 精华:0 注册:2015/6/18 5:15:00
  发帖心情 Post By:2015/8/31 18:16:00 [只看该作者]

老师,在导入数据时接收表边框滚动条闪乐,能控制吗?

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


加好友 发短信
等级:贵宾 帖子:39310 积分:196782 威望:0 精华:1 注册:2015/4/25 9:23:00
  发帖心情 Post By:2015/8/31 19:11:00 [只看该作者]


Dim Cols1() As String = {"代码","名称","涨幅","现价","总手","现手","昨收"}
Dim Cols2() As String = {"代码","名称","涨幅","现价","总手","现手","昨收"}

Dim drs As List(Of DataRow) = DataTables("当天收盘数据").Select("")
Dim p As WinForm.ProgressBar
p = e.Form.Controls("ProgressBar1")
p.Maximum =  drs.Count - 1 '设置最大值
p.Minimum = 0 '设置最小值
p.Value = 0 '设置当前值
DataTables("当天收盘数据").StopRedraw
For j As Integer = 0 To drs.count - 1
    Dim dr1 As DataRow = drs(j)
    Dim dr2 As DataRow = DataTables("数据库更新").AddNew()
    For i As Integer = 0 To Cols1.Length -1
        dr2(Cols2(i)) = dr1(Cols1(i))
    Next
    p.Value = j
    Application.Doevents
Next
DataTables("当天收盘数据").ResumeRedraw


 回到顶部