大数据量时通过滚动条加载数据

收藏

当我加载大数据的时候比较卡，我想通过滚动条到达最底端来加载数据。我好像看过这个问题的解决方案，但是找不到了。版主帮帮忙。

lov4023 · lov4023

博客里面找到个例子但是是点击滚动条下面按钮的

private void Form1_Load(object sender, EventArgs e)
{
fpSpread1.ActiveSheet.RowCount = 50;
fpSpread1.ActiveSheet.ColumnCount = 20;
//fpSpread1.ActiveSheet.RowCount = fpSpread1.ActiveSheet.NonEmptyRowCount;
//fpSpread1.ActiveSheet.ColumnCount = fpSpread1.ActiveSheet.NonEmptyColumnCount;
fpSpread1.HorizontalScrollBar.ButtonClick += new FarPoint.Win.Spread.FpScrollBarButtonClickEventHandler(HorizontalScrollBar_ButtonClick);
fpSpread1.VerticalScrollBar.ButtonClick += new FarPoint.Win.Spread.FpScrollBarButtonClickEventHandler(VerticalScrollBar_ButtonClick);
}
void VerticalScrollBar_ButtonClick(object sender, FarPoint.Win.Spread.FpScrollBarButtonClickEventArgs e)
{
if (fpSpread1.GetViewportBottomRow(0) == fpSpread1.ActiveSheet.RowCount)
{
if (e.Button.ChangeType == FarPoint.Win.Spread.ChangeType.SmallChange)
{
fpSpread1.ActiveSheet.RowCount += 1;
}
}
}
void HorizontalScrollBar_ButtonClick(object sender, FarPoint.Win.Spread.FpScrollBarButtonClickEventArgs e)
{
if (fpSpread1.GetViewportRightColumn(0) == fpSpread1.ActiveSheet.ColumnCount)
{
if (e.Button.ChangeType == FarPoint.Win.Spread.ChangeType.SmallChange)
{
fpSpread1.ActiveSheet.ColumnCount += 1;
}
}
}

复制代码

iceman · iceman

回复 2楼lov4023的帖子

请使用以下代码测试：

private void fpSpread1_TopChange(object sender, FarPoint.Win.Spread.TopChangeEventArgs e)
{
if (this.fpSpread1.GetViewportBottomRow(0, 0) == this.fpSpread1.Sheets[0].RowCount)
{
this.fpSpread1.Sheets[0].Rows.Add(this.fpSpread1.Sheets[0].RowCount, 1);
}
}

复制代码

lov4023 · lov4023

ok 问题解决

iceman · iceman

回复 4楼lov4023的帖子

好的谢谢反馈

		自动登录	找回密码
密码			立即注册

[已处理] 大数据量时通过滚动条加载数据