problem with data loading on DataGrid

Question

I am using a DataGrid (.NET 1.1) to which data is being binded from data source which gets almost 3000 rows and 25 columns. Because of heavy data, it is taking around 3 minutes to laod data on to datagrid. I want to load first50 records, then next 50 , then next 50... so on...

How can I achieve this ?.. i tried using Paging option but it loads whole records..

Any ideas ??

Answer 1

Is this the kind of functionality you are looking for?

    Me.DataGrid1.DataSource = DataRange(5, 25, DataSet1.Tables(0))

.

  Private Function DataRange(ByVal Min As Integer, ByVal Max As Integer, ByRef SourceTable As DataTable) As DataTable
    Dim TempTable As DataTable = SourceTable.Clone
    If Max > SourceTable.Rows.Count Then
      Max = SourceTable.Rows.Count
    End If
    For i As Integer = (Min - 1) To (Max - 1)
      TempTable.ImportRow(SourceTable.Rows(i))
    Next
    Return TempTable
  End Function

As decompiled said, make sure the slowness isn't in your query.

Answer 2

What you are looking for is called Data Paging <-- this link provides an in-depth tutorial on data paging in asp.net.

Answer 3

You can check this solution - http://aspnet.4guysfromrolla.com/articles/031506-1.aspx