1. Introduction
2. Ways to bind a DataGrid
3. DataGrid Paging and Sorting using a DataReader and Structure Class/ArrayList
4. What's doing above?
5. DataGrid Paging and Sorting using a DataReader with a DataTable/DataView
6. ASP.NET 2.0 GridView Version
7. Conclusion

Comments

1. Dimitrios Markatos
   01 Feb 2009 at 18:11
   Hi Sohail, thanks. Now, If you're looking to squeeze out as much as you can in terms of performance I would go with the ArrayList. It would be faster with less overhead. Nothing really dramatic, rather more efficient.
2. Sohail Merchant
   30 Jan 2009 at 12:16
   Good Article. I have one specific question. I was using Dataset for aspnet 2.0 application until i realized that it is very efficient if you are thinking about performance. I have a girdview with paging feature using dataset. After reading few article i started using datareader and binding them to gridview (with Datatable). i.e. Return SqlHelper.ExecuteReader(GeneralFunctions.GetConnectionString, CommandType.Text, StrQuery) Dim dt As New DataTable dt.Load(EventsDBClient.GETALLRECORDS()) ' about 100 records Me.girdview.DataSource = dt Me.girdview.DataBind() My question is(which might not be the right one excuse me for that), considering my application will not return not more than 100records at one time. do you think datareader in combination with datatable is the right way to go about OR ArrayList/Class would be better? Thanks, Sohail
3. ido nadler
   12 Jul 2007 at 15:14
   Hi all,
   
   What about displaying, sorting etc' data in a DataGird/GridView with a paging mechanism using a scrollbar (not a Next/Previous buttons)??
   
   It seems like no one has ever mention this issue.
   
   Can anyone please help me solve this problem.
   
   Regards ido
   
   
   
   
   
   
   
   
   
   
4. jitendra negi
   25 Nov 2006 at 08:23

   this site is really very good. i  m really a big fan of this site thanks to all

   developerfusion team

    

   jitendra negi

    

5. Martin Stevens
   03 Nov 2006 at 09:29

   Dimitrios thanks for the informative article. I have picked your code apart and tried out a few variants of your sample code which I am looking to implement into some of my web apps.

   I tried a code sample in a web page that used “Data Grid Paging Using a Data Reader Bound Array List” – no caching or dynamic sorting.

   This method still reads all the data even though a small fraction is only displayed on the page. This works well but when I blew the table up to 100,000 records (I was using MS Access in this experiment) it slowed down somewhat. Admittedly it was substantially faster than a similar sample of code using a dataset on the same database (as expected).

    

   My question is;

    

   Is there any way that straight forward data reader + data grid paging can be implemented in such a way that it will only get the records from the database that the webapp actually displays on the page? Any suggestions, directions or web links would be appreciated.

    

6. Cathy Conner
   25 Oct 2006 at 21:37

   I'm working on an app that implements a structure and stores a recordset in an ArrayList based upon the example outlined here.  I used the same to bind to a DataGrid and it worked out so well, I thought it might be a better solution that moving back and forth through a DataSet to perform some simple though numerous calculations. 

   In order to perform these calcs, I have to compare elements of the array checking for duplicates on some columns and then just comparing other elements to strings utilizing IndexOf and LastIndexOf.  Unfortunately I haven't been able to get it to work.  On another site I read that those 2 methods use Object.Equals and as the array contains structure objects, I need to override the Equals function.  That route has been just as unsuccessful. 

   The code below generates an that the index is out of range on the line that assigns the array item to 'last' because the LastIndexOf search returns -1.  Thing is the stored procedure I use to retrieve the recordset guarantees that there would be a match on first.account.  Can anyone point me in the right direction?

   Public Overrides Function Equals(ByVal obj As Object) As Boolean

   If obj Is Nothing Or Not Me.GetType() Is obj.GetType() Then

   Return False

   End If

   Dim d As duplicates = CType(obj, duplicates)

   Return Me.account = d.account

   End Function

    

   'Errant code below

   conn.Open()

   Dim reader As SqlDataReader = cmd.ExecuteReader()

   If reader.HasRows Then

   'Create array to hold entries for accounts tracked more than once per LOB

   Dim arrResults As New ArrayList

   Dim dupEntries As New duplicates

   While reader.Read

   With arrResults

   .Add(

   New duplicates(reader.GetValue(0), reader.GetValue(1), reader.GetValue(2), _

   reader.GetValue(3), reader.GetValue(4), reader.GetValue(5), reader.GetValue(6), _

   reader.GetValue(7), reader.GetValue(8), reader.GetValue(9), reader.GetValue(10), _

   reader.GetValue(11), reader.GetValue(12), reader.GetValue(13), reader.GetValue(14)))

   End With

   End While

   reader.Close()

   Dim first As duplicates

   Dim last As duplicates

   Dim i As Integer

   For i = 0 To arrResults.Count - 1

   first =

   CType(arrResults.Item(i), duplicates)

   Trace.Warn(arrResults.LastIndexOf(first.account))

   last = arrResults.Item(arrResults.LastIndexOf(first.account))

   Trace.Warn(

   "first date" & first.tDate)

   Trace.Warn(

   "last date " & last.tDate)

   Next

   End If

    

7. Cathy Conner
   28 Aug 2006 at 18:57
   I've been searching around, but haven't been able to figure out how to access the individual values.  For example, how would I determine CompanyName for a particular row?
8. Dimitrios Markatos
   18 Jul 2006 at 16:02

   Yeah thanks. No, it does absolutely work, regardless, and even though the "AllowCustomPaging" property isn't part of the Gridview, it does not affect it, as I just copied the code from the article and it ran perfectly. The Gridview simply ignores it, whether set to "True" or "False"

   I would check and make sure it's not something else you may have modified.

   Hope this helps

9. Steve Davis
   17 Jul 2006 at 00:24

   Good article overall.  But the Gridview version cannot work.  One problem is it shows the following property:

   AllowCustomPaging="False"

   that is not available in Gridview.

   
   
   

    

    

10. Rendian Therianto
    30 May 2006 at 11:30

    Hello...

    Can anybody plis post the C# version?

    Thx in advance...

11. Josue Perez
    28 Apr 2006 at 17:48

    Sup everyone...

    I have a datagrid and I want to implement a button that will simulate the datagrid scroll down click button. What events do I need to handle? How to make my datagrid rows to scroll once my button is pressed?

     

12. Baris ERGUN
    23 Apr 2006 at 09:21

    Hello

    The DataReaders read one-way data As I undesrtand you dynamically bind your Oracle Database to your Datagird. Try to convert oracleDataReader  to DataView. DataViews can be red 2 way and they are Compatible with AllowPaging=true

    I have recently sent a Control to Asp.Net I think it is in the proccessing stage that Control converts OdbcDataReader to DataView below is the open code for you to give you an idea. You must apply the same logic to your Oracle Reader

    Good Luck,

    Baris ERGUN

    www.thecoreopsis.com

    public static DataView ConvertToDataView(OdbcDataReader setToCheck, string tableName)

    {

    DataTable dataReaderTable = new DataTable(tableName);

    try

    {

    for(int h=0;h<setToCheck.FieldCount;h++)

    {

    DataColumn temp = new DataColumn(setToCheck.GetName(h),setToCheck.GetFieldType(h));

    dataReaderTable.Columns.Add(temp);

    }

    while(setToCheck.Read())

    {

    DataRow dr = dataReaderTable.NewRow();

    for(int g=0;g<setToCheck.FieldCount;g++)

    {

    dr = setToCheck.GetValue(setToCheck.GetOrdinal(setToCheck.GetName(g)));

    }

    dataReaderTable.Rows.Add(dr);

    }

    return dataReaderTable.DefaultView;

    }

    catch

    {

    return null;

    }

    }

13. Developer Fusion Bot
    01 Jan 1999 at 00:00

    This thread is for discussions of DataGrid/GridView Paging and Sorting Using A DataReader .